How to View Microsoft Access Relationships With the Relationship Builder

Video Transcript

"Hi my name is Dave Andrews. Today I'm going to show you how to view Microsoft Access relationships in the relationship builder. Lets begin by opening up Access by clicking on start, going to all programs. Lets open Microsoft Access here. Now lets create a new database. Click on the office button, and say new. Lets go leave the name as database four and I'm going to say create. Lets create a table here. It comes with an ID field so we are going to add a field called name and I'm just going to put Dave in there. And we are going to open this table in the design view. Lets rename our field to name. Now what we are going to do is build another, it's best not to actually call it another name,lets call it person name. That's what that message that came up just said. So lets save our table and we will create another table by going to create tab, and clicking on table. Now what we are going to put here is phone numbers. So I'm going to put a phone number in. We are going to save our table as table two. And go to design view. And lets rename that field name as phone number. And click save. Now we want to create a relationship between table one and table two that will relate me to my phone number. Go to database tools, and then under show hide click on relationships. Lets add in table one and table two by selecting each of them and clicking add. Now to create our relationship and then to see it click and hold down on the ID field on table one and drag it on top of the ID field on table two. And then click create. As you can see we have a relationship between table one and table two now. My name is Dave Andrews and I've just showed you how to view relationships using the Access relationship builder."