Exam 77-424: Microsoft Access 2013
3.0 Create Queries
3.1 Create a Query: Create Parameter Queries (Filter with Criteria)

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...

 

Query Tools ->Design

graphic2
graphic1