O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating Your First Real Query

Chapter 6, "Sorting, Finding, and Filtering Data in Tables," introduced the concepts of creating queries. You applied a sort order to tables and added record selection criteria to filters for data contained in tables. Access's Query Design window, however, gives you greater flexibility than the Filter window because it lets you choose the fields that appear in the query result set. You also can create more complex queries by joining primary and related tables.

This chapter explains the basics of QBE. You learn to create multitable queries in Chapter 10, "Creating Multitable and Crosstab Queries," after you learn the details of how to use operators and create expressions in Chapter 9, "Understanding Operators and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required