F. Scott Barker’s Microsoft Access 2002 Power Programming

Chapter 8. Using Queries to Get the Most Out of Your Data

IN THIS CHAPTER

• Understanding Where Queries Are Used in Access 188

• Working with Select Queries 193

• Working with Action Queries 199

• Performing Advanced Query Operations 201

• Adding More Power with VBA 205

• Driving Reports and Forms with Queries 217

• Solving Problems with Queries 217

• Examining the Architecture of the Query Resolution Process 227

• Optimizing Queries with Jet 229

• Understanding Optimization Techniques 233

• Using Unconventional Optimization Techniques 236

• Using the Analyzer Wizards 238

• Looking at Access 2002’s New Query Features 239

Queries can make you a hero or get you killed. To come out the hero, you need to consider how you use them. For example, you have some code that runs through various ...