Alison Balter’s Mastering Microsoft Access 2002 Desktop Development

Chapter 11. Advanced Query Techniques

<feature><title>In This Chapter</title>

• Action Queries 450

• Optimizing Queries 463

• Crosstab Queries 467

• Outer Joins 474

• Self Joins 476

• Union Queries 487

• Pass-Through Queries 489

• The Propagation of Nulls and Query Results 490

• Subqueries 491

• Using SQL to Update Data 492

• Using SQL for Data Definition 494

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

• Passing Parameter Query Values from a Form 497

• Jet 4.0 ANSI-92 Extensions 499

</feature>

Why This Chapter Is Important

You learned the basics of query design in Chapter 4, “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 4, you can create ...