Exam 77-424: Microsoft Access 2013 1.0 Create and Manage a Database 1.2 Manage Relationships and Keys: Create and Modify Relationships

Join the Table and Query Both the Table and Query have the same Key: CustomerID. We can create an ad hoc relationship between the Table and the Query, a JOIN.   2. Try it: Create Ad Hoc Relationships Go to tblReceipt. Select a Field: CustomerID. Drag CustomerID to the Query, CustomerNameSQ and drop it on the matching Key, CustomerID.   What Do You See? There should be a JOIN between the Table and the Query. Now, if we have a CustomerID in tblReceipt we can look up the name, address and phone that goes with that CustomerID.   Keep going... Query Tools ->Design->Query Type->Select