|
Before
You Begin: Change the Query Type Go to
Query Tools->Query Type->Select.
Try
This: Edit the Criteria Select a
Field: Year And This:
Test the New Query Criteria Go to
Query Tools ->Design->Results->Run. This Query returned 192 Movies
between the Year 1999 and 2012. Finally,
Do This: Create an Update Query Go to
Home->Views->View->Design View. Go to
Query Tools ->Design->Query Type. Select a
Type: Update. Enter the
RentalPriceID: 2
RentalPriceID 2 is $3.50 with a 3-Day Rental. Try This,
Now: Run the Update Query Go to
Query Tools ->Design->Results->Run. A total of
192 rows in tblMovies will be updated. You will be asked to confirm.
Click Yes.
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.1. Construct queries: Update
Queries
Query Tools ->Design->Results->Run |
|
| |
