Final Exam - Access Answer

Used enter text field first name last name product

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: xt. used: enter text. Field: First Name Last Name Product Name Table: Ingredient Name Customer Customer Products Ingredients Total: Sort: Show: Yes Yes Yes Criteria: No "chocolate chips" 3. Write a query that will display the total amount of sales for each neighbourhood in Vancouver. The query should display the name of the neighbourhood and the total amount of money spent by the customers in the neighbourhood. [7 marks] Write down the tables used to develop the query: Tables Click here to Click here to Click here to Customer Order Products enter text. enter text. used: enter text. Field: Neighbourhood Total: [quantity]*[price] Table: customer Total: Group by Sum Yes Yes Sort: Show: Criteria: Click here to enter text. Click...
View Full Document

Ask a homework question - tutors are online