How to Use the Wizard to Create a Find Unmatched Query in Access 2003

Microsoft Access 2003 allows for the quick and easy management of large fields of data, and one of the ways it does this is through the Find Unmatched function. Use this feature to compare tables of data and find the entries that are "unmatched," for example, customers who have not paid their bill. Follow these steps to use the Wizard to create a Find Unmatched query in Access 2003.

Things You'll Need

• Computer
• Access 2003

Instructions

1. Install Microsoft Access 2003 and open the program. This program may already be installed in your computer.

2. Open the database you want to work with. Do this by clicking the "Open" icon and browsing for the file you are interested in.

3. Click the "Queries" tab under "Objects." Select "New" to open a "New Query" window and create a new query.

4. Select "Find Unmatched Query Wizard" in the dialogue box to create your "Find Unmatched" query. Then, click "OK."

5. Select your first table in the first step of the Wizard. There should be a list of tables and queries from which to choose.

6. Select the second table in the second step of the Query Wizard. Next, select the fields you want to compare in your tables in Step 3 of the Wizard.

7. Name your query (for example: customers with unpaid bills). Save the finished product.

Tips & Warnings

• If the information is incorrect or not what you anticipated, go through the Wizard a second time to refine your Find Unmatched query.

• Give the query a name without spaces.

• It is not necessary to save this type of query.