Question
PLEASE RESPOND IN AN HOUR. In this project, you will start out with raw transactional sales data and use Microsoft Access database software to develop
PLEASE RESPOND IN AN HOUR.
In this project, you will start out with raw transactional sales data and use Microsoft Access database software to develop queries and reports that help managers make better decisions about product pricing, sales promotions, and inventory replenishment. In the following attached file, you can find a Store and Regional Sales Database developed in Microsoft Access. The database contains raw data on weekly store sales of computer equipment in various sales regions. The database includes fields for store identification number, sales region, item number, item description, unit price, units sold, and the weekly sales period when the sales were made. Use Access to develop some reports and queries to make this information more useful for running the business. Sales and production managers want answers to the following questions:
- Which product is the best seller by quantity?
-
Best performing region by total sales?
Database file you will need: MIS14ch01_questionfile.mdb
Create 2 queries to answer the above questions. Then create 2 reports based on the 2 queries you have created. Save the database file. Name your file in the following format [Assignment2]_[YourFirstName]_[YourLastName]. (e.g. Assignment2_Bob_Lee). Submit the database file before the due date.
| ID | Store No | Sales Region | Item No | Item Description | Unit Price | Units Sold | Week Ending |
|---|---|---|---|---|---|---|---|
| 1 | 1 | South | 2005 | 17" Monitor | $229.00 | 28 | 10/27/2014 |
| 2 | 1 | South | 2005 | 17" Monitor | $229.00 | 30 | 11/24/2014 |
| 3 | 1 | South | 2005 | 17" Monitor | $229.00 | 9 | 12/29/2014 |
| 4 | 1 | South | 3006 | 101 Keyboard | $19.95 | 30 | 10/27/2014 |
| 5 | 1 | South | 3006 | 101 Keyboard | $19.95 | 35 | 11/24/2014 |
| 6 | 1 | South | 3006 | 101 Keyboard | $19.95 | 39 | 12/29/2014 |
| 7 | 1 | South | 6050 | PC Mouse | $8.95 | 28 | 10/27/2014 |
| 8 | 1 | South | 6050 | PC Mouse | $8.95 | 3 | 11/24/2014 |
| 9 | 1 | South | 6050 | PC Mouse | $8.95 | 38 | 12/29/2014 |
| 10 | 1 | South | 8500 | Desktop CPU | $849.95 | 25 | 10/27/2014 |
| 11 | 1 | South | 8500 | Desktop CPU | $849.95 | 27 | 11/24/2014 |
| 12 | 1 | South | 8500 | Desktop CPU | $849.95 | 33 | 12/29/2014 |
| 13 | 2 | South | 2005 | 17" Monitor | $229.00 | 8 | 10/27/2014 |
| 14 | 2 | South | 2005 | 17" Monitor | $229.00 | 8 | 11/24/2014 |
| 15 | 2 | South | 2005 | 17" Monitor | $229.00 | 10 | 12/29/2014 |
| 16 | 2 | South | 3006 | 101 Keyboard | $19.95 | 8 | 10/27/2014 |
| 17 | 2 | South | 3006 | 101 Keyboard | $19.95 | 8 | 11/24/2014 |
| 18 | 2 | South | 3006 | 101 Keyboard | $19.95 | 8 | 12/29/2014 |
| 19 | 2 | South | 6050 | PC Mouse | $8.95 | 9 | 10/27/2014 |
| 20 | 2 | South | 6050 | PC Mouse | $8.95 | 9 | 11/24/2014 |
| 21 | 2 | South | 6050 | PC Mouse | $8.95 | 8 | 12/29/2014 |
| 22 | 2 | South | 8500 | Desktop CPU | $849.95 | 18 | 10/27/2014 |
| 23 | 2 | South | 8500 | Desktop CPU | $849.95 | 18 | 11/24/2014 |
| 24 | 2 | South | 8500 | Desktop CPU | $849.95 | 20 | 12/29/2014 |
| 25 | 3 | South | 2005 | 17" Monitor | $229.00 | 38 | 10/27/2014 |
| 26 | 3 | South | 2005 | 17" Monitor | $229.00 | 30 | 11/24/2014 |
| 27 | 3 | South | 2005 | 17" Monitor | $229.00 | 3 | 12/29/2014 |
| 28 | 3 | South | 3006 | 101 Keyboard | $19.95 | 30 | 10/27/2014 |
| 29 | 3 | South | 3006 | 101 Keyboard | $19.95 | 32 | 11/24/2014 |
| 30 | 3 | South | 3006 | 101 Keyboard | $19.95 | 33 | 12/29/2014 |
| 31 | 3 | South | 6050 | PC Mouse | $8.95 | 25 | 10/27/2014 |
| 32 | 3 | South | 6050 | PC Mouse | $8.95 | 5 | 11/24/2014 |
| 33 | 3 | South | 6050 | PC Mouse | $8.95 | 26 | 12/29/2014 |
| 34 | 3 | South | 8500 | Desktop CPU | $849.95 | 28 | 10/27/2014 |
| 35 | 3 | South | 8500 | Desktop CPU | $849.95 | 27 | 11/24/2014 |
| 36 | 3 | South | 8500 | Desktop CPU | $849.95 | 29 | 12/29/2014 |
| 37 | 4 | North | 2005 | 17" Monitor | $229.00 | 18 | 10/27/2014 |
| 38 | 4 | North | 2005 | 17" Monitor | $229.00 | 20 | 11/24/2014 |
| 39 | 4 | North | 2005 | 17" Monitor | $229.00 | 4 | 12/29/2014 |
| 40 | 4 | North | 3006 | 101 Keyboard | $19.95 | 12 | 10/27/2014 |
| 41 | 4 | North | 3006 | 101 Keyboard | $19.95 | 24 | 11/24/2014 |
| 42 | 4 | North | 3006 | 101 Keyboard | $19.95 | 36 | 12/29/2014 |
| 43 | 4 | North | 6050 | PC Mouse | $8.95 | 29 | 10/27/2014 |
| 44 | 4 | North | 6050 | PC Mouse | $8.95 | 11 | 11/24/2014 |
| 45 | 4 | North | 6050 | PC Mouse | $8.95 | 38 | 12/29/2014 |
| 46 | 4 | North | 8500 | Desktop CPU | $849.95 | 21 | 10/27/2014 |
| 47 | 4 | North | 8500 | Desktop CPU | $849.95 | 24 | 11/24/2014 |
| 48 | 4 | North | 8500 | Desktop CPU | $849.95 | 30 | 12/29/2014 |
| 49 | 5 | North | 2005 | 17" Monitor | $229.00 | 27 | 10/27/2014 |
| 50 | 5 | North | 2005 | 17" Monitor | $229.00 | 25 | 11/24/2014 |
| 51 | 5 | North | 2005 | 17" Monitor | $229.00 | 23 | 12/29/2014 |
| 52 | 5 | North | 3006 | 101 Keyboard | $19.95 | 80 | 10/27/2014 |
| 53 | 5 | North | 3006 | 101 Keyboard | $19.95 | 82 | 11/24/2014 |
| 54 | 5 | North | 3006 | 101 Keyboard | $19.95 | 75 | 12/29/2014 |
| 55 | 5 | North | 6050 | PC Mouse | $8.95 | 65 | 10/27/2014 |
| 56 | 5 | North | 6050 | PC Mouse | $8.95 | 24 | 11/24/2014 |
| 57 | 5 | North | 6050 | PC Mouse | $8.95 | 55 | 12/29/2014 |
| 58 | 5 | North | 8500 | Desktop CPU | $849.95 | 55 | 10/27/2014 |
| 59 | 5 | North | 8500 | Desktop CPU | $849.95 | 57 | 11/24/2014 |
| 60 | 5 | North | 8500 | Desktop CPU | $849.95 | 47 | 12/29/2014 |
| 61 | 6 | East | 2005 | 17" Monitor | $229.00 | 24 | 10/27/2014 |
| 62 | 6 | East | 2005 | 17" Monitor | $229.00 | 85 | 11/24/2014 |
| 63 | 6 | East | 2005 | 17" Monitor | $229.00 | 56 | 12/29/2014 |
| 64 | 6 | East | 3006 | 101 Keyboard | $19.95 | 52 | 10/27/2014 |
| 65 | 6 | East | 3006 | 101 Keyboard | $19.95 | 58 | 11/24/2014 |
| 66 | 6 | East | 3006 | 101 Keyboard | $19.95 | 69 | 12/29/2014 |
| 67 | 6 | East | 6050 | PC Mouse | $8.95 | 35 | 10/27/2014 |
| 68 | 6 | East | 6050 | PC Mouse | $8.95 | 39 | 11/24/2014 |
| 69 | 6 | East | 6050 | PC Mouse | $8.95 | 44 | 12/29/2014 |
| 70 | 6 | East | 8500 | Desktop CPU | $849.95 | 78 | 10/27/2014 |
| 71 | 6 | East | 8500 | Desktop CPU | $849.95 | 88 | 11/24/2014 |
| 72 | 6 | East | 8500 | Desktop CPU | $849.95 | 99 | 12/29/2014 |
| 73 | 7 | East | 2005 | 17" Monitor | $229.00 | 34 | 10/27/2014 |
| 74 | 7 | East | 2005 | 17" Monitor | $229.00 | 36 | 11/24/2014 |
| 75 | 7 | East | 2005 | 17" Monitor | $229.00 | 35 | 12/29/2014 |
| 76 | 7 | East | 3006 | 101 Keyboard | $19.95 | 49 | 10/27/2014 |
| 77 | 7 | East | 3006 | 101 Keyboard | $19.95 | 47 | 11/24/2014 |
| 78 | 7 | East | 3006 | 101 Keyboard | $19.95 | 48 | 12/29/2014 |
| 79 | 7 | East | 6050 | PC Mouse | $8.95 | 45 | 10/27/2014 |
| 80 | 7 | East | 6050 | PC Mouse | $8.95 | 42 | 11/24/2014 |
| 81 | 7 | East | 6050 | PC Mouse | $8.95 | 45 | 12/29/2014 |
| 82 | 7 | East | 8500 | Desktop CPU | $849.95 | 55 | 10/27/2014 |
| 83 | 7 | East | 8500 | Desktop CPU | $849.95 | 57 | 11/24/2014 |
| 84 | 7 | East | 8500 | Desktop CPU | $849.95 | 55 | 12/29/2014 |
| 85 | 8 | East | 2005 | 17" Monitor | $229.00 | 18 | 10/27/2014 |
| 86 | 8 | East | 2005 | 17" Monitor | $229.00 | 17 | 11/24/2014 |
| 87 | 8 | East | 2005 | 17" Monitor | $229.00 | 23 | 12/29/2014 |
| 88 | 8 | East | 3006 | 101 Keyboard | $19.95 | 22 | 10/27/2014 |
| 89 | 8 | East | 3006 | 101 Keyboard | $19.95 | 18 | 11/24/2014 |
| 90 | 8 | East | 3006 | 101 Keyboard | $19.95 | 22 | 12/29/2014 |
| 91 | 8 | East | 6050 | PC Mouse | $8.95 | 14 | 10/27/2014 |
| 92 | 8 | East | 6050 | PC Mouse | $8.95 | 16 | 11/24/2014 |
| 93 | 8 | East | 6050 | PC Mouse | $8.95 | 17 | 12/29/2014 |
| 94 | 8 | East | 8500 | Desktop CPU | $849.95 | 32 | 10/27/2014 |
| 95 | 8 | East | 8500 | Desktop CPU | $849.95 | 28 | 11/24/2014 |
| 96 | 8 | East | 8500 | Desktop CPU | $849.95 | 30 | 12/29/2014 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Learning MySQL Get A Handle On Your Data
Authors: Seyed M M Tahaghoghi
1st Edition
0596529465, 9780596529468
