You have new items in your feed. Click to view.
Question and answer
Q: Explain the usefulness of converting data currently held in Microsoft® Excel® spreadsheets into a relational database using Microsoft® Access®.
A: 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
Get an answer
New answers
Rating

There are no new answers.

Comments

There are no comments.

Add an answer or comment
Log in or sign up first.
27,009,461 questions answered
Popular Conversations
The pitcher does not have the responsibility of striking out players ...
Weegy: The pitcher does not have the responsibility of striking out players at bat. FALSE.
5/15/2017 8:53:53 PM| 0 Answers
Rape that involves multiple attackers, strangers, weapons, or a ...
Weegy: Rape that involves multiple attackers, strangers, weapons, or a physical beating is Aggravated Rape.
5/15/2017 7:06:49 PM| 0 Answers
Giving human characteristics to objects or ideas is
Weegy: Giving human characteristics to objects or ideas is PERSONIFICATION.
5/19/2017 10:58:38 PM| 0 Answers
Motivation refers to forces that
Weegy: Motivation refers to forces that: energize, direct, and sustain a person's efforts.
5/19/2017 10:41:24 PM| 0 Answers
The end of the Triassic period was possibly caused by the large zone ...
Weegy: The end of the Triassic period was possibly caused by the large zone that developed due to Pangaea breaking up. ...
5/17/2017 6:08:25 AM| 0 Answers
These are used primarily as food additives for their emulsifying, or ...
Weegy: Monoglycerides and diglycerides are used primarily as food additives for their emulsifying, or blending, ...
5/17/2017 5:14:37 AM| 0 Answers
Which of the following people is most likely to be destitute? A. ...
Weegy: A homeless man is most likely to be destitute.
5/22/2017 5:55:30 PM| 0 Answers
In “A Few Don’ts,” Pound encourages the use of __________instead of ...
Weegy: In A Few Don'ts, Pound encourages the use of The Concrete instead of the vagueness of abstractions. User: ...
5/22/2017 11:51:10 AM| 0 Answers
We tend to feel less _____ when more people are around to help out. ...
Weegy: We tend to feel less responsible when more people are around to help out.
5/22/2017 11:51:24 AM| 0 Answers
T.S. Eliot was a A. Romantic Poet B. Neo-Classical Poet C. ...
Weegy: T.S. Eliot was a Modern Poet.
5/21/2017 5:18:53 PM| 0 Answers
Weegy Stuff
S
Points 26 [Total 26] Ratings 0 Comments 26 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Offline
S
Points 10 [Total 366] Ratings 1 Comments 0 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Offline
S
P
P
L
P
P
P
Points 7 [Total 1730] Ratings 0 Comments 7 Invitations 0 Offline
S
Points 2 [Total 2] Ratings 0 Comments 2 Invitations 0 Offline
S
Points 2 [Total 467] Ratings 0 Comments 2 Invitations 0 Offline
S
Points 2 [Total 2] Ratings 0 Comments 2 Invitations 0 Offline
S
P
P
L
P
P
Points 1 [Total 1637] Ratings 0 Comments 1 Invitations 0 Offline
S
Points 1 [Total 2] Ratings 0 Comments 1 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.