1.You are a graduate teaching assistant for Ridgedale College, a private college in the Midwest. To help the college better manage their course scheduling, you have created an Access database and are working on the tables.
Create a new table in Datasheet View with the following options:
a.Rename the ID field to DeptID and change the data type to Short Text.
b.Change the field size of the DeptID field to 4.
Add a new field with the name
DeptName and the
Short Text data type. Save the table and use
Departments as the table name