Hard Work

CIS 600 - Problem 1 (download the Access database from: http://www.prenhall.com/laudon/)
Complete the database project exercise on page 30 (Using Databases to Analyze Sales Trends).  Develop thenecessary reports and queries to make the information more useful for running the business.  Provide answers to the following questions (Provide support for your answers):
• Which products should berestocked?
• 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 whenshould discounts be used?
• What other questions should you ask about this business?

[pic]
Figure 1

As depicted in Figure 1, 12 reports (based on 12 queries) have been created to betterunderstand the data contained in the Store & Region Sales Database table. This is how you “provide support” for your answers. The first query, “Best Performing Regions by Total Sales” is also show indesign view to help you get started. Notice that the query uses two columns, one of which is the Sales Region field from the table and the other is an expression that calculates the Weekly SalesTotals, specifically, Weekly Sales: Sum([Unit Price]*[Units Sold]).
Best Performing Regions by Total Sales

Weekly Sales Sales Region
$529,124.80 East

$234,595.05 South

$233,832.75 NorthFigure 2

Figure 2 shows the report based on the “Best Performing Regions by Total Sales” query. This report was simply generated by a Report Wizard.

[pic]
Figure 3

The design view of the query,“Strongest Sales Region by Product Quantity” is shown in Figure 3. The corresponding report is shown is Figure 4 on the following page.
Strongest Sales Region by Product Quantity

Item No ItemDescription SumOfUnits Sold Sales Region
2005
17" Monitor 328 East
17" Monitor 164 South
17" Monitor 117 North
Summary for 'Item No' = 2005 (3 detail records)
Sum 609
Standard 19.17%...