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. To do so, you have to follow the steps below:
- Open TblEmployee in design view
- Click EmpID field
- Click Primary Key
Note: Primary Key is in the Design tab.
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: