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

Join Two Tables 5. Try it: Join Two Tables Go to tblReceipt. Select a Field: ReceiptID. Drag that Field to tblMovieRented and place it on the one that matches: ReceiptID.   What Do You See? The two Tables will be JOINED by their common Key: ReceiptID. There is more to this relationship.   Try This, Too: Edit the  Relationship Double-click the JOIN (the line) between tblReceipt and tblMovieRented.   What Do You See? The Tables are JOINED by a matching Key: ReceiptID.   This is a One-to-Many Relationship. One: tblReceipt Many: tblMovieRented   Keep going...   Memo to Self: The Edit Relationships window may pop up by default when you make a join. Relationship Tools ->Design->Tools->Edit Relationships