1. Open the Employees table and make the following changes. You may work in Datasheet view or Design view as appropriate.

Move the LastName field so it appears before the FirstName field. Hint: Make the change in Design view so the change is applied to the underlying structure of the table.

 

Add the Phone Quick Start fields between the FirstName and Position fields.

 

Delete the FaxNumber field.

 

Modify the Position field to use a lookup list limited to the following values: Supervisor, Greenhouse Tech 1, and Greenhouse Tech 2. Hint: Use the Lookup Wizard to create the lookup list and enter the values yourself. Double-click the right border of the Col1 column in the wizard to AutoFit the column to the data. Don't forget to limit data entries to the value in the list.

 

Answer rating: 100% (QA)

To move the LastName field to before the FirstName field 1 Open the Employees table in Design view 2 ... View the full answer