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.

View More Free Quizzes
Related BrainMass Solutions

  • Normalization of an Excel Spreadsheet

    NO references required for this task :-) How do you convert excel spreadsheets into an RDBMS? along with an erd diagram? i am stumped! I NEED examples using the supplied excel spreadsheets!

  • MS Excel

    264240 Excel Details: Your regional manager is impressed with how you have used spreadsheets to assist your small company in saving time and more accurately figuring out payroll amounts.

  • Project Management Tools.

    Use the Copy Picture to Office Wizard to smoothly export Project data into Microsoft Office Word for formal documents, Office Excel 2007 for custom charts or spreadsheets, or Microsoft Office PowerPoint for crisp presentations.

  • Office automation and group collaboration software

    Office automation software ================== Word processors, like Microsoft Word Presentation software like Microsoft Power Point Microsoft Outlook Spreadsheets like Microsoft Excel Microsoft Access Colloboration software =============

  • MS Excel as a Tool for Interpreting Data

    To perform Data analysis skills using Microsoft Excel: For example, managers use Excel to transform the information in spreadsheets, databases, and servers into faster, better business decisions.

  • Use of MS Excel as a Management Tool

    To give you a great example for this, in a previous position as Director of MIS for a retail company, I utilized MS Excel to download sales information from polled files from the 25 stores the company had.

  • MS Excel: Tool For Interpreting Data

    - To perform Data analysis skills using Microsoft Excel: For example, managers use Excel to transform the information in spreadsheets, databases, and servers into faster, better business decisions.

  • Data Transformation Services

    287305 Data Transformation Services How can Data Transformation Services (DTS) be used for data manipulation in SQL Server? Microsoft DTS is a data manipulation tool.

  • Uses of Word Processing, Spreadsheets, and Databases

    We would use a spreadsheet application like Microsoft Excel when we have to prepare an internal expense report to send to our accounting department in order to be reimbursed for our expenses.

View More Related Solutions