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

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

1)Reports:

Show allfields of allrecords, grouped byShipMode and then byOrderPriority

ForeachShipMode, show the sum ofprofit grouped byProductContainer. 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:

Show the Sales,OrderDate andShipDate fields (only) of any recordswhere theShipDate is inApril (any year)andthe Regionis Yukon.

For eachRegion, show the sum of Sales for each of itsProvinces. You should have one sum for each {Region, Province} pair.

Show all fields of any records withProfitat least $100AND theShipMode isExpress Air.

For eachRegion and year (2018 through 2021), show the sum of Profit from the months ofJanuary,February,and March (useOrderDate). The sum should be for the entirethree-month range. EachRegion should have a separate value foreach {Region, year} pair.

Show all fields of any records withSalesabove $1000OR theShipMode isDelivery Truck.

Show average Sales for each Province, using all records with a 2019OrderDate. You should only have oneaveragevalue per province.

Show allfields of anyrecordswhere theShipModeis Express Air and theProductContainer isSmall Box.

find the cost of your paper

High-performing teams are teams whose members have specific roles and complementary talents and skills and are aligned in purpose such that they consistently produce superior results

High-performing teams are teams whose members have specific roles and complementary talents and skills and are aligned in purpose such that they consistently produce superior results. A high-performing team can make….

You are a line manager in a medium-size marketing organisation that creates innovative visuals for companies.

You are a line manager in a medium-size marketing organisation that creates innovative visuals for companies. You have to pitch your idea to a new large corporate company that may….

CA City Hotel is looking at changing its liquor licence to include off premise consumption of alcohol, as this was not on the original licence application.

CA City Hotel is looking at changing its liquor licence to include off premise consumption of alcohol, as this was not on the original licence application. They are wanting to….