Question

Create a new table in Design View with the following field names and data types: "ManagerID" Short Text; "Rating" Number. Save the table with the name ManagerRatings and do not set a primary key field at this time.

A) ManagerID (Short Text), Rating (Short Text)

B) ManagerID (Number), Rating (Short Text)

C) ManagerID (Short Text), Rating (Number)

D) ManagerID (Number), Rating (Number)

Answer 1

The creation of the new ManagerRatings table requires the ManagerID field to be of Short Text data type, while the Rating field should be a Number. Option C is correct as it matches the requirements and sets the foundation for a structured database. The correct answer is C) ManagerID (Short Text), Rating (Number)

Step-by-step explanation:

The correct answer to create a new table with the specified field names and data types is C) ManagerID (Short Text), Rating (Number).

When you create the new ManagerRatings table in Design View, you should ensure that the ManagerID field is set to the data type 'Short Text' as it will likely contain alphanumeric characters and the Rating field is set to the 'Number' data type since it will hold numerical values. Remember, no primary key is to be set at this time, which can be adjusted later as needed.

To create a new table in Design View with the given field names and data types, you would choose option C) ManagerID (Short Text), Rating (Number).

In Design View, you can set the field names by entering "ManagerID" and "Rating", and set the data types as "Short Text" and "Number" respectively. After entering the necessary information, save the table with the name ManagerRatings.

The correct answer is C) ManagerID (Short Text), Rating (Number)