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

Description of the how the software selection criteria (and which ones) were chosen for your company

Integrated Learning Project Assignment Instructions Overview The integrated learning assignment is a series of 6 assignments and a final course consolidated submission. All assignments and the compilation of the final….

How can Layla use JavaScript custom objects to create the Customer List feature for the Web site?

Layla just got hired as the Web developer for a small business called Axe Grinders, which sells and repairs guitars and amps. The aging rock 'n' rollers who own Axe….

Describe how the Web site can be redesigned or revised to achieve better results.

you will complete several steps for this assignment. Step 1: You will become familiar with an assessment tool (Wave Checker) to examine Web accessibility for a couple Web sites. This is….