How to Create an Append Action Query in Microsoft Access

How to Create an Append Action Query in Microsoft Access. With an Append action query, you can add a group of records from one or several tables to the end of one or more tables. You might do this if you acquire a new database of information that is pertinent to one or more of your tables. Appending the information will save you the trouble of re-typing. These instructions apply to MS Access 97.

Step

Open the Database window (F11). Click the Query tab.

Step

Click New, then click Design View.

Step

From the Query menu, select Append. A dialog box appears.

Step

Use the Table Name box to identify the name of the table that is to receive the records.

Step

If the table is in the current database, click Current Database. Otherwise, click Another Database and enter the name and path of the database containing the table.

Step

Click OK.

Step

Drag the fields that you want to use for setting query criteria to the design grid.

Step

If necessary, enter the names of the fields in the table that you are adding the records to.

Step

Use the Criteria cell to enter the criteria on which additions will be made (all values equal to "Memphis" for example).

Step

Switch to Datasheet view to preview the changes, then return to Design view.

Step

Click Run when you are satisfied.