The three types of relationship options help determine how many records in each table are related. In this video, explore the difference between one-to-one, one-to-many, and many-to-many relationships, and learn how to set primary and foreign 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 the Sales Team table. …
- Modifying the database structure
- Managing table relationships and keys
- Exporting data
- Managing records and fields
- Creating and running queries
- Configuring form controls
- Modifying form positioning
- Grouping report fields
- Formatting reports
- Taking the practice exam
Skill Level Intermediate
1. Microsoft Office Specialist (MOS) Exam Overview
2. Managing Databases
3. Create and Modify Tables
4. Create and Modify Queries
5. Modify Forms in Layout View
6. Modify Reports in Layout View
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.