Set primary key
IV. Set Primary Key on a Field
Primary Key is a key that can be used to avoid the data redundancy. It can distinguish each record in the table.
You can set Primary Key on a field that you thought this field doesn’t allow redundancy data. For instance, the Employee table has one field that prohibits duplicate data. This field is EmpID. To avoid duplicate data, you have to set Primary Key on this field.
You can set Primary Key on a field that you thought this field doesn’t allow redundancy data. For instance, the Employee table has one field that prohibits duplicate data. This field is EmpID. To avoid duplicate data, you have to set Primary Key on this field.
To do so, you have to follow the steps below:
- Open TblEmployee in design view
- Click EmpID field
- Click Primary Key
No comments:
Post a Comment