|
9. Try
This: Test the New Query Criteria The Select Query is open in Design View. Go to
Query Tools ->Design->Results->Run. What Do
You See? In this database there are 205 Movies that were
released before the Year 2000. Do
This: Return to the Design View Go to
Home->Views->View->Design View. And Do
This: Change Back to an Update Query Go to
Query Tools ->Design->Query Type. Select a
Type: Update. Try This,
Too: Edit the Update Value Enter the
RentalPriceID: 3
RentalPriceID 3 is $2.50 with a 5-Day Rental. Try
This, Now: Run the Update Query Go to
Query Tools ->Design->Results->Run. When it
runs, 205 rows in tblMovies will be updated, You will be asked to
confirm this action. Click
Yes. Keep going.
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.1. Construct queries: Update
Queries
Query Tools ->Design->Results->Run |
|
| |
