- Selecting all columns from a table
- Selecting individual columns from one or more tables
- Joining tables to see unmatched or missing records
- Filtering by single and multiple combinations of choices
- Adding calculations with the expression builder
- Returning the top matched records
- Eliminating duplicate values
- Creating a summary calculation
- Prompting to filter data with parameters
- Creating a crosstab query with the Query Wizard
- Simplifying a problem with a query by using other queries
- Adding two sets of query results together
- Resolving ambiguous outer joins
- Creating an additional query to resolve a problem with mixed joins
Simplifying a problem with a query by using other queries
If you have a complex problem—for example, you need to join together several tables and then perform summary operations—you might find it helpful to break down the problem into one or more steps. First, create a query that joins together and filters all the data, and then create a second query that uses the first query as a source of data and performs the summary operations.
Using a query to work from other queries can also improve productivity by reusing other queries that you have already constructed.
Create a query to combine data from a table and query
In the design view of a new query, in the Show Table popup window, double-click the table to add it to the query grid.
Click the Queries tab in the Show Table popup window.
Double-click a query name to add to the query grid.
To join the table to the query, drag the ProductName field between the tables.
Double-click a field from the table.
Double-click the * on the query to add all columns from the query to the query grid.