How to Create an Append Action Query in Microsoft Access

Next Video:
How to Create an Update Action Query in Microsoft Access....5

In Microsoft Access, the creation of an append action query requires the user to begin with two tables, one being the destination table and the other being the source table. Copy records from the source table to the destination table with help from a computer programming teacher in this free video on Microsoft Access.

Part of the Video Series: Microsoft Access Tutorial
Promoted By Zergnet


Video Transcript

Hi, my name is Chip Browne. I teach computer programming and Microsoft Office applications, at a local business college, here in Utah. It's Steven Henagar. I also create practice tests for Microsoft Office Application Specialists Certifications. Today, we're going to learn how to create and append action query, in Microsoft Office Access 2007. Microsoft Access is a registered trademark of Microsoft Corporation. I'm not affiliated with Microsoft Corporation. To create an append query, we need to begin with two tables. One is the destination table, and the other is a source table. We will be copying the records from the source table, to the destination table, using the append query. Let's look at the destination table. This table has records up to 114. Let's look at the source table. This table has two records, to be appended, String ID 115, and 116. Next, let's create the append query. Click on the Create tab. In the other group, click on Query Design. Add the table as your source table. Next, change the query type from Select, to Append, and choose the destination table, to which you'll be appending the records. Next, choose Fields, that will be mapped to the new table. Next, run the query. We're prompted warning, and we'll say Yes. Next, let's see the results of our query. First, close our tables. Next, I'll reopen the destination table. As you can see, records with String ID 115, and 116, have been appended to this table. That is how you create an append query, using Microsoft Access. For more information and videos, visit That's Browne, with an E.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!