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

Case Analysis

You can view the article (the case), “The Man Who Got Honeywell’s Groove Backt”, by linking to the course EReserves  Follow the Case Analysis Outline given in your syllabus. This is….

Cost-Volume-Profit Analysis

  Assignment Content Purpose of Assignment  The Case Study focuses on CVP (Cost-Volume-Profit), break-even, and margin of safety analyses which allows students to experience working through a business scenario and….

Case Study: Telco Corporation

Telco Case Study examines the revenue impact of Customer Service. You must provide a two page write-up of the case and use the questions (brief notes in red provided to….