Microsoft Access

IDS 200

Summer 2019

Assignment 2

Due Friday 7/5/2019

60 points

Instructions

Deadline

In order to receive full credit, this assignment must be submitted by Friday, July 5th at 11:59pm. Submitting your assignment early is recommended. Late submissions will be accepted (but penalized 15pts) up to one week after the submission deadline. After that, assignments will not be accepted.

Assignment

Using the file CanadianSalesDataReduced.accdb, complete the following:

1) Reports:

· Show all fields of all records, grouped by province and then by region.

· For all product categories, show the sum of sales, grouped by region. You can include the sums using the "Summary Options" button in the third Report Wizard window, where you select ascending or descending order.

2) Queries:

· For all records with a 2010 order date, show the average shipping cost for each product category.

· For each province, show the sum of sales for each ship mode.

· Show all fields of any records with sales at least $1000 and the order priority is high.

· Show all fields of any records with sales at least $1000 or the order priority is high.

· Show the sales and profit (only) of any records from the month of November (any year) from the Quebec region and province.

· For each province, show the sum of sales from the months of October, November, and December. The sum should be for the entire three-month range. Each province and year should have a separate sum value shown.

· Show all fields of any records with a critical order priority if the product category is office supplies or technology.