How to Create Composite Primary Key MS Access

‍

‍

A composite primary key in Microsoft Access is a primary key that consists of two or more fields in a table. Here's how to create a composite primary key in MS Access:

‍

1. Open your database in MS Access.
2. Locate the table where you want to create the composite primary key. Right-click the table in the 'Navigation Pane and select 'Design View'.
3. Identify the fields that will form the primary key and click on the 'Row Selectors' next to each field name.
4. After selecting the fields, click the 'Primary Key' button in the 'Table Design' tools ribbon.
5. The selected fields will now have a key icon next to them.
6. The composite primary key is now set. Click the save icon to save your changes.