Chapter 12. Advanced Query Techniques
IN THIS CHAPTER
- Why This Chapter Is Important
- Using Action Queries
- Viewing Special Query Properties
- Optimizing Queries
- Using Crosstab Queries
- Establishing Outer Joins
- Establishing Self-Joins
- Understanding SQL
- Building Union Queries
- Using
Pass-Through
Queries - Examining the Propagation of
Nulls
and Query Results - Running Subqueries
- Using SQL to Update Data
- Using SQL for Data Definition
- Using the Result of a Function as the Criteria for a Query
- Passing
Parameter
Query Values from a Form - Understanding Jet 4.0 ANSI-92 Extensions
- Practical Examples: Applying These Techniques in Your Application
Why This Chapter Is Important
You learned the basics of query design in Chapter 4, “What Every Developer Needs to Know ...
Get Alison Balter’s Mastering Microsoft® Office Access 2007 Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.