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