To create primary key for a table when in design view A. Type PRIMARY in field type box when creating required field B. Mark the Primary check box in field name of required field C. Click the Primary Key button in Design ribbon when the cursor is in required field D. None of the above

Type PRIMARY in field type box when creating required field
Mark the Primary check box in field name of required field
Click the Primary Key button in Design ribbon when the cursor is in required field
None of the above

The correct answer is C. Click the Primary Key button in Design ribbon when the cursor is in required field.

A primary key is a column or columns in a table that uniquely identifies each row in the table. A primary key cannot contain duplicate values.

To create a primary key in Access, follow these steps:

  1. In the Design view of the table, click the Primary Key button in the Design ribbon.
  2. Access will select the first field in the table and place a key symbol next to it.
  3. If the first field is not the field you want to use as the primary key, click the field you want to use and then click the Primary Key button again.
  4. To remove a primary key, click the Primary Key button again.

Option A is incorrect because you cannot type PRIMARY in the field type box when creating a required field. The field type box is used to specify the data type of the field, not the primary key.

Option B is incorrect because you cannot mark the Primary check box in the field name of a required field. The Primary check box is used to specify that the field is a primary key, not that it is a required field.

Option D is incorrect because it is not a valid option.