Guide

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.