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 Order Priority and then by ShipMode. 2. For all product category modes, 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 less than $1000 AND the Ship Mode is Express Air. 2. Show all fields of any records with Sales at least $1500 OR the ShipMode is Express Air. 3. Show the Sales, Profit and ShipDate fields (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 Profit for each of its Regions. 6. For each Province, show the sum of Profit from the months of June, July, August, September, and October. The sum should be for the entire five-month range. Each Province should have a separate value for different years. 7. Show all fields of any records with delivery truck Ship Mode if the Order Priority is either high or critical 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 Order Priority and then by ShipMode. 2. For all product category modes, 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 less than $1000 AND the Ship Mode is Express Air. 2. Show all fields of any records with Sales at least $1500 OR the ShipMode is Express Air. 3. Show the Sales, Profit and ShipDate fields (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 Profit for each of its Regions. 6. For each Province, show the sum of Profit from the months of June, July, August, September, and October. The sum should be for the entire five-month range. Each Province should have a separate value for different years. 7. Show all fields of any records with delivery truck Ship Mode if the Order Priority is either high or critical