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 2001

 

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

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.3. Sort and filter records: Filter Selection