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

rptMovieRentedSQ:JOINS As you added each Table to the Query, the Tables were JOINED by their Keys.   3. Try it: Review the JOINS tblMovieRented.MovieID to tblMovies.MovieID.   tblMovies.RentalPriceID to tblRentalPrices.RentalPriceID.   Keep going... Query Tools ->Design