In this video, we're going to learn how the relationships in relational database management systems work. We're going to talk about one-to-one, one-to-many, and many-to-many relationships, and learn a simple method on how to choose tables for joining in a single query or view. One method will highlight the problem of duplicates that result from query joins, and how to design queries to avoid it. We'll also learn about explicit and implicit relationships between tables, and to be careful to watch for automatic joins when we make queries. We'll cover some of the extended solutions in upcoming videos, including the use of common table expressions, inline queries and others. Related Videos: How to Cycle Through Many TableDefs to Rename or Delete Many Tables in MS Access https://www.youtube.com/watch?v=ywTfKmei5Qc How to Delete Duplicate Records in MS Access https://www.youtube.com/watch?v=2fEdpBNuddc How to Add an Index to Your MS Access Table https://www.youtube.com/watch?v=A8-9erFqfkI How to Use Composite Keys in Microsoft Access https://www.youtube.com/watch?v=ZgzQfXHOiic How RDBMS Relationships Work You are watching this video now! How to use Transactions in MS Access - BeginTrans, Commit, Rollback https://www.youtube.com/watch?v=Rr4_XAabNFg How to Manually Enter Values into an Autonumber Field in MS Access https://www.youtube.com/watch?v=rJTRlNFu38k Replication in Microsoft Access https://www.youtube.com/watch?v=II268bWpD1c Follow us on social media: https://www.facebook.com/mackenziedataanalytics/ https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering ags RDBMS SQL index How RDBMS relationships work query one to one one to many many to many duplicate problem inner join relational database microsoft access constraints sql normalization sean mackenzie