Microsoft Access 2016 Tutorial: Linking the Tables and Defining the Relationships

This is part 7 of a multiple part series of the Access 2016 tutorial. This session focuses on concepts related to linking Access tables in a database and properly defining the relationships. Learn more at

In more detail, this session we will focus on:
– Understand what relational databases are and how to link the tables in the database.
– Understanding the use primary and foreign keys in Access 2016.
– Learn how to define the relationships between the tables.
– Learn how to save the defined relationships between the tables.
– Explore how to run a query from the linked tables in Access 2016.

If you like the video, please “Like,” “Favorite,” and “Share” it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series.

Video URL: The full tutorial is coming soon. Stay tuned. Access 2016 Part I is here if you want to start from the beginning:

Link to the working files for the tutorial:

It is suggested that you continue to part 8 after completing this module.

Keep in touch and please spread the word by subscribing and using the share links below the video and commenting:
YouTube Channel:
If you want to take get a deeper understanding of Microsoft Access, take a look at

Copyright notice: These videos may not be downloaded or distributed in any way without permission from Sali Kaceli. Contact me if you have such a need.

Recent Posts

Leave a Comment

Contact Us

We're not around right now. But you can send us an email and we'll get back to you, asap. Thank you, Sali Kaceli

Not readable? Change text. captcha txt