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:
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.
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.
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 ...