Edit the Select Query

2. Try it: Add Fields to the Query

Go to tblMovies.

Double click to select the following Fields:

MovieID

Movie

Year

RentalPriceID

 

Criteria can be used to Filter the Records. Criteria can be words, phrases or numbers.

 

Try This, Too: Edit the Criteria

Select a Field: Year

Enter a Criteria: 2012

 

Keep going.

 

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.1. Construct queries: Select Queries

Query Tools ->Design