Specifying field contents for an INSERT query

After selecting the field names for the INSERT query, you must specify the contents for each field.

To do so, type the values in the New Value column.  Remember that string values should be enclosed in single quotations marks.  If you are not sure about the type of data in a column, you can display the data types for the fields in the table.

 

More:

Adding columns to the INSERT query

Working with columns in an INSERT query