To quickly create a multi-field primary key, while in the table's Design View:
Hold the Ctrl key and click each field that you want to make up the primary key.
Choose Edit>Primary Key from the menu bar, or click the Primary Key button on the toolbar.
Access creates the composite primary key for you.
See all Topics