Materi Microsoft Access : Create and Remove Primary Keys

How to set a primary key :

1. In the Navigation pane, right-click the table, and then click Design View.
2. Select the field or fields you want to designate as the table’s primary key. To select multiple fields, press Ctrl and select the fields.
3. On the Table Tools Design tool tab, click Primary Key.

How to remove the primary key designation from a field :

1. In the Navigation pane, right-click the table, and then click Design View.
2. Select the field or fields from which you want to remove the primary key designation.
3. On the Design tool tab, click Primary Key.