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
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.
Questions asked by the same visitor
Can smartphones be used as a telemetry device?
Weegy: no, smartphones can not be used as telemetry devices. (More)
Question
Expert Answered
Asked 8/24/2012 6:37:24 PM
0 Answers/Comments
What are the benefits of telemetry in health care for the elderly?
Weegy: I'm not sure if this is the type of telemetry you are talking about, however, many years ago I worked on a cardiac telemetry unit as an RN. [ They were simply electronic devices attached to the person which gave a continuous EKG readout to a monitor at the nurses station. The nurse could watch the monitor to observe any abnormalities in the heart function and run strips (print out) the EKG. ] (More)
Question
Expert Answered
Asked 8/24/2012 6:27:47 PM
0 Answers/Comments
What are the benefits of Wireless Medical Telemetry Service in health care for the elderly
Weegy: I'm not sure if this is the type of telemetry you are talking about, however, many years ago I worked on a cardiac telemetry unit as an RN. [ [ They were simply electronic devices attached to the person which gave a continuous EKG readout to a monitor at the nurses station. The nurse could watch the monitor to observe any abnormalities in the heart function and run strips (print out) the EKG. ] ] (More)
Question
Expert Answered
Asked 8/24/2012 6:39:46 PM
0 Answers/Comments
hello
Weegy: Hi! What can I research for u today? User: Describe the benefits of using Microsoft® Access® in the work environment. Weegy: As a desktop database, Access is well suited for small, departmental applications. These applications may start as one user’s project. [ For example, an employee realizes that productivity can be increased if a paper-based process is automated with an Access application. Other users in the department recognize that they can take advantage of the application if additional features are added. As more features are added, more employees run the application. As time goes by, more and more Access applications are deployed for different business units. ] (More)
Question
Expert Answered
Asked 8/25/2012 10:55:44 AM
0 Answers/Comments
17,919,615 questions answered
Popular Conversations
what is micro
Weegy: A microorganism is a microscopic organism, which may be a single cell or multicellular organism. User: what ...
10/21/2014 7:38:45 PM| 3 Answers
Solve the inequality. 2(4 + x) > 4(x + 4) A. x > 4 B. x > ...
Weegy: 2w + 3 > 14; 2w > 14 - 3; 2w > 11; w > 11/2 User: Solve the inequality. 5a + 12 6 B. a < 6 C. D.
10/21/2014 12:59:56 PM| 3 Answers
Anime
10/21/2014 9:41:19 AM| 2 Answers
what are quadratic equations
Weegy: You can apply quadratic equation to cook marshmallows by following these steps: 1. Select a quadratic ...
10/21/2014 10:48:49 AM| 2 Answers
What is the solution set of 2x ^2 - 3x = 5?
10/21/2014 11:05:05 AM| 2 Answers
Simplify -(-2a + 13) + (-9a - 2) - (-7a - 3).
Weegy: -(-2a + 13) + (-9a - 2) - (-7a - 3) = (-7a - 15) - (-7a - 3) = -12
10/21/2014 11:12:50 AM| 2 Answers
Determine the solution set of (x + 1)2 = 25. {-8, 6} {-8, ...
Weegy: The answer is 77,520. There are 77,520 possible committees that can be formed.
10/21/2014 11:18:30 AM| 2 Answers
Simplify (x - y + 1) - (x + y - 1).
Weegy: (x - 4)(x + 3) = x^2 + 3x - 4x - 12 = x^2 - x - 12
10/21/2014 11:19:54 AM| 2 Answers
Solve the inequality 4x User: x + 1/2 < 1/4
10/21/2014 11:27:18 AM| 2 Answers
Simplify p(p - q) - q(q - p).
Weegy: 3 - (2 - 8) = 3 - (-6) = 3 + 6; = 9
10/21/2014 11:46:35 AM| 2 Answers
Social welfare User: stigma
10/21/2014 12:28:06 PM| 2 Answers
Weegy Stuff
S
L
1
1
1
1
L
1
L
Points 2267 [Total 14642]| Ratings 0| Comments 2267| Invitations 0|Offline
S
L
1
L
P
C
1
P
C
1
L
Points 1464 [Total 10945]| Ratings 3| Comments 1434| Invitations 0|Offline
S
1
L
1
L
P
P
L
Points 781 [Total 13010]| Ratings 0| Comments 781| Invitations 0|Offline
S
L
Points 487 [Total 1886]| Ratings 0| Comments 487| Invitations 0|Offline
S
Points 479 [Total 479]| Ratings 0| Comments 449| Invitations 3|Offline
S
1
L
L
Points 474 [Total 6268]| Ratings 3| Comments 444| Invitations 0|Offline
S
Points 352 [Total 353]| Ratings 4| Comments 312| Invitations 0|Offline
S
Points 207 [Total 207]| Ratings 1| Comments 197| Invitations 0|Offline
S
P
C
L
P
L
1
Points 48 [Total 6282]| Ratings 0| Comments 48| Invitations 0|Offline
S
Points 27 [Total 27]| Ratings 0| Comments 27| Invitations 0|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.