Access offers several types of queries that help you retrieve the information you need ”select queries, crosstab queries, action queries, and parameter queries.
Creating Queries in Access
As with most database objects you create in Access, there are several ways to create a query. You can create a query from scratch or use a wizard to guide you through the process of creating a query.
With the Query Wizard, Access helps you create a simple query to retrieve the records you want. All queries you create and save are listed on the Queries tab in the Database window. You can then double-click a query to run it and display the results. When you run a select query, the query results show only the selected fields for each record in the table that matches your selection criteria. Of course, once you have completed a query, you can further customize it in Design view. As always, you can begin creating your query in Design view without using the wizard at all. Queries are not limited to a single table. Your queries can encompass multiple tables as long as the database includes a field or fields that relate the tables to each other.