Question

Create a new table in Datasheet View with the following options: Rename the ID field to DeptID and change the data type to Short Text. 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.

Answer 1

To create a new table in Datasheet View with the given options, follow these steps:

Step-by-step explanation:

Create a new table in Datasheet View with the following options:

1. Rename the ID field to DeptID and change the data type to Short Text.
2. Change the field size of the DeptID field to 4.
3. Add a new field with the name DeptName and the Short Text data type.
4. Save the table and use Departments as the table name.