How to Create Append Query MS Access
- George Apostolov
How to Create Append Query MS Access: step-by-step guide
Launch MS Access and open the database where you want to create the query. Click the 'Create' tab.
Click 'Query Design'.
In the 'Show Table' dialog box, select the table or query that contains the data you want to append.
Click 'Add Selected Tables'.
On the ribbon, go to the 'Query Design' tab and select 'Append'.
In the 'Append To' dialog box, select the table where you want to append the data.
Click 'OK'.
Add the fields you want to append by double-clicking them in the table list or dragging them to the grid.
Click 'View' on the ribbon.
Select 'Datasheet View' to preview the records that will be appended.
Switch back to 'Design View' to run the query.
Click 'Run' and confirm the action when prompted.
Quick answer: 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'.
About this tutorial
Build an append query in the app by selecting source and destination tables, adding fields, previewing data, and running the action. This guide shows how to create Append Query MS Access in 12 steps, starting with "Launch MS Access and open the database where you want to create the query. Click the 'C..." and finishing with "Click 'Run' and confirm the action when prompted". The interactive demo above is a click-through copy of the real product interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to create Append Query MS Access?
12 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your data or settings. Once you know the flow, repeat it in your own workspace.
Create your first interactive demo in minutes
No credit card required • Start building today
