Chapter_4_Queries_OUT

Answer applicable controls for applicable table

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: trols for Applicable Table Design Q: What are the invoice numbers of all sales Q: made to D. Ainge? Who are the salespersons for each sale? Determine the data items needed: Determine Q: What are the invoice numbers of all sales Q: made to D. Ainge? Who are the salespersons for each sale? Determine the data items needed: Invoice# Customer Name Salesperson Q: What are the invoice numbers of all sales Q: made to D. Ainge? Who are the salespersons for each sale? Determine the data items needed: Invoice# per Sales table Customer Name per Customer table Salesperson per Sales table Click Click Create tab Select Query Design Click to add Tables needed for Query Click Field dropdown menu to select Data Items shown as TableName.DataItemName Add Criteria “D. Ainge” per Customer Name Add Run Query ! Check Check Results per Table 4-8 ‘Query Answer’ Click View then Design View to modify query if needed Save Save by naming your query Go back to Design View if needed changes Find the Query that you Created & Saved Q2: Q2: How many televisions were sold in October? Select data to perform query Q2: Q2: How many televisions were sold in October? Select data to perform query ‘Date’ ‘Description’ ‘Quantity’ Q2: Q2: How many televisions were sold in October? Need ‘Date’ from Sales table Need Ned ‘Description’ from Inventory table Need ‘Quantity’ from Sales-Inventory Apply Apply criteria on Date as ‘Between 10/1/2005 and 10/31/2005’ & Add criteria on Description as ‘Television’ Right-click in the Quantity field to Add a Right-click new line ‘Total’ Select to Perform the calculation ‘Sum’ Select Uncheck to NOT to show in query result Answer to Q2: How many te...
View Full Document

Ask a homework question - tutors are online