Learn what a Primary Key is and how they help keep duplicate data out of our databases. Author Jen McBee demonstrates how to create a relationship between two tables using the Primary Key to connect the tables.
- [Instructor] Most of the tables in your database…will have a primary key.…What's a primary key, you ask, well it's assigned to a field…to make sure that that field can only hold unique values.…That keeps you from duplicating records.…Why do you need it?…Well let's think of this scenario of an HR department.…They would use either a social security number…or an employee ID number as a primary key field…to make sure that they only had one record…for each employee.…
So think of it as a safety net.…On the Access 2010 MOS Exam,…you'll be asked to assign the primary key property…to a field and a table.…You may also be asked to reassign the primary key property…from one field to another.…In this video, we're going to review both scenarios…to make sure that you're comfortable taking on either task…if you come across it on the MOS Exam.…I have the 0304 exercise file open…so let's go ahead and get started.…Let's open up the customers table.…
We see we have a customer ID field, the company,…and then we have our contact information, et cetera.…
- Creating a new Access database
- Applying application parts
- Backing up a database
- Creating new tables and fields
- Sorting and filtering records
- Setting primary keys
- Importing data
- Creating basic forms
- Creating Access queries, including crosstab and multitable queries
- Creating Access reports
Skill Level Intermediate
1. Microsoft Office Specialist Exam Overview
Prepare for the exam2m 18s
2. Managing the Access Environment
3. Building Tables
4. Create Forms
5. Create and Manage Queries
6. Create Reports
7. Final Practice Exam
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.