From the course: Access 2019: Building Dashboards for Excel
Join today to access over 24,400 courses taught by industry experts.
Understanding table relationships
From the course: Access 2019: Building Dashboards for Excel
Understanding table relationships
- [Instructor] Whenever you work with the backend of any database system, you're at the mercy of how it was designed. Let's take a look at some of the relationships you might, or might not see in your databases. Go ahead and open up the Northwind database in your exercise files in chapter three. When you open that up you'll be prompted with the login dialogue. We'll just go ahead and close that. This sample database shows you all about Access, the tables, queries, and reports, and relationships. So let's take a look at the Database Tools, and choose Relationships. We have few tables brought in, and you can see relationships between the tables. This is great, it reduces the amount of joining you'll have to do in queries. So I see Orders and Order Details, and I see they're related through the Order ID. I see symbols like the one, and the infinity symbol. This tells me that there's one order, and there's multiple details…
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.
