From the course: Microsoft Access Essential Training (Office 2021/LTSC)
Join today to access over 24,900 courses taught by industry experts.
Primary and foreign keys
From the course: Microsoft Access Essential Training (Office 2021/LTSC)
Primary and foreign keys
- [Instructor] In a well-designed database, you'll create many tables that relate back to records in other tables. If you have data that isn't specifically about the primary theme of a table, then it's probably the case that it should go in another table. For instance, let's suppose that we want to store credit card information in our database. Here's a couple of questions that you might ask when determining where to store those credit card numbers. Does a credit card number describe our customers themselves? And I'd say, no. The credit card number does not describe the customer. Will every customer want us to remember their credit card number? And I'd say probably not. Will some customers have multiple credit cards on file with us? And that's probably a possibility. So credit card numbers are not specifically about the customer. Some customers won't have any, and some customers may have many credit…
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.