Construct the reports requested below using the Query Design tool in Access

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Construct the reports requested below using the Query Design tool in Access.  Be sure to be flipping back and forth between the Design/SQL/Data views to understand how your report is changing throughout construction. If you need a reference remember Lab Assignments #4 and #6 asked you to perform similar queries.  The sales queries workbook we discussed in class is also available on D2L as a reference. 

A)     Total Sales:  Provide a report for Total Sales at Sy’s fish.

B)     Gross Profit #1:  Provide a report of Total Sales by Sy’s fish location.  Each location should show up in your report only one time.  Your report should begin with the location that has the highest sales at the top and conclude with the least sales at the bottom.

C)     Gross Profit #2:  Provide a report of COGS by Sy’s fish location (using standard costs).  Each location should show up in your report only one time.  Your report should begin with the location that has the highest COGS at the top and conclude with the least COGS at the bottom.

D)     A/R #1:  Provide a report of Sales by Customer.  This report should be sorted by customer number from the lowest number to the highest number.

E)      A/R #2:  Provide a report of Cash Receipts by Customer. This report should be sorted by customer number from the lowest number to the highest number.

F)      CREATE-YOUR-OWN!  Sy’s fish is looking for a way to boost overall sales.  Management is requesting a report that could help them achieve that goal.  Construct a query that provides a report that would inform management’s strategic decision-making around boosting sales.  Make sure your query includes all of the commands we’ve discussed in class thus far (Select, From, GroupBy, OrderBy, Where/Having).  

Deliverable:  Copy and paste the SQL script from each of the queries you constructed above into a Word document for printing.  In addition to your SQL script, please also copy and paste the first four records from your generated report in the datasheet view.  For the create-your-own query please also include a brief (1-2 sentence) explanation of your report and how it would be used.  Print this document and include it in the stack to turn in.

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme