If you
know which table you want to use in a query, you can save a
few mouse clicks by preloading it before you open the query
in Design View.
Follow
these steps:
-
In
the Database window, select the table you want to
include in your query.
-
On
the Database toolbar, click the drop-down arrow on the
New Object button 
, and
select Query.
-
In
the New Query dialog box, select Design View, and click
OK.
Access
opens the new query in Design View with the selected table.
To add another table, click the Show Table button 
in the
Query Design toolbar.
You can
also use this method to create a new query from an existing
query. Just select the query instead of a table in Step 1.
