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

Lesson 20. Creating a Simple Query > Creating a Query Using the Simple Query Wi...

Creating a Query Using the Simple Query Wizard

The easiest way to create a query is with the Simple Query Wizard, which lets you select the fields you want to display. You don't get to set criteria for including individual records or specify a sort order. (You learn to do those things in Lesson 21.) This kind of simple query is useful when you want to weed out extraneous fields but still want to see every record.

Note

Select Query The query that the Simple Query Wizard creates is a basic version of a Select query, the most common query type. You can select records, sort them, filter them, and perform simple calculations on the results (such as counting and averaging).

Query Wizard A query wizard asks you questions and then creates a query based on your answers. Access has several query wizards available; you learn about others at the end of this lesson.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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