Alison Balter’s Mastering Microsoft Access 2002 Desktop Development

Chapter 4. What Every Developer Needs to Know About Query Basics

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

• What Is a Query and When Should You Use One? 104

• Ordering Your Query Result 111

• Refining Your Query with Criteria 112

• Working with Dates in Criteria 115

• Building Queries Based on Multiple Tables 117

• Creating Calculated Fields 123

• Getting Help from the Expression Builder 125

• Summarizing Data with Totals Queries 127

• Excluding Fields from the Output 131

• Nulls and Query Results 132

• Refining Your Queries with Field, Field List, and Query Properties 134

• Building Parameter Queries When You Don’t Know the Criteria at Design Time 137

</feature>

Why This Chapter Is Important?

Although tables act as the ultimate foundation for any application that you build, queries ...