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