From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Manage table relationships and keys
From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
Manage table relationships and keys
- [Instructor] While you're creating your tables, you want to pay close attention to how you're setting your primary keys. And when you create relationships between your tables, that's when you can establish a foreign key. You also need to know how to display the relationships, understand the three relationships which are a One-to-many, One-to-one and Many-to-many. Let's jump into our keys and relationships database and see if we have any relationships that are currently created. We'll go to database tools and relationships. All relationships will show us if we have any relationships already created and it looks like we don't. So let's go ahead and start off with a One-to-one relationship. And this is sometimes the least common relationship that you'll create between your tables, because it means that one record in the primary table is related to just one record in a related table. I'm going to use the Commission table in…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.