Microsoft Access A to Z: Designing Table Relationships

In this short video we'll examine table relationships in a number of different Access applications including the classic Northwind database. Proper table relationships are foundational to data accuracy and peak database performance. We'll define how one-to-many relationships work with the primary key field and foreign key field, discuss one-to-one relationships, and also show how to create many-to-many relationships using junction tables. We'll also examine Lookup tables, and how they help define and constrain values for a field.
Thanks, Lisa Friedrichsen

[bluesmaster]

WOW! This is the BEST explanation of the "SO WHAT" for Access. I've been having a difficult time trying to figure out the Relational aspect, particularly in regards to the "Normalization" of the database. This is FANTASTIC.

[greenhoodie]

This was very well explained, thank you.
This has helped me understand the depth of thought needed when planning out a db before you even start!

[Aixatem]

I've been watching this video to understand access database better for my class. Now I'm giving my exam on it. Thanks to you, I feel more confident about it!

[emmieHD]

Great video! It explained relationships clearly and concisely with great examples that answered the question I had. Thank you!

[FirstLast-cbjr]

Another excellent video: I’m glad That YouTube found you for me!!

[zachbiderman]

Lisa you are making me better at my job and I appreciate you!!!

[aftabsmerchant]

We are looking forward for more on Acces from you, Especially explain the making of Northwind

[harrynickel]

Thanks. This video helped fill in some holes.

[smalik]

thank you so much this helps me a lot 💖🤝

[kunxuan]

Thanks so much for the succient yet clear explanation, i want to study the Northwind database, and checked the link, but it does not work, i could not download the file. can you please kindly share the file with me? 🥰

[mividalocastudio]

Amazing video. However, I have a question... How is the ShipperID (primary) key in Shippers table linked to a ShipVia as a 1 to many relationship in the Orders Table, when the ShipID and ShipVia names do not match? I thought they always had to match like SupplierID (primary) in Supplies Table to SupplierID (many) in Products Table. What am I missing? LOL

[easyspeak]

I thought the middle link table was the 1-side of the other two connecting tables. Creating effectively two joined many:1 tables that make up a many to many relationship.. ?

[deholovi]

I'm stuck with sub datasheet view! for example, I've 3 separate tables. wanna relate them with one junction table. say, number 2 table has a common field ( could be described as the master field ), which is related to two other fields. one from number 1 table and another from number 3 table. after creating the relationship, when u press the " + " sign of the sub datasheet view, " insert sub datasheet " dialogue box appears! why so? I just wanna see related fields to that particular field. why that doesn't happen?

[usmanyousaf]

i want some information about Ms access

[kawtheralateeq]

If I have questions where can I ask you ?

[johnnychin]

i need help, i have item say tshirt size small, but the price varies with different customer. say customer A, the tshirt small is US2.0, IF customer B the price its US 3.0, and tshirt medium for customer A is US4.0 AND US5.0 FOR CUSTOMER B. how do i make the table for this scenario