Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Access 2010 Essential Training, Alicia Katz Pollock gives a comprehensive overview of creating databases in Access 2010, whether using predefined database templates or building from scratch. This course covers each step of constructing and modifying databases for custom purposes, as well as working with tables, forms, queries, macros, and reports and charts for record keeping and analysis. Exercise files are included with the course.
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.
Find answers to the most frequently asked questions about Access 2010 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
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.