How to Create an Append Action Query in Access 2003

You can use Microsoft Access 2003 to create an append action query. This is helpful if you wish to add tables to the end of one or more separate tables. This will save the time and the effort of retyping data. In order to do this, you will have to follow a few simple steps to create an Append Action Query in Access 2003.

Things You'll Need

• Computer with Access 2003

Instructions

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

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

3. Select your data. In the "Show Table" dialog box, select the tab or tabs that contain the data you wish to use. Double-click on each object you want to add to the query; then click "Close."

4. Add fields. Fields must be added 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. Enter the name of the table in the "Table Name" box, selecting the current database or another database. Select the fields you wish to use, click on them, and drag them to the query grid.

7. Access will automatically append fields if the names are the same. 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. Finalize your changes. Click on "Design View" and then click "Run."

Tips & Warnings

• Make sure you have your data tables saved on the same computer or disk to save time.

• Always save separate copies of data that will be merged.

• Do not save data or run append action queries for which you have not saved in their original format.