go_a01_grader_a3_Open_Houses.accdb (solution) Homework | Page 2

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: