Home /
Expert Answers /
Computer Science /
how-do-you-change-the-data-type-in-access-create-a-new-table-in-datasheet-view-change-the-id-field-pa504
(Solved): how do you change the data type in access? Create a new table in Datasheet view. Change the ID field ...
how do you change the data type in access?
Create a new table in Datasheet view. Change the ID field name to ManagerID with the AutoNumber data type, add a field named ManagerFirstName with the Short Text data type, add a field named ManagerLastName with the Short Text data type, add a field named HireDate with the Date/Time data type, and add a field named Salary with the Currency data type. Save the table with the name Managers and close it.