Choose a Primary Key in Access 2007

- [Narrator] Every database needs to have

what's called a primary key.

And this primary key is a field

that is unique for every single record.

So, for instance, you would not
want to choose a primary key

for my first name field

because I might have two work contacts

whose first name is Susan.

And even last name I might know,

I might come across two people
with the same last name.

Company, same thing.

So you need to pick a field

that's going to be really
unique for every single entry.

An easy way to do this is
when you first create a table,

when you open access,

you're gonna usually have an
ID field name created for you.

And this is a great one
to make your primary key

because it assigns a unique ID number

to every single record in your database.

So to make it a primary key field,

just right click over to the left,

and then click on Primary Key.

And that will set your database

for your ID as being your primary key.