graphic2
graphic1

Exam 77-424: Microsoft Access 2013
2.0 Build Tables
2.3 Manage Records: Filter Records

Filter Selection

There are several options for Filtering the records. The Selection tool offers:

Equal

Does Not Equal

Less Than or Equal To

Greater Than or Equal To

Between

 

5. Try it: Use the Filter Selection

Go to the Column Heading: Year

Select an example in the records: 2011

Go to Home ->Sort & Filter.

Make a Selection: Less Than or Equal to 2011

 

What Do You See? There are 397 movies that match the criteria.

 

Try This, Too: Toggle (Turn Off) the Filter

Go to Home ->Sort & Filter-> Toggle Filter

 

What Do You See, Now? There are 400 movies in tblMovies.

 

Keep going...

Home ->Sort & Filter-> Selection