# How to Create Append Query MS Access

> To create an append query in MS Access, open your database, click 'Create' and 'Query Design', select and add your source table, click 'Append', choose the destination table, add fields, preview in 'Datasheet View', return to 'Design View', and click 'Run'.

Canonical: https://livedemo.ai/tutorials/how-to-create-append-query-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3918ab56e05a00fdf55f/preview?step=1

## Steps

1. Launch MS Access and open the database where you want to create the query. Click the 'Create' tab.
2. Click 'Query Design'.
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'.
5. On the ribbon, go to the 'Query Design' tab and select 'Append'.
6. In the 'Append To' dialog box, select the table where you want to append the data.
7. Click 'OK'.
8. Add the fields you want to append by double-clicking them in the table list or dragging them to the grid.
9. Click 'View' on the ribbon.
10. Select 'Datasheet View' to preview the records that will be appended.
11. Switch back to 'Design View' to run the query.
12. Click 'Run' and confirm the action when prompted.