University of Illinois Chicago Create a Program Code Computer Programming Task

User Generated

8sutogg

Programming

University of Illinois at Chicago

Description

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...

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.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

View attached explanation and answer. Let me know if you have a...


Anonymous
Goes above and beyond expectations!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags