How to Create an Append Action Query in Microsoft Access

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 chipbrowne.com. That's Browne, with an E."