Question
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
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. Use the Store and Regional Sales Database developed in Microsoft Access provided below. 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 products should be restocked? Which stores and sales regions would benefit from a promotional campaign and additional marketing? When (what time of year) should products be offered at full price, and when should discounts be used? please use Microsoft access and and the data below when explaining. or please tell me is there anyway i can send you the data Microsoft access. if not at least explain the software skills using pictures of Microsoft Access I need the explanation with the software skills that needed in this questions
Store & Region Sales Database - Sales Region 1 South 1 South 1 South 1 South 1 South 1 South - Item No - Item Description - Unit Price - Units Sold - Week Ending - Click to Add - II - Store No 2005 17" Monitor $229.00 $29.00 27/10/2012 28 24/11/2012 2005 17" Monitor 30 2005 17" Monitor $229.00 29/12/2012 3006 101 Keyboard 3006 101 Keyboard $19.95 27/10/2012 30 $19.95 24/11/2012 35 3006 101 Keyboard $19.95 29/12/2012 39 1 South 1 South 1 South 1 South 1 South 1 South 2 South 6050 PC Mouse $8.95 27/10/2012 24/11/2012 29/12/2012 28 6050 PC Mouse $8.95 $8.95 6050 PC Mouse 38 8500 Desktop CPU 8500 Desktop CPU $849.95 27/10/2012 10 25 $849.95 24/11/2012 11 27 8500 Desktop CPU $849.95 29/12/2012 12 33 27/10/2012 24/11/2012 2005 17" Monitor $229.00 13 $229.00 14 2 South 2005 17" Monitor 2 South 2005 17" Monitor $229.00 29/12/2012 15 10 27/10/2012 3006 101 Keyboard $19.95 16 2 South 24/11/2012 2 South 3006 101 Keyboard $19.95 17 2 South 3006 101 Keyboard $19.95 29/12/2012 18 $8.95 27/10/2012 19 2 South 5050 PC Mouse 2 South 2 South 24/11/2012 6050 PC Mouse $8.95 20 6050 PC Mouse $8.95 29/12/2012 21 $849.95 27/10/2012 22 2 South 8500 Desktop CPU 18 2 South 2 South 3 South 3 South 3 South 3 South 24/11/2012 8500 Desktop CPU $849.95 23 18 $849.95 29/12/2012 24 8500 Desktop CPU 20 2005 17" Monitor $229.00 27/10/2012 25 38 2005 17" Monitor $29.00 24/11/2012 26 30 2005 17" Monitor $229.00 29/12/2012 27 3006 101 Keyboard 27/10/2012 $19.95 28 30 Store & Region Sales Database - Sales Region 1 South 1 South 1 South 1 South 1 South 1 South - Item No - Item Description - Unit Price - Units Sold - Week Ending - Click to Add - II - Store No 2005 17" Monitor $229.00 $29.00 27/10/2012 28 24/11/2012 2005 17" Monitor 30 2005 17" Monitor $229.00 29/12/2012 3006 101 Keyboard 3006 101 Keyboard $19.95 27/10/2012 30 $19.95 24/11/2012 35 3006 101 Keyboard $19.95 29/12/2012 39 1 South 1 South 1 South 1 South 1 South 1 South 2 South 6050 PC Mouse $8.95 27/10/2012 24/11/2012 29/12/2012 28 6050 PC Mouse $8.95 $8.95 6050 PC Mouse 38 8500 Desktop CPU 8500 Desktop CPU $849.95 27/10/2012 10 25 $849.95 24/11/2012 11 27 8500 Desktop CPU $849.95 29/12/2012 12 33 27/10/2012 24/11/2012 2005 17" Monitor $229.00 13 $229.00 14 2 South 2005 17" Monitor 2 South 2005 17" Monitor $229.00 29/12/2012 15 10 27/10/2012 3006 101 Keyboard $19.95 16 2 South 24/11/2012 2 South 3006 101 Keyboard $19.95 17 2 South 3006 101 Keyboard $19.95 29/12/2012 18 $8.95 27/10/2012 19 2 South 5050 PC Mouse 2 South 2 South 24/11/2012 6050 PC Mouse $8.95 20 6050 PC Mouse $8.95 29/12/2012 21 $849.95 27/10/2012 22 2 South 8500 Desktop CPU 18 2 South 2 South 3 South 3 South 3 South 3 South 24/11/2012 8500 Desktop CPU $849.95 23 18 $849.95 29/12/2012 24 8500 Desktop CPU 20 2005 17" Monitor $229.00 27/10/2012 25 38 2005 17" Monitor $29.00 24/11/2012 26 30 2005 17" Monitor $229.00 29/12/2012 27 3006 101 Keyboard 27/10/2012 $19.95 28 30Step 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