Exam 77-424: Microsoft Access 2013 1.0 Create and Manage a Database 1.2 Manage Relationships and Keys: Edit References Between Tables

Create a Relationship with a JOIN Between Key Fields The CustomerNameSQ Query can be JOINED to tblMovieRented by a common Key: CustomerID.   7. Try This: Create an Ad Hoc Relationship Drag CustomerID from tblMovieRented to CustomerID in CustomerNameSQ.   And Try This, Too: Add More Fields Add the following Fields to the QBE Grid: From CustomerNameSQ: FullName Address1 CityStateZip HomePhone   Save, Save, Save. Keep going, please... Query Tools ->Design