From the course: Learning Access for Office 365
Join today to access over 25,300 courses taught by industry experts.
Define table relationships
From the course: Learning Access for Office 365
Define table relationships
- [Voiceover] Having data stored in your tables is a good first step, but the real power of the database is reviled when you start relating tables to one another. By making the connection between how a record in one table relates to records in another table. You can start to understand the bigger picture of your organization or business. In the case of the Landon Hotel, we have rooms in one table and we have guests in another. It would certainly make sense to see where those two intersect and find out which guests checked into which rooms and when. I've added another table to our database. It's over here in the navigation pane, called room assignments. Let's go ahead and double click on it to see the details that are inside. First, we have the ID column. Which is the primary key for this table. Its only purpose is to make sure that Access can keep the individual records separate from one another. Next, we have the room number column, and I'm just gonna click here and drag it open a…
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.