How to Create Append Query MS Access

Quick summary

An append query in MS Access lets you copy records from one table and insert them into another table within the same or a different database. This step-by-step walkthrough covers every click — from opening Query Design to running the final append action.

Steps

1. Launch MS Access and open the database where you want to create the query, then click the Create tab.
2. Click Query Design to open a new query in design mode.
3. In the Show Table dialog box, select the table or query that contains the data you want to append.
4. Click Add Selected Tables to add the source table to the query grid.
5. On the ribbon, go to the Query Design tab and select Append to change the query type.
6. In the Append To dialog box, select the destination table where you want to append the data.
7. Click OK to confirm the destination table selection.
8. Add the fields you want to append by double-clicking them in the table list or dragging them to the query grid.
9. Click View on the ribbon to switch out of Design View.
10. Select Datasheet View to preview the records that will be appended before running the query.
11. Switch back to Design View to prepare to run the query.
12. Click Run and confirm the action when prompted to execute the append query.