|
The goal
in this next step is to create an Update Query that will mark all of
the Movies released before 1990 as "Archived." The best place to
start is to make a Select Query and see if it finds the right
Movies. When it works we'll save the Select Query as an Update
Query.
1. Try it: Create a Select
Query
Go to Create ->Queries
->Query Design.
You will be prompted by
the Show Table. Select a Table: tblMovies.
Click Add and
Close the Show/Table Window.
Try This, Too: Add Fields Add
these Fields to the QBE Grid:
MovieID, Movie, Year, Archived, Rating, Genre, Stars and
RentalPriceID.
Yep, And This: Add a Criteria
Select a Field: Year.
Enter a Criteria: <1990 When
you Run this Query you should find 73 movies that have this
Criteria.
Keep
going...
Create ->Queries->Query Design
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.1. Construct queries: Create a
Select Query
|
|
| |
