access-query design for RELIABLE PAPERS

Adding Value to Data for Management Decision Making Effective information systems add value to data to create meaningful information for management decisions that improve business performance.

In your instructor’s outbox folder on \\labdatashares, you will find a Store and Regional Sales Data Warehouse from 2014 (named SalesDataAnalysis.accdb) containing summarized data on weekly store sales of computer equipment in various sales regions. The database includes fields for store identification number, sales region, item description, unit price, units sold, and the weekly sales period when the sales were made.

Copy each of the following questions into a Word document. For each question, create the necessary query in Access sorted in descending order by the calculated field(s), then copy and paste the resulting dynaset into the Word document. Print and hand in your Word document. Note: please use the Item Description field rather than the Item Number field in your queries for readability.

1. Which are the best performing sales regions by Total Sales?

2. Which are the best performing stores by Total Sales?

3. What are the best-selling products by Total Sales?

4. Which are the best performing sales regions by Units Sold?

5. Which are the best performing stores by Units Sold?

6. What are the best-selling products by Units Sold?

7. Which are the best performing sales regions by Weekly Sales? (Sort by weeks, then by total sales)

8. What are the best-selling products by Weekly Sales? (Sort by weeks, then by total sales)

9. Which are the strongest stores by Weekly Sales? (Sort by weeks, then by total sales)

10. How can your company improve sales in the weakest store and sales region?