Drag drop trick
While working with a query in Design view, you may find that you need to add a table or query. The "book" way to do it is to click the Show Table toolbar button, drag the appropriate objects from the list, and then close the dialog box.
There is another way to do this.
Drag the table or query object's icon from the Database window/Navigation pane directly to the top half of the query design grid.
You can also use this technique in Access's Relationships window
See all Topics