using “Access” do the assignment see attached for instruction(2 file is on the google drive link)

file download(https://drive.google.com/file/d/1a028Y9CRny6vdHMDG…)1 attachmentsSlide 1 of 1

  • attachment_1attachment_1

UNFORMATTED ATTACHMENT PREVIEW

Assignment Using the file “attachment 2”.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 ShipMode and then by ProductContainer 2. For each ShipMode, show the sum of profit grouped by OrderPriority. 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 at least $500 OR the ShipMode is Express Air. 2. Show all fields of any records with Sales below $500 AND the ShipMode is Express Air. 3. Show the Sales, OrderDate and ShipDate fields (only) of any records where the OrderDate is in April (any year) and the Province is Alberta. 4. Show average Sales for each Province, using all records with a 2010 OrderDate. You should only have one average value per province. 5. For each Region, show the sum of Profit for each of its Provinces. You should have one sum for each {Region, Province} pair. 6. For each Province and year, show the sum of Profit from the months of January, February, and March (use OrderDate). The sum should be for the entire three-month range. Each Province should have a separate value for each {Province, year} pair. 7. Show all fields of any records with delivery truck ShipMode if the ProductContainer is Jumbo Drum.

Do you similar assignment and would want someone to complete it for you? Click on the ORDER NOW option to get instant services at essayloop.com

Do you have a similar assignment and would want someone to complete it for you? Click on the ORDER NOW option to get instant services at essayloop.com. We assure you of a well written and plagiarism free papers delivered within your specified deadline.