What Are the Objectives? This lesson will create a Rental Table, tblRental, that has a Primary Key, RentalPriceID and the rental price. The Movie Table will be updated to include the RentalPriceID. The RentalPriceID is the Key that will match in both Tables. Finally, we will create an Action Query to update the Movie Table with the rental prices.   Create the Rental Table Create the Rental Table in Design View Enter the Rental Data   Review and Update the Movie Table Edit the Movie Table and add a Foreign Key   Update the RentalPriceID in the Movie Table Create a Select Query to determine the prices Convert the Select Query to an Update Query Run the Update Query to modify the movie data   That's the plan. Microsoft Access 2010: Example of an Update Query