Special Edition Using Microsoft® Office Access 2003

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

Introducing Joins on Tables

Your purpose in acquiring a license for Access is undoubtedly to take advantage of its relational database management capabilities. To do so, you must be able to link related tables based ...