Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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 30

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Pro Database Migration To Azure Data Modernization For The Enterprise

Authors: Kevin Kline, Denis McDowell, Dustin Dorsey, Matt Gordon

1st Edition

1484282299, 978-1484282298

More Books

Students also viewed these Databases questions

Question

=+39-1 Explain how hormones influence human sexual motivation.

Answered: 1 week ago

Question

What is readily determinable fair value as per FAS 115?

Answered: 1 week ago