Learn How to Set Up a Primary Key for Access 2010


show more Setting a primary key provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Setting a primary key

A Primary Key is how Access knows that there aren't any identical records in your Table. Every record needs a unique identifier, a way to distinguish it from other potentially similar entries. We're going to set the Primary Keys in all three of our tables. Let's start with our Customers. Double-click on Customers. Then click on the Design View button. Because we created Customers using the Application Parts, Access is assigned to the Primary Key automatically. So we can just go ahead and close the table. Next, open up the Sales Reps table, and let's do it a slightly different way.

This time right-click on it and choose Design View. Because we started this table in the Layout View using Access's ID field, it also already has a Primary Key. But let's change the Field Name, change ID and add "Emp" in front. "Emp" is standing for employee. Save and close the table. But when we open up the Products table in Design View, there is no Primary Key because we bui...

Setting a primary key
Video duration: 1m 20s 3h 30m Beginner

Viewers:

Setting a primary key provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...