From the course: Excel Business Intelligence: Data Modeling 101

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Modify table relationships

Modify table relationships - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Data Modeling 101

Start my 1-month free trial Buy for my team

Modify table relationships

“

- [Chris] Okay, now we know how to create table relationships, but what if we need to make changes? Let's talk about modifying table relationships. If you look at the design tab in the data model view, you'll see a manage relationship button that opens up a dialog box like this. In this window, you can create, edit, or delete any connection or relationship that you have in your data model. You can use this to see all of your table relationships as well as your table names, the cardinality, which we'll talk about soon, and the filter direction, which we'll also dive into. Quick note, if you actually double click the line connecting two tables to form a relationship, you can actually edit individual relationships that way as well. I'll show you both approaches. Back in our data model diagram view here, I'm going to go ahead and jump to the design tab. Let's see what we have to work with, with this manage relationship button. Here we can see that our model contains a total of five…

Contents