Guide

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.