Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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 built it from scratch. Click on the SKU field, and then click this Primary Key button up here. Now it has a key.
Save and Close this table. Now that our primary keys are set, Access will begin to recognize relationships between our data and our tables. And we'll see that come into play throughout the rest of this course.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 90608 Viewers
80 Video lessons · 137952 Viewers
59 Video lessons · 56711 Viewers
52 Video lessons · 70317 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.