Working with columns in an INSERT query

The goal of an INSERT query is to add one or more new records to a table.  The INSERT query must specify the contents of one or more fields in the new record.

There are two basic steps to working with columns in an INSERT query:

  1. For the new record that will be created by this query, select the fields for which you will specify the contents.

  2. Specify the contents of each field.

 

More:

Adding columns to the INSERT query

Specifying field contents for an INSERT query

Working with columns