Microsoft Access A to Z: Relationship Roundup (a summary of why table relationships are important)

This screencast is part of a playlist that summarizes why proper one-to-many relationships are essential for a healthy relational database and how those relationships work within a query. One-to-many and many-to-many relationships are reviewed, as well as the left and right outer joins between tables, and how those joins are used to find specific data in the database including orphan records. In addition, referential integrity is reviewed, and the SQL statements stored by select queries are examined.
All of my TH-cams can be found at: learncs.w3spaces.com/

[@erinkavanagh3553]

Thank you for the information

[@lfriedrichsen]

You're welcome! You can find all of my TH-cams organized at learncs.w3spaces.com/

[@erinkavanagh3553]

More please

[@lfriedrichsen]

You're welcome! You can find all of my TH-cams organized at learncs.w3spaces.com/