Exam 77-424: Microsoft Access 2013 3.0 Create Queries 3.1 Create a Query: Create Multi-Table Queries

Create a Record Source for the Receipt Form The Receipt Form will use a new Query that is based on tblReceipt.   However tblReceipt is only numbers, so we need to look up the customer's name and address in a Query, CustomerNameSQ, and link that to tblReceipt by a common Key, CustomerID.   1. Try it: Create a Select Query Go to Create ->Queries->Query Design.   What Do You See? A blank query will open. The Show Table window will prompt you to choose a Table or Query for the Record Source.   Select a Table: tblReceipt. Click Add.   Select a Query: CustomerNameSQ. Click Add. Click Close. Keep going... Create ->Queries->Query Design