Assignment

Using the file InvoiceData.accdb, complete the reports & queries below. Before submitting your work, make sure your file has two reports and seven queries.

1) Reports:

1. Show all fields of all records, grouped by ShipMode and then by OrderPriority
2. For each ShipMode, show the sum of profit grouped by ProductContainer. 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:

1. Show all fields of any records with Sales at least $1000 AND the ShipMode is Express Air.
2. Show all fields of any records with Sales below $1000 OR the ShipMode is Express Air.
3. Show the Sales, OrderDate and ShipDate fields (only) of any records where the OrderDate is in April (any year) and the Province is Alberta.
4. Show average Sales for each Province, using all records with a 2011 OrderDate. You should only have one average value per province.
5. For each Region, show the sum of Profit for each of its Provinces. You should have one sum for each {Region, Province} pair.
6. For each Province and year, show the sum of Profit from the months of July, August, and September (use OrderDate). The sum should be for the entire three-month range. Each Province should have a separate value for each {Province, year} pair.
7. Show all fields of any records with delivery truck ShipMode if the ProductContainer is Jumbo Drum.