Microsoft Access 2007 tutorial:set primary key

Set primary key

IV. Set Primary Key on a 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 employee id. Therefore, you have to set Primary Key on this field. To do so, you have to follow the steps below:

- Open Employee Table in Design View

- Click Employee ID

- Click Primary Key, in Tools group, Design tab

Primary setting



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.