Access 2013 & 365 In Pictures
Filter records

When should you filter?

Filtering records works like a query, bringing up specific information from a table.

But unlike a query, your filtering doesn't remain part of the database.

When you perform a query and save it, the query remains with the database, even after you close it. Filtering does not.

Since you can't save filtering like a query, filter records when you need quick results. Think of filtering as a temporary, quick, "on the spot" query.

1 Click in the State field for customer number 1.

Notice that the State is Florida.

2 In the Ribbon, click the Filter icon.