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