Retail company to convert data in Microsoft Excel spreadsheets
Not what you're looking for?
Explain the usefulness and benefits for a retail company to convert data held in Microsoft Excel spreadsheets into a relational database using Microsoft Access.
Purchase this Solution
Solution Summary
The expert examines a retail company converting data in Microsoft Excel spreadsheets.
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 ...
Purchase this Solution
Free BrainMass Quizzes
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
Learning Lean
This quiz will help you understand the basic concepts of Lean.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.