F. Scott Barker's Microsoft® Access 2000 Power Programming

Chapter 8. USING QUERIES TO GET THE MOST OUT OF YOUR DATA

IN THIS CHAPTER

• USING SELECT QUERIES: POWER IN THE QUERY DESIGN GRID

• WORKING WITH ACTION QUERIES: FOUNDATIONS FOR POWER

• USING ADVANCED QUERY OPERATIONS

• WORKING WITH QUERIES TO FEED REPORTS AND FORMS

• EXAMINING THE ARCHITECTURE OF THE QUERY RESOLUTION PROCESS

• UNDERSTANDING OPTIMIZATION TECHNIQUES

• USING UNCONVENTIONAL OPTIMIZATION TECHNIQUES

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 recordsets and examines pieces of data that will be used later. Because this process is being performed on a million-record table, it takes 20 minutes to run. But if you come up with an Access ...