Microsoft Access 2013 Tutorial - Relationships Between Tables - Part 1 - Access 2013 Training

✅ Get a FREE Microsoft Access 2019 Introductory Course here

In this video tutorial, learn the basic steps on how to create relationships between tables in Access 2013.

✅ Get the full course on Access 2013 course here:

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

Welcome back to our course on Access 2013. In this section we’re going to look at relationships between tables in an Access 2013 database and we’re going to begin by looking at genre for a movie.
Now first of all I want to go to the movie table and I want to open it. So we’re going to look at the data. So double click to open. And you may remember that for one movie, Identity Thief, we earlier entered the genre as comedy, comma, thriller. And you may also recall that we can have a number of different genre defined here separated by commas.

But as I pointed out that’s not really good design and it carries with it a number of problems that will become apparent a bit later on. So what we’re going to do is to setup a proper relationship between the movie table and the genre table.

But for the moment let’s now go into the table design for movies. So I go into Design View. We had a field there, Genre, which is the one that holds currently the genre values separated by commas. I want to delete that row. It’s straightforward enough.

When I’m in Design View, the contextual tab Design in table tools is available and one of the options there is delete rows. So I can just literally delete a field. Now note the warning you get if you try to delete a field in a table. Do you want to permanently delete the selected fields and all the data in the fields? When I’m deleting this I’m deleting any data for any record any movie that’s got genre information. Now at the moment, I’m happy with that because I only put that genre info in as a demonstration so I’m going to say yes and the genre information is gone. I’m going to close the movie table again and say yes to saving changes.

Now what I’m going to do is to go to the Database Tools Tab and on there I’m going to click on Relationships and relationships gives me a diagrammatic representation of the relationships between the tables in my database. Now at the moment the diagram there is completely blank. It’s behind this little dialog but it’s completely blank and I want to add two tables to it. I want to add the movie table. So select it, click on Add, and I want to add the genre table. Select it, click on Add.

Now what I’m going to be doing is to create another table that links movies with their genre values. So for one movie there will be multiple genre values. Now the way I do this is first of all I will do Create table. So let me go to Create table and I’m going to go into Design View. I’m going to call the table tblMovieGenre just to emphasize the fact that it basically links a movie to a genre or many genre. By default an ID field is created. But I also want two more fields in it. One field I want is a field that will point to the movie that I am referring to. So I’m going to put in here movie. The next field will point to the genre and basically what will happen is that in this table I will have many entries that link the movies to their various genre.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.

[augustineowusu]

Thanks. I've watched several videos today trying to understand how to create relationships. Your video is the only one that has given me the understanding. thanks. keep it up.

[numberDon]

Awesome, very well explained, im glad you took your time explaining the concepts rather than rushing through.

[KalenLake]

Great tutorial, and I didn't realize you could speed them up. That helps tremendously! Thanks.

[perryhoofd]

The first tutorial that is not in broken English, thanks :D

[PrimeM]

Great tutorial! Helped me to understand this concept more clearly. I'm trying to create a relational database using one table containing company names and addresses and another containing employees of each company and their current set of qualifications (relevant to the training organisation I'm working for). Slightly more complex but I'm getting there. Thanks for this!

[jetjet]

With a voice like that you should be narrating planet earth or something! 

[carvelbell]

This is a very good tutorial. I truly enjoyed watching it. Excellent. Keep up the good work.

[tomthumb]

Brilliantly. Explained thank you. I’ve now subscribed to this channel.

[antoniompacosta]

the way you say 'Genre' is priceless

[katib]

This video is very useful and helps a lot.
Thank you)

[bellbeeB]

everyone's complaining, but i needed it to be slow and meticulous, otherwise I would have never understood. thanks.

[coolstevie]

Thank you for this! Will help me in the future.

[SomeIrishLad]

Thanks, this video really helped a lot.

[phortonatdsc]

Simon...thank you for a great presentation! I have been working in 2013 for a week now, and have viewed several of your videos, but my system does not seem to want to provide the crows foot depiction in my relationships. I seem to just have lines without any icons? Any thoughts? Thanks!

[michaelmiller]

@ Dixie Peach, make sure you have a primary key designated for each table in the relationship.  In my experience, if one of the fields is not selected as the primary key (it doesn't have to be one of the fields involved in the relationship), then the 1 to 1, 1 to many, or many to 1 icons won't show up.

[allanbondoc]

Thanks for the helpful video. And I've a question for what sort of Laptop should I buy to work with Access, Excell and all the programs and window 7, 10 or which one. For these days there are so many different kinds. So please, like to have your suggestion. Thanks.
Jack.

[stanislavignatavicius]

Very useful. thank you for help, keep up the good work

[kareenmcintosh]

I think you are a very good teacher... Love your work. 
I'm trying to figure out an issue in Access and i really really hope you will assist me. If I'm selling cars for individuals and each individual might have one or more vehicles at the price they wish to sell for, how would i setup the database to reflect the customer's info (persons I'm selling cars for) and their vehicle details with their desired selling cost bearing in mind a customer could be selling more than one vehicles.
I setup a customer table with all the customers contact info but I'm thinking i would need to setup individual vehicle table for each customer because even though two customers might  be selling the same exact type of vehicle, same year and everything the selling cost will differ a lot of time. So you see the regular one to many relationship won't work for this system or can it? Not sure how to work this one at all. Will you help

[jedisenpei]

You seem to like the word "genre" very much. Very slow explanation, but at least you explained it.

[themanbehindthescenes]

I have a question, why not ditch the data type auto number for the Movie field and make it a Short Text ? this way is more realistic and you link to the movie foreign key attribute in the join table.