From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Enforce referential integrity
From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
Enforce referential integrity
- [Instructor] We enforce referential integrity between our tables to make sure that we don't accidentally delete a record in one table that's related to another record in another table. After watching this video, you'll know how to enforce referential integrity. You'll learn what Cascade Update Related Fields is and Cascade Delete Related Records is. We'll also learn about the three join types. Let's jump into our 02_03 Integrity database. We're going to create a relationship between our Customers table and our Sales table. Database Tools, Relationships. We'll drag and drop these tables onto our Relationships window. Create a relationship between the two using the ID field from the Customers table and the Customer ID field from the Sales table. In our Edit Relationships window, this is where we can enforce that referential integrity. I'll go ahead and check that off and click Create. So we have a one-to-many…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.