Question and answer
Explain the usefulness of converting data currently held in Microsoft® Excel® spreadsheets into a relational database using Microsoft® Access®.
Microsoft Access has evolved into very user friendly tool and has become simple to learn. It provides for the easier adding, subtracting, and altering of data once the database. [ Access offers the ability to construct queries to extract reports from the database to analyze all aspects of the data captured in the database (Grauer, 2011). Whereas this is possible in Excel, it is much more
cumbersome. Access also offers the ability for more than one user to update tables at the same time but will not allow for the updating of one record by two individuals at the same time. Access offers the ability to apply rules while entering data so the product will contain the data needed to make calculated business decisions. Access offers the ability to create many reports from the same data set to learn different things about the business (Debasis, 2009). Benefits of Converting Current Data to Microsoft Access By converting the data we currently hold in Microsoft Excel spreadsheets to Microsoft Access, we will be able to track different aspects of our business more effectively. We will also be able to use the reports we will be able to run to drive positive business results. Building a database to capture the data surrounding our business we will be better able to employee records. Once all of the data has been entered in Access, we will be able to track sales trends by associate. We will also be able to track the buying patterns of our customers allowing us to stock the appropriate items by sales surges. Our sales force will be able to use the database to more effectively streamline their work and understand how to be more productive with our customers. While many of the items listed above are possible in Microsoft Excel, the data must be inputted to the spreadsheets and work books and can be more difficult to find the information the user is looking for. ]
Expert answered|petals29|Points 53|
Question
Asked 8/25/2012 10:51:18 AM
0 Answers/Comments
Ask a question
Not a good answer? Get an answer now. (Free)
New answers
Rating

There are no new answers.

Comments

There are no comments.

Add an answer or comment
Log in or sign up first.
16,945,203 questions answered
Popular Conversations
Solve. (10x - 2) = 4
Weegy: 77 = 10x - 3; 77 + 3 = 10x; 80 = 10x; x = 80/10; x = 8 User: 1/6(10x - 2) = 4 Weegy: 77 = 10x - 3; 77 + 3 ...
7/26/2014 1:22:25 PM| 4 Answers
When is the May/June 2014 Waec result coming out?
Weegy: It is already out, to check the result please do the following: Waec Result Checker online for 2014 1 Enter ...
7/26/2014 3:07:28 AM| 2 Answers
People who have the genetic disorder called hemophilia suffer from ...
Weegy: People who have the genetic disorder called hemophilia suffer from abnormally low levels of oxygen in the blood ...
7/27/2014 6:19:14 AM| 2 Answers
calculate the sum of 1/4 and 1/5
Weegy: 1/4 + 1/5 = 9/20 User: calculate the sum of 1/9 and 1/4 Weegy: 1/9 + 1/8 = 17/72
7/27/2014 3:52:21 PM| 2 Answers
A peer group is a _______ group composed of equal age individuals ...
Weegy: A peer group is a primary group composed of equal age individuals with similar characteristics. User: The ...
7/27/2014 5:21:49 PM| 2 Answers
Weegy Stuff
S
R
L
1
1
P
C
1
P
1
1
L
P
C
P
C
1
P
C
L
P
C
1
P
C
Points 2223 [Total 21223]| Ratings 1| Comments 2213| Invitations 0|Offline
S
L
P
C
P
C
1
L
P
C
L
P
C
P
C
P
C
Points 2094 [Total 17223]| Ratings 0| Comments 2094| Invitations 0|Offline
S
L
P
C
L
P
C
P
C
L
P
C
P
C
Points 1901 [Total 14456]| Ratings 1| Comments 1891| Invitations 0|Offline
S
L
1
Points 1526 [Total 3709]| Ratings 2| Comments 1506| Invitations 0|Offline
S
L
1
1
1
1
L
1
Points 1284 [Total 7461]| Ratings 2| Comments 1264| Invitations 0|Offline
S
1
L
Points 1093 [Total 3229]| Ratings 7| Comments 1023| Invitations 0|Online
S
1
L
1
L
P
P
L
Points 920 [Total 10528]| Ratings 0| Comments 920| Invitations 0|Offline
S
1
L
Points 807 [Total 4483]| Ratings 2| Comments 787| Invitations 0|Offline
S
P
C
L
P
L
1
Points 772 [Total 5826]| Ratings 4| Comments 732| Invitations 0|Online
S
Points 275 [Total 423]| Ratings 2| Comments 255| Invitations 0|Offline
Home | Contact | Archive | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.