Alison Balter's Mastering Access 97 Development, Second Edition

Chapter 12. Advanced Query Concepts

• Action Queries

• Special Query Properties

• Optimizing Queries

• Crosstab Queries

• Outer Joins

• Self-Joins

• Understanding SQL

• Union Queries

• Pass-Through Queries

• The Propagation of Nulls and Query Results

• Subqueries

• Using the Result of a Function as the Criteria for a Query

• Passing Parameter Query Values from a Form

• Practical Examples: Applying These Techniques in Your Application

You learned the basics of query design in Chapter 5, “What Every Developer Needs to Know About Query Basics,” but Access has a wealth of query capabilities. In addition to the relatively simple Select queries covered in Chapter 5, you can create Crosstab queries, Union queries, Self-Join queries, and many other complex selection queries. You can also easily ...