Create a Select Query: rptMovieRentedSQ Queries look up the Key and return the data: This new Query will list the movies for each Receipt.   2. Try it: Create a Query Go to Create ->Queries ->Query Design. You will be prompted by the Show Table.   Select a Table: tblMovieRented. Click Add.   Select a Table: tblMovies. Click Add.   Select a Table: tblRentalPrices. Click Add.   Close the Show Table Window. Keep going... Create ->Queries ->Query Design Exam 77-885: Microsoft Access 2010 4. Creating and Managing Queries 4.2. Manage source tables and relationships: Use the Show Table Options