Filter by Selection is one of the fastest ways to filter your list. With this option, all you need to do is highlight the filter criteria in your table or form and then choose Filter by Selection. Your list will quickly filter based on the data that is selected.
Applying a Filter by Selection
Open the Table (in Datasheet view) or Form (in Form view) you want to filter
Select the data you want to filter by
Click the Filter by Selection button on the Standard toolbar
Removing a Filter by Selection
Click the Remove Filter command on the Standard toolbar