At times, you might want to view only those records that match a specific criterion. A filter is a technique that lets you view and work with a subset of data. Applying a filter to an Access table, form, or query temporarily hides records that don't meet your search criteria. For example, you may only want to work with data pertaining to a specific zip code.
Access defaults to displaying all records in a table. Filters are not initially applied to a table. Filtering table records actually change the table design. When you attempt to close a table after a filter, Access will prompt you to save the changes to the table design.
When you open the table or form later, all records will be visible. Click the Apply Filter button to reapply the filter. However, Access saves only the last filter you create.
You can apply filters to filtered data to narrow your search even further.
The Filter Excluding Selection works in the opposite manner as the Filter by Selection. Instead of specifying the filter to be used to view records (e.g., everyone in North Carolina), Filter Excluding Selection allows you to view data that does not include the specified criterion (e.g., everyone NOT in North Carolina).
Remove this filter by clicking the Remove/Apply Filter button.
The Filter by Form feature is used when you are working in Form view and not in Datasheet view. Filter by Form works the same way as the Filter by Selection method, except the filtering is defined on a blank contact data entry form as if you were creating a new contact record.