From the course: Learning Relational Databases

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Establish relationships in Access

Establish relationships in Access

From the course: Learning Relational Databases

Start my 1-month free trial

Establish relationships in Access

“

- [Instructor] Now that all of our tables are created, we need to establish the relationships between them. To do that inside of Access, we'll come up to the Database Tools tab and press the Relationships button. That'll bring up the Show Table window. Now choose the Customers table, and then Shift + Click Products to select all of them, and then press Add to add them in here to the map in the back. Let's go ahead and press the Close button, and we'll see them there. Now, the layout here inside of the Relationships screen should look a lot like our data model. We can move these windows around that represent each of our tables, and we can see the fields down below. If we need to, we can expand the window open in order to see all the different fields. I find it easier to make sure that the layout here inside the Relationships window matches the data model. So let's go ahead and move these into position so that it matches the model that I showed earlier. I'll move Invoices there. I'll…

Contents