Purchase Solution

Retail company to convert data in Microsoft Excel spreadsheets

Not what you're looking for?

Ask Custom Question

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.