Final Exam - Access Answer

Click here to enter text click here to enter text comm

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: here to enter text. Click here to enter text. COMM 391 - Final Exam: PART A Page 3 of 3 4. Write a query that will display the total number of products sold for each date that an order was made. The query should display the order date, name of the product and the total quantity sold. [7 marks] Write down the tables used to develop the query: Tables Click here to Click here to Products Order enter text. used: enter text. Click here to enter text. Field: Order date Product Name Quantity Table: Order Total: Group by Group by Products Order Sum Sort: Show: Criteria: Yes Yes Yes Click here to enter text. Click here to enter text. Click here to enter text....
View Full Document

This document was uploaded on 03/12/2014 for the course COMM 391 at University of British Columbia.

Ask a homework question - tutors are online