|
The Action
Query changed the data in tblMovies. Let's open that Table and see
what happened. 7. Try
This: View the Data in the Table Go to
All Access Objects->Tables. Open a
Table: tblMovies. And
This: Sort the Records by Year Go to
Home ->Sort & Filter->Descending. What Do
You See? The 2012 Records have been updated with RentalPriceID
1. So,
What Does That Mean? The Movies we selected have an updated
RentalPriceID. This is
just one step. We'll run the Update Query a couple more times for
the other two Rental Prices, then we'll look at how this all works.
Do
This: Close the Table If you are
prompted, please Save the changes.
Exam 77-885: Microsoft Access 2010
2. Building Tables
2.3. Sort and filter records: Use
Sort
Home ->Sort & Filter->Descending |
|
| |
