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

Chapter 34. Using Queries > Starting a Query Using the Simple Query Wizard

Starting a Query Using the Simple Query Wizard

You can use the Simple Query Wizard to help you design a simple query.

To start a query using the Simple Query Wizard:

1.
In the Database window, click the Queries tab.

2.
Click the New but on on the Database window toolbar.

3.
In the New Query dialog box, select Simple Query Wizard (Figure 34.13).

Figure 34.13. Select Simple Query Wizard and click OK.


4.
Click OK.

5.
On the first page of the Simple Query Wizard, select first one table, adding the fields you want to include, and then select additional tables and add the fields you need (Figure 34.14).

Figure 34.14. Select tables and add fields in the Simple Query Wizard dialog box.


6.
When you have finished adding tables and their fields, click Next.

7.
On the next page, select Details or Summary and click Next.

8.
On the last page of the Simple Query Wizard, type a name for this query or accept the default name that Access has assigned, choose whether to open the query or modify its design, and click Finish.

The query appears in Design view (Figure 34.15).

Figure 34.15. The query in Design view.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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