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:
- In the Design view of the table, click the Primary Key button in the Design ribbon.
- Access will select the first field in the table and place a key symbol next to it.
- 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.
- 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.