Microsoft Access table has a field or set of fields that uniquely identify each record stored in the table, it can be set as the primary key. The selection of a primary key is one of the most critical decisions you’ll make in the design of a new database. In this article I have explained how to set primary key in table.
Set Primary key
Step 1: Open a table in Design view.
Step 2: Select the field or fields you want to define as the primary key or click the row selector for the desired field.
Step 3: Click Primary Key on the toolbar.
Figure 1:
After clicking on primary key, selected column will be look as below image
Figure 2:
Note: - When you save a new table without setting a primary key, Access prompts you to create one. If you choose Yes, Access creates an ID field that uses the AutoNumber data type to provide a unique value for each record. If your table already includes an AutoNumber field, Access uses that field as the primary key.
Rahul Kesharwani
27-May-2020Nice Post
The primary key concept is critical to an efficient relational database.