Microsoft® Access® 2010 24-Hour Trainer

26

Creating Append Queries

Append queries are Action Queries used to add a row, or multiple rows, of data to a table as new records. The records can originate in a single table, multiple tables, from values pulled from a form, or from hardcoded values in the query. Append queries are one of many methods used to add records to a table:

• Add records to the table using form controls bound to the table.
• Add records from a table or tables using an Append query.
• Add single records using a single-record Append query.
• Add records using macros or VBA code.

Learning how to use Append queries should make your database perform better. In this lesson, you learn how to create and use both types of Append queries available in Access 2010, and use Query Design View and SQL View to design your query.

LESSON SETUP

For this lesson you need Access 2010 and the Lesson 26 files from the book's website at www.wrox.com. You should be familiar with creating database objects and working with queries to successfully complete this lesson.

APPEND QUERIES IN ACCESS

Access 2010 has two types of Append queries: the multi-record Append query and the single-record Append query. The multi-record Append query uses records that originated from pre-existing tables available to the database. A single-record Append query will get its values from fields that are either literal values or calculated values. Remember that when inserting values into a table that uses an AutoNumber primary key, you will need to be certain ...