Running Database Queries

In Access XP running database queries may seem confusing at first. This free lesson offers step-by-step instructions.

Sorting, finding, and filtering query results

Throughout this tutorial, we have learned several ways to quickly locate information in the contact management database: sorting records, finding records, filtering records, and performing queries. Can you run a query and then sort, find, or filter records? Absolutely. This is the power of a database.

Everything you previously learned about how to save sorts and filters applies to queries as well. Once a query is defined, you can come back to the database at any time—even after new contact records have been added—and run that query.

After you run a query and define a sort, you will be asked to save the sort and the query design when you close the query or exit Access. If you save your changes, the sort will be saved to the query the next time you run the query. If you do not save changes, the query returns to the original order the next time you run it.

Before and After Results of Sort

When a filter is applied to a query, Access will ask if the changes to the query design will be saved the next time you close the database or exit Access.