|
Take Control: Q&A
Update the RentalID
Type: 1
Run the Query
Microsoft Access will prompt you that you are about
to update 32 rows. Click, “Yes.”
All 32 of the movies released in
2005 have a RentalID of 1, now. Can you edit the query to update the
prices for the other movies?
Try it: Use the Update Query
Go back to Design View
Change the Criteria to
2004 and the Update for RentalID to 2. Run the query. You will update 22 rows.
One more time: Edit the Criteria
Change the Criteria to >2004 and the Update for RentalID to 3. Now, all of the movies that were released before 2004
will be updated.
|
|||
|
| |||
