Foreign key
Native key
Composite key
Primary key
Required when a table does not have any unique fields in it
The primary key with AutoNumber as the field type
Made up of two or more fields to uniquely identify records
Is a foreign key that uniquely identifies records
Not Null
No Duplicates
Not Null and No Duplicates
None of 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
Query Wizard
Look up Wizard
Form Wizard
Report Wizard