How to Create an Update Action Query in Access 2003

Microsoft Access 2003 lets you create an append action query to merge tables at the end of one or more existing tables. Appending tables saves you the effort of retyping data. Follow these steps to create an append action query in Access 2003.

Things You'll Need

• Microsoft Access 2003
• Computer

Instructions

1. Open Microsoft Access 2003, and then open a table or database. The "Database" window will open. Click on the "Query" tab.

2. Click on "New." Then click on "Design View," and "OK."

3. In the "Show Table" dialog box, select the tab or tabs that contain the data you want to append. Double-click on each object you want to add to the query. Then click "Close."

4. Add fields to the "Field" row on the design grid.

5. In "Design View," click on the arrow in the "Query Type" toolbar button. Click on "Append." The "Append" dialog box will appear.

6. In the "Table Name" box, enter the name of the current database or another database. Select the fields you wish to use by clicking on them. Drag them to the query grid.

7. Access will automatically append fields if the names of the fields match. You may also enter the names manually.

8. In the "Criteria" cell for the selected fields, enter the criteria you wish to append. To preview your changes, click on "Database View."

9. To finalize your changes, click back on "Design View," and then click on "Run."

Tips & Warnings

• Make sure the data tables you want to append are saved on the same computer or disk. Always save separate copies of data before merging.