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

Chapter 16. Creating Queries from Scratch > Introducing Query Design View

Introducing Query Design View

In Lesson 15, "Creating a Simple Query," you created a simple query using the Simple Query Wizard. This wizard allowed you to select the fields from a particular table and then create a standard select query. Although the Simple Query Wizard makes it easy to create a query based on one table, you will find that building more sophisticated queries is best done in the Query Design view.

The Query Design view provides two distinct areas as you work. A Table pane shows you the tables currently being used for the query. The bottom pane, the Query Design grid (see Figure 16.1) enables you to list the fields in the query and select how these fields will be sorted or the information in them filtered when you run the query.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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