Take Control: Q&A Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

Action Queries So far, you wrote a query that found all of the movies released in 2005. You also have the rental prices.   You need to update the RentalID information in the Movie Table. Start by making a copy of your query and editing the code.   Try it: Make a Copy of a Query Open RecentMoviesSQ Go to Office -> Save As to make a copy of this query. Name it: UpdateRecentMoviesSQ

View -> Datasheet View