Share this page:

MS Access 2007: Add tables to a query

Question: In Microsoft Access 2007, I've created a query and I want to add another table to the existing query. How do I do this?

Answer: To do this, open the query in Design view. Select the Design tab in the toolbar at the top of the screen. Then click on the Show Table button in the Query Setup group.

Microsoft Access

When the Show Table window appears, highlight the table that you want to add and click on the Add button. When you are done selecting the tables, click on the Close button.

In this example, we want to add the Order Details table.

Microsoft Access

You should now see the Order Details table appear in the Query window.

Microsoft Access