Microsoft Access 2013 Plain & Simple

Chapter 6. Selecting data using queries

In this section:

• 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

• 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

Queries are where a database can offer a real benefit over a spreadsheet because they allow you to construct sophisticated, updatable presentations of your data. These can vary in complexity from a simple filtered list based on a single table to more complicated presentations of summarized ...