Spring 202D Assignment 2 Due Friday 22812020 t] points Instructions Deadline In order to receive full credit, this assignment must be submitted by Friday, Feanary 28"1 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 lnvoiceData.accdb, complete the reports & queries below. Before submitting your work, make sure your le has two reports and seven queries. 1] Reports: 1. Show all elds of all records, grouped by OrderPrionty and then by ShipMode. 2. For all product category modes, show the sum of prot 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 elds of any records with Sales less than $1000 AND the ShipMode is Express Air. 2. Show all elds of any records with Sales at least $1500 OR the ShipMode is Express Air. 3. Show the Sales, Prot and ShipDate elds (only) of any records from the month of January (any year) where Region and Province are both Ontario. 4. For all records with a 2010 OrderDate, show the average Sales for each Province. You are taking the average Sales value from all records for a Province, so you should only have one value per province. 5. For each Province, show the sum of Prot for each of its Regions. 6. For each Province, show the sum of Prot from the months of June, July, August, September. and October. The sum should be for the entire vemonth range. Each Province should have a separate value for different years. 7. Show all elds of any records with delivery tnick ShipMode if the DrderPnority is either high or critical