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:
[ Ссылка ]
BECOME A MEMBER:
YouTube: [ Ссылка ]
or My Site: [ Ссылка ]
LEARN MORE:
[ Ссылка ]
LINKS:
Subforms: [ Ссылка ]
Open Form Specific Data: [ Ссылка ]
Blank Template: [ Ссылка ]
Contacts: [ Ссылка ]
Access Expert 1: [ Ссылка ]
Relationships Seminar: [ Ссылка ]
COURSES:
FREE Access Beginner Level 1: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: [ Ссылка ]
Blank Template: [ Ссылка ]
Contact Management: [ Ссылка ]
Order Entry & Invoicing: [ Ссылка ]
More Access Templates: [ Ссылка ]
ADDITIONAL RESOURCES:
Donate to my Tip Jar: [ Ссылка ]
Get on my Mailing List: [ Ссылка ]
Contact Me: [ Ссылка ]
TechHelp: [ Ссылка ]
Consulting Help: [ Ссылка ]
Twitter: [ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
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.
