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

Playback starts YouTube’s embedded player (privacy-enhanced mode).

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

355,094 views October 25, 2017 11:11

Watch on YouTube
ChannelSali Kaceli

Description from the creator

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 learn.kaceli.com

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: youtu.be/g4geW2Ybky8. The full tutorial is coming soon. Stay tuned. Access 2016 Part I is here if you want to start from the beginning: youtu.be/1IA4SeajZRw

Link to the working files for the tutorial: kaceli.com/a/access2016/

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:
Website: kaceli.com
YouTube Channel: youtube.com/skaceli
If you want to take get a deeper understanding of Microsoft Access, take a look at learn.kaceli.com

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.

About this tutorial

Sali Kaceli published this 11:11 video tutorial on October 25, 2017. It has been watched 355,094 times on YouTube.

Category
Education
Duration
11:11
Published
October 25, 2017
Views
355,094
Likes
3,039

Tags

Share

Further reading

  • Define relationships between tables in an Access database ... docs.microsoft.com

    In Access 2007, Access 2010, or Access 2013, click Relationships in the Show/Hide group on the Database Tools tab. If you have not yet defined any relationships in your database, the Show Table dialog box is automatical…

  • Guide to table relationships - Access - support.microsoft.com support.microsoft.com

    View table relationships. To view your table relationships, click Relationships on the Database Tools tab. The Relationships window opens and displays any existing relationships. If no table relationships have been defi…

  • How to Set Table Relationships in Access 2016 - dummies dummies.com

    If you want to build a table relationship in Access 2016, you must first open the Relationships window. You do that by following these steps: Click the Database Tools tab on the Ribbon. The Relationships group appears o…

This tutorial in other languages