graphic2
graphic1

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

Review the Data: Filter

This Table has Filters in the Column Headings. The Filters can Sort and Select. The default option is Select All.

 

4. Try it: Filter the Records

Go to the Column Heading: Year

You should see a little Filter to the right of the Heading.

Select a Number Filter: 2012

 

What Do You See? There are 3 movies that were released in 2012 in this Table.

 

What Else Do You See? The Navigation Buttons at the bottom of tblMovies sez there are 1 out of 3. The other 397 records are still in the Table. Those Rows are just hidden, as they were in Excel.

 

Try This, Too: Remove the Filter

Go to the Column Heading: Year

Select a Number Filter: Select All

 

Keep going...

Home ->Sort & Filter-> Filter