Queries retrieve the latest information from your database.
Whenever you run a query, it checks for the latest data in your database. The data returned by a query is called a recordset.
You can browse through the recordset, select from it, sort it, and print it. Typically, the recordset you produce with a query isn't saved, but the query structure and criteria you used to get the results are saved. You can check for the most recent data again at any time, simply by rerunning the query. Queries have titles, so you can easily find them and use them again.
Because Access saves query structures and criteria, if you frequently need a certain set of information, such as sales during a specific year, you can avoid hunting down that data each time, just by rerunning the query. Chances are, you have better things to do with your time.
You can create and save multiple queries to retrieve data in different ways. Queries are easy to revise as well, so if you don't set them up right the first time, or if your needs change, you can easily change your criteria. You can even use one or more queries as the source of data for another query, increasing your efficiency as you select more and more precisely to get just the data you want.
