In Access queries let you retrieve information from one or more tables on a set of defined search conditions. Learn how to use queries in Access here.
The real power of an Access 2007 database lies in its ability to pull data for quick analysis, which is what happens when you run a query. Queries allow you to retrieve information from one or more tables based on a set of search conditions you define. Access 2007 will display your results in their own table, which you can then further analyze and manipulate. In this lesson, we'll explain how to plan a query using a three-question planning process. You'll also learn how to use the Query Design command to run a query, as well as how to modify the query to hide fields or other information in your query results. Finally, you'll learn how to save the query for later use.