form that automatically opened . Open the Navigation Pane .
2 In Datasheet view , create a new table . Beginning in the
12 second column of the table and using the data type of Short Text , create the Department Name , Contact Last Name , Contact First Name , Campus , Phone , and Department Email fields ( in that order ). In the eighth column , using the Currency data type , create the Special Pay field .
3 Change the data type of the ID field to Short Text , 2 rename the ID field to Department ID .
4 Starting in the Department ID field , add the following 12 three records to the new table :