tech on the net
Home About Us Feedback Site Map


Access Excel Word


SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker


C Language


ASCII Table Linux UNIX Java Clipart Joke of the Moment
Share this page:

MS Access: Add tables to a query in Access 2007

See solution in other versions of Access:

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