Table 1: Values for Region Lookup Field
MidAtlantic
Midwest
Northeast
Southeast
8. With the Customers table still open in Design View, delete the CreditCard field. Save the
change to the table.
9. Switch to Datasheet View and perform the following tasks:
a. Add the caption US Region to the Region field.
b. Change the Region field value to Midwest for Joaquin Howe (who has a
CustomerID field value of 11002). Close the Customers table.