Special Edition Using Microsoft® Access 2000

Chapter 10. 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

• Creating Queries from Tables in Other Databases

• Troubleshooting

• In the Real World—Optimizing Multiple Queries

Introducing Joins on Tables

Your purpose in acquiring Access is undoubtedly to take advantage of its relational database management capabilities. To do so, you must be able to link related tables based on key fields that have values in common—a process ...