Often you will be interested in viewing only some of the records in a table. For example, you might want to find all of your customers or suppliers from a particular state or country. You can narrow the records shown in a table by creating a filter, which hides records not meeting your criteria. The records aren’t erased, though; when you remove the filter, they display normally.
Open a table in Datasheet view.
Select the text to serve as the base for the filter.
Click the Home tab.