Microsoft Access Relationships: Relating Multiple Tables, Relational Data, One-to-Many, Many-to-Many

In this video you will learn about relationships in Microsoft Access. You will learn how to relate data from different tables together, and why it's important for good database design.

Simone from Bridgeport, Connecticut (a Platinum Member) asks: I'm a realtor. I'm in the process of setting up my first Access database. I've been using Excel for years to track my customers and the houses they've purchased. Once in a while I get a customer who has purchased multiple houses. Should I make a separate entry for each of them in my customer table? It seems like this would be an awful lot of duplicated data.

Silver Members and up get access to an Extended Cut of this video. Members will learn about Self Joins, Global Relationships, and Referential Integrity which is where you can prevent entry of a child record without a matching parent record, or delete a parent if it has children. We'll also talk about cascade updates and deletes and why I personally don't use them.

MEMBERS VIDEO:
https://youtu.be/F4DLbs__LFQ

BECOME A MEMBER:
YouTube: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: https://599cd.com/THMember

LEARN MORE:
https://599cd.com/Relationships

LINKS:
Subforms: https://599cd.com/Subform
Open Form Specific Data: https://599cd.com/OpenFormSpecific
Blank Template: https://599cd.com/Blank
Contacts: https://599cd.com/Contacts
Access Expert 1: https://599cd.com/ACX1
Relationships Seminar: https://599cd.com/RelationshipSeminar

COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, lrelationships, relational, one-to-many, one-to-one, many-to-many, relate data, self join, global relationships, edit relationships, referential integrity, parent, child, matching, cascade updates, cascade deletes

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

Видео Microsoft Access Relationships: Relating Multiple Tables, Relational Data, One-to-Many, Many-to-Many канала Computer Learning Zone