Question

Create a new table using Table Datasheet view with the following fields and data types, and in the following order: ID (AutoNumber which is automatically added by Access), CommentDate (Date & Time), and Comments (Long Text). Save the table with "ClientComments" as the table name.

A) Open Table Datasheet view, manually add fields ID, CommentDate, and Comments in the specified order, and set their data types accordingly.

B) Open Table Datasheet view, add fields ID, CommentDate, and Comments in any order, and let Access automatically arrange them.

C) Open Table Design view, manually add fields ID, CommentDate, and Comments in the specified order, and set their data types accordingly.

D) Open Table Design view, add fields ID, CommentDate, and Comments in any order, and let Access automatically arrange them.

Answer 1

The correct answer is C) Open Table Design view, manually add fields ID, CommentDate, and Comments in the specified order, and set their data types accordingly.

Step-by-step explanation:

The correct answer is C) Open Table Design view, manually add fields ID, CommentDate, and Comments in the specified order, and set their data types accordingly.In Table Design view, you can manually add fields and set their data types. This allows you to have control over the order of the fields and their data types. By adding the fields in the specified order, you ensure that ID is the first field, followed by CommentDate, and then Comments. This meets the requirements given in the question.To create a new table in Microsoft Access with the specified fields and data types, you will need to use the Table Design view, not the Table Datasheet view. Here are the steps for the correct option from your list:Open Microsoft Access and navigate to the Table Design view. This view allows for the manual specification of field names and data types.Add an ID field.

However, Access typically adds this field automatically as an AutoNumber data type when creating a new table.Manually add the field CommentDate and set its data type to Date & Time.Manually add the field Comments and set its data type to Long Text.Ensure the fields are in the correct order, as Access does not automatically arrange them: ID, CommentDate, and Comments.Save the table with the name ClientComments.Therefore, the correct answer is option C: Open Table Design view, manually add fields ID, CommentDate, and Comments in the specified order, and set their data types accordingly.