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

Chapter 34. Using Queries > Creating and Running a Select Query

Creating and Running a Select Query

You can design a simple select query or use the query wizard to help you design a query and then add criteria.

To start a query:

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

2.
Click the New but on on the Database window toolbar (Figure 34.3).

Figure 34.3. Click the New button.


3.
In the New Query dialog box, select Design View (Figure 34.4).

Figure 34.4. Select Design View and click OK.


4.
Click OK.

5.
In the Show Table dialog box that opens, select the tables you want included in your query, clicking Add after each (Figure 34.5).

Figure 34.5. Select tables in the Show Table dialog box.


6.
After you have added all the tables you want included, click Close.

7.
Select a field from the pull-down menu in a Field cell in the query design grid, the lower half of the Select Query dialog box (Figure 34.6).

Figure 34.6. Select a field from the pull-down menu.


or

Double-click a field in the field box in the upper portion of the Select Query dialog box to ad it to the query design grid.

or

Click and drag a field in the table box to a column in the query design grid.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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