Question

Which view in a table is suitable for adding field in a table? in ms access

Answer 1

Answer:

To enter data in the Add New Field column: Create or open a table in Datasheet view by right-clicking the table that you want in the Navigation Pane and then clicking Datasheet view from the shortcut menu. In the Add New Field column, enter the name of the field that you want to create.

Answer 2

Answer:

When you create a new table or open an existing table in Datasheet view, you can add a field to the table by entering data in the Add New Field column of the datasheet (1). Access automatically assigns a data type for the field, based on the value that you enter.