• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Using Query by Example > Creating Your First Real Query

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 Expressions in Access." Expressions often are used as criteria for more complex queries.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint