Primary key in MS Access 2007

In this tutorial you will learn how we can set a column as primary key in a table. A table can have only one primary key column. Primary Key makes a column capable to hold the unique values. Duplicate entries in primary key column are not possible at all. For example two students in a class cannot have same roll number. Columns like Roll No, ID, Enrollment Number etc. can be declared as primary key but columns like Name, Gender, Designation, Address cannot be declared as primary key these columns can have duplicate values. #Microsoftaccessautonumber Microsoft Access other Videos Table Topic 1 Database Creation with Password in MS Access 2007 Topic 2 Table Creation by Table Design, Table, Table Templates option in MS Access 2007 Topic 3 Primary Key creation with auto number in MS Access 2007 Topic 4 General properties of table in MS Access 2007 Topic 5 Validations in MS Access 2007 Topic 6 Lookup Properties in MS Access 2007 Form Topic 7 Form creation by Form options in MS Access 2007 Topic 8 Form Design in MS Access 2007 Report Topic 9 Report creation by Report options in MS Access 2007 Topic 10 Report Design in MS Access 2007 Query Topic 11 Query creation in MS Access 2007 Topic 12 Marks calculation by Query in MS Access 2007 Macro Topic 13 Macro creation in MS Access 2007 External Data Topic 14 Import in MS Access 2007 Topic 15 Export in MS Access 2007 Button Control Topic 16 Button Control with Form in MS Access 2007