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

Chapter 7. Retrieving Data with Queries > Using Query Design View

Using Query Design View

The Simple Query Wizard is adequate for building some queries, but it barely taps the power of Access queries. To go further with queries, you need to become familiar with query design view. Recall that you saw two views of tables in Chapter 5: datasheet view, which shows the data in a table, and design view, which shows the structure of a table. Similarly, queries have both datasheet and design views. When you look at a query in design view, you can make changes to its structure that will be represented in the datasheet view. You can use design view to alter existing queries or to build entirely new queries. In this section, you’ll learn how to use design view to build new queries from scratch.

Adding Tables and Queries

The first task in building a new query in design view is to specify the table or query that contains the data you want to start with. Here’s how to get started:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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