Explore BrainMass

Explore BrainMass

    Retail company to convert data in Microsoft Excel spreadsheets

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Explain the usefulness and benefits for a retail company to convert data held in Microsoft Excel spreadsheets into a relational database using Microsoft Access.

    © BrainMass Inc. brainmass.com March 4, 2021, 11:45 pm ad1c9bdddf

    Solution Preview

    Information Systems

    Many companies or businesses use the Excel spreadsheet to track their sales. Some companies have been using a spreadsheet for so long and with time with so much data there could be some drawbacks to using the spreadsheet. In an Excel spreadsheet, data can be displayed in chart form, or tables, displaying the data in different forms; however, it can be quite cumbersome when having to retrieve data. Plus, the spreadsheet offers little or no data validation as well as little or no protection against data corruption from poorly trained users ("Spreadsheet vs. Database", 2012). Plus you are limited by the number of rows you can use to store data. Therefore, for a retail company that has a lot of data from sales, customer information, and employee information and so forth it would be more viable to convert such data from the spreadsheet into a relational database.

    Microsoft Access provides users with a much simpler solution and the number of rows and the number of ...

    Solution Summary

    The expert examines a retail company converting data in Microsoft Excel spreadsheets.