Appending a query

Dear Annabel

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.

Appending is equal to Copy and paste. When you want to copy records from one table to another you can use Append query. The advantage of creating an append query compared to simple copying and pasting the records is that you just have to create the append query once and then you can simply run the append query and all the new records that you may have added can easily be appended to the existing table. Append query can also help you append (Copy and paste) only certain records that meet some specific criteria!!

To create am append query is the same way you would create any simply query.

Following are the steps:

1. Choose Queries in the objects bar on the left hand side.

2. Click the New Button

3. Choose Design view. Press OK button

4. From the show table window choose the table where the records will be COPIED FROM. Click on the Add button.

5. Close the Show Table window

6. Double click on all the fields that you wish to copy. If you want all the fields and all the records you can simply double click on the * in the table window.

7. Choose Query > Append Query... from the menu bar

8. In the Append query dialog box in the Append to drop down choose the table you want to append RECORDS TO.

9. Press OK

10. When you press the Run button to run the query you'll get a message saying that you are about to append certain no. of records to the specified table do you want to continue. You will not be able to undo.

11. Save the query with an appropriate name.

When you open the relevant table you should be able to see the new records.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007