You need to add customers that reside in Vermontto the NewEngland table. In Query Design View, create an Append query for the Customers table.

a$.$ Select all the fields from the Customers table in the same order that they are listed in the field list. Select all the fields individually for the design grid; do not use the $(*)$ asterisk.

b$.$ Add the criteria VT to the State field.

c$.$ Select NewEngland as the destination table in the Append dialog box.

d$.$ Save the query using AppendNewEngland as the name, run it$,$ and then close it$.$ The query should append one record.