How to Create Composite Primary Key MS Access

Quick summary

A composite primary key in MS Access uniquely identifies records using two or more fields, enforcing data integrity across relational tables. This guide walks through every step to create a composite primary key using Access's Table Design View.

Steps

1. Open your database in MS Access.
2. Locate the target table in the Navigation Pane, right-click it, and select Design View.
3. Identify the fields that will form the composite primary key and click the Row Selectors next to each field name to select them.
4. With the fields selected, click the Primary Key button in the Table Design tools ribbon.
5. Confirm that a key icon appears next to each selected field, indicating they are part of the composite key.
6. Click the save icon to save your changes and finalize the composite primary key.