How to Create a Query Using More Than One Table in Access 2003

In Microsoft Access 2003 you can use the Query Wizard to compare, contrast and integrate the information in different databases. Here’s how to create a query that uses more than one table in Access 2003.

Difficulty: Moderate

Instructions

Things You'll Need:

• Microsoft Access 2003

1. Open the pertinent Microsoft Access 2003 databases.

2. Click the "Query" tab on the left side of the database window, and then select "Create Query." This will open the Query Wizard.

3. In the first table, highlight the fields you want to include in your query, and then press the caret (>) key.

4. Select the next table in your query, and perform the same task in the appropriate fields.

5. Finish selecting the information from as many tables as you like. When you’re done entering data, press the "Finish" button on the Query Wizard.

6. Review your new query, and make changes by adding missing fields or subtracting superfluous ones.

Tips & Warnings

• For more features and refinements, consider upgrading to the new Microsoft Access 2007.
• To make a sleek, refined report, extract any unnecessary information, data, fields or tables from your query.