If you created your query from scratch (as in the preceding set of steps), the first thing you need to do is add the fields you want to work with. You can also use this same procedure to add fields to an existing query.
Adding More Tables
You can add tables to your query at any time. Just click the Show Table button on the toolbar or select Query, Show Table. Then select the table(s) you want and click Add. Click Close to return to your query design.
There are three ways to add a field to a query. All methods are easy; try all of them to see which you prefer. Here's the first method:
Click in the Table row of the ...