Microsoft Access 2010 tutorial: Set primary key

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. To do so, you have to follow the steps below:

- Open TblEmployee in design view

- Click EmpID field

- Click Primary Key

Microsoft Access 2010 set 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:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.