How do I filter Table records in Access 2007? When it comes to filtering records you're filtering them by setting your criteria of what you want filtered in, or filtered out (or hidden temporarily). The quickest way to filter your records is with a simple right click on a field to select a filtering options like for example setting the filter to be equal to or greater than if you field contains numbers. You can also use the toggle filter button by going to the Sort and Filter group and click on the Toggle Filter button. This button will toggle between what you previously filtered to a non-filtered state. To clear the filter you'll simply right click a field to Clear Filter!

Purchase the training video and you can see this in action for yourself!