3 to 5 pages please

You have learned both Excel and Access and completed the discussion questions summarizing what you have learned, comparing the differences between Excel and Access, and explaining how spreadsheets and databases can be used in businesses. To apply your knowledge, read the following case study and thoroughly answer the six questions at the end.

Ted owns a retail store in Baltimore. He would like to retain customer information, keep track of sales records, and manage the store inventories to better serve customers and expand the potential market. He currently completes all of his record-keeping using a paper-based ledger and uses Excel only to prepare his annual income statement for his tax return.

Ted has hope of expanding his single local store to a number of regional stores. To grow his business, he knows that he needs to obtain more information on his customers, their preferences, and their demographic and geographic information. He also needs to analyze past and current sales data and improve his inventory management practices. However, with the current, mostly paper-based method, Ted has been unsuccessful in capturing all the information and conducting necessary analyses. In addition, with the potential business growth, he also needs to keep track of employees salary, productivity, working hours, and so on, all of which poses another challenge to the current recording-keeping method. To help Ted out, please answer the following questions:

What are some of the specific issues Ted faces?

How could the use of spreadsheets or a database management system assist Ted with his issues?

What would you use, spreadsheets or a relational database management system, to record, update, and manage customer information, sales records, inventories, and employee information?

Will spreadsheets or a relational database management system effectively assist Ted in obtaining information for his expansion, making decisions about the efficiency of his current operations, and organizing overall data related to the stores inventory, sales, etc.?

What details can you provide to support your choices or recommendations to Ted? You should use the information provided in this case study and what you have learned from the course projects to answer this question.

Discuss the advantages of using spreadsheets or a relational database management system to assist Ted with his current operations and aspirations of expansion.

Please carefully proofread your work prior to submission. In addition, if you refer to the book and other materials or web sites in your writing, you must provide corresponding citations and references accordingly, using APA standard citation format.