Chapter 11. Creating Multitable and Crosstab Queries

In this chapter

Introducing Joins on Tables

Joining Tables to Create Multitable Queries

Using Lookup Fields in Tables

Adding Subdatasheets to a Table or Query

Outer, Self, and Theta Joins

Updating Table Data with Queries

Making All Fields of Tables Accessible

Making Calculations on Multiple Records

Designing Parameter Queries

Creating Crosstab Queries

Writing UNION Queries and Subqueries

Creating Queries from Tables in Other Databases

Troubleshooting

In the Real World Optimizing Multitable Queries