Assignment Using the le lnvoiceDataaccdb, complete the reports 3: queries below. Before submitting your work, make sure your le has two reports and seven queries. 1) Reports: 1. For each pm show the average of Sales, grouped by Province. You can include the averages using the "Summary Options" button in the third Report Wizard window, where you select ascending or descending order choose the summary (average) only, not summary and details. You should use the Layout View to adjust the size of any text boxes too small to display the Sales values. 2. Show the sum of Prot for each {Region, Province} pair. Group the records by Egg, then Province, and only show the sum of Prot, @ other details. 2] Queries: 1. Show the ID, mum, and mm elds (only) of any records where the Male is between 1l1i'2020 and $151020 and the Wis 1v'li'rap Bag. 2. For each Region, show the sum of Sales for each W. You should have one sum for each {Region same pair 3. Show the Sales and Prot elds {only) of any records with Sales at least $5130 AND the We Is Express Air. 4. For each Province, show the sum of Prot from the months of July through September (use W}. The sum should be for the entire threemonth range, with separate totals for each year. Show all elds of any records with Sales above $1200 AND the W935 Is Technology. Show average Prot for each pm for all records with a 2019 N. You should only have one average value per mm level. 7'. Show all elds of any records where the W is Express Air and the mm is not Small Box or Small Pack {in the query criteria, you can use the "*1?" operator for \"not equal to"). P39" Invoices X X ID ROWID OrderDate . OrderPriority - OrderQuantit . Sales ShipMode . Profit UnitPrice * ShippingCost . Province Region ProductCate . ProductCont 1 10/13/2019 Low 6 $261.54 Regular Air $213.25 $38.94 $35.00 Nunavut Nunavut Office Supplies Large Box IN 2/20/2021 Not Specified 2 $6.93 Regular Air ($4.64) $2.08 $2.56 Alberta West Office Supplies Small Pack 7/15/2020 High 26 $2,808.08 Regular Air $1,054.82 $107.53 $5.81 Alberta West Furniture Medium Box AW 7/15/2020 High 24 $1,761.40 Delivery Truck $1,748.56 $70.89 $89.30 Alberta West Furniture Jumbo Box UT 7/15/2020 High 23 $160.23 Regular Air $85.13 $7.99 $5.03 Alberta West Technology Medium Box 7/15/2020 High 15 $140.56 Regular Air $128.38 $8.46 $8.99 Saskatchewan Prairie Technology Small Pack K E 6 D CO V G UI A W N H 10/22/2020 Not Specified 30 $288.56 Regular Air $60.72 $9.11 $2.25 British Columbia West Office Supplies Wrap Bag 10/22/2020 Not Specified 14 $1,892.85 Regular Air $48.99 $155.99 $8.99 British Columbia West Technology Small Box 11/2/2020 Critical 46 $2,484.75 Regular Air $657.48 $65.99 $4.20 Alberta West Technology Small Box 10 3/17/2020 Critical 32 $3,812.73 Regular Air $1,470.30 $115.79 $1.99 Ontario Ontario Technology Small Pack 11 1/19/2018 Low 41 $108.15 Regular Air $7.57 $2.88 $0.70 Alberta West Office Supplies Wrap Bag 12 6/3/2018 Not Specified 42 $1,186.06 Regular Air $511.69 $30.93 $3.92 Saskatchewan Prairie Furniture Small Pack 13 13 6/3/2018 Not Specified 28 $51.53 Express Air $0.35 $1.68 $0.70 Saskatchewan Prairie Office Supplies Wrap Bag 14 14 12/17/2019 Low 48 $90.05 Regular Air $107.00 $1.86 $2.58 Quebec Quebec Office Supplies Wrap Bag 15 15 12/17/2019 Low 46 $7,804.53 Regular Air $2,057.17 $205.99 $5.99 Quebec Quebec Technology Small Box 16 16 4/16/2018 High 37 $4,158.12 Regular Air $1,228.89 $125.99 $8.99 Manitoba Prairie Technology Small Box 17 17 1/28/2019 Medium 26 $75.57 Regular Air $28.24 $2.89 $0.50 Yukon Yukon Office Supplies Small Box 18 18 11/18/2021 Low 4 $32.72 Regular Air $22.59 $6.48 $8.19 Ontario Ontario Office Supplies Small Box 19 19 5/7/2021 High 3 $461.89 Express Air $309.82 $150.98 $13.99 Saskatchewan Prairie Technology Medium Box 20 20 5/7/2021 High 29 $575.11 Regular Air $71.75 $18.97 $9.03 Saskatchewan Prairie Office Supplies Small Box 21 21 5/7/2021 High 23 $236.46 Regular Air $134.31 $9.71 $9.45 Saskatchewan Prairie Office Supplies Small Box 22 22 6/10/2019 Medium 27 $192.81 Regular Air ($86.20) $7.99 $5.03 Quebec Quebec Technology Medium Box 23 23 6/10/2019 Medium 30 $4,011.65 Delivery Truck $603.80 $130.98 $54.74 Nova Scotia Atlantic Furniture Jumbo Box 24 24 4/30/2021 Not Specified 11 $1,132.60 Regular Air ($310.21) $95.99 $35.00 Ontario Ontario Office Supplies Large Box 25 25 10/20/2020 Not Specified 25 $125.85 Regular Air $89.25 $4.98 $4.62 Quebec Quebec Technology Small Pack 26 26 9/11/2020 High 10 $567.94 Express Air $126.09 $65.99 $8.99 Manitoba Prairie Technology Small Box 27 27 8/7/2019 Critical 14 $174.89 Regular Air $37.04 $12.44 $6.27 Quebec Quebec Office Supplies Medium Box 28 28 4/4/2021 Medium 49 $329.03 Regular Air $197.25 $7.28 $7.98 Alberta West Furniture Wrap Bag 29 29 4/4/2021 Medium 6 $20.19 Regular Air $13.44 $3.14 $1.92 Alberta West Office Supplies Wrap Bag 30 30 12/27/2019 Medium 34 $1,315.74 Regular Air $260.87 $36.55 $13.89 Yukon Yukon Office Supplies Wrap Bag 31 31 4/6/2020 High 23 $310.52 Regular Air $33.22 $12.98 $3.14 Manitoba Prairie Office Supplies Small Pack 32 32 6/17/2018 Not Specified 25 $184.86 Regular Air $33.95 $7.38 $5.21 Yukon Yukon Furniture Small Box 33 33 6/17/2018 Not Specified 44 $267.85 Regular Air $65.43 $5.98 $5.15 Yukon Yukon Office Supplies Small Box 34 34 6/17/2018 Not Specified 33 $528.50 Regular Air ($149.92) $15.42 $10.68 Yukon Yukon Office Supplies Small Box 35 35 5/24/2020 Critical 24 $126.58 Regular Air $18.27 $5.58 $0.70 Quebec Quebec Office Supplies Wrap Bag