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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access