|
In this
business model, the Rental Prices are based on a date. New Movies have
a higher Rental Price than old ones. You can
use an Action Query to add the Rental Prices to the Movie
Table. An Action Query selects the Movies based on your Criteria and
updates the RentalPriceID in tblMovies. This
lesson begins with a Select Query that has a Criteria for the Year.
We'll test the Criteria to see if works: Does the Query select
the right Movies? 1. Try
This: Create a Select Query Go to
Create ->Queries->Query Design. Select a
Table: tblMovies. Click
Add. Click
Close. Keep going...
Create ->Queries->Query Design
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.1. Construct queries: Select
Queries |
|
| |
