{"id":8067,"date":"2017-08-18T21:10:41","date_gmt":"2017-08-19T02:10:41","guid":{"rendered":"https:\/\/kaceli.com\/a\/?p=8067"},"modified":"2022-10-25T20:08:43","modified_gmt":"2022-10-26T01:08:43","slug":"microsoft-access-2016-tutorial-linking-the-tables-and-defining-the-relationships","status":"publish","type":"post","link":"https:\/\/kaceli.com\/a\/microsoft-access-2016-tutorial-linking-the-tables-and-defining-the-relationships\/","title":{"rendered":"Microsoft Access 2016 Tutorial: Linking the Tables and Defining the Relationships"},"content":{"rendered":"<p>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 http:\/\/learn.kaceli.com<\/p>\n<p>In more detail, this session we will focus on:<br \/>\n&#8211; Understand what relational databases are and how to link the tables in the database.<br \/>\n&#8211; Understanding the use primary and foreign keys in Access 2016.<br \/>\n&#8211; Learn how to define the relationships between the tables.<br \/>\n&#8211; Learn how to save the defined relationships between the tables.<br \/>\n&#8211; Explore how to run a query from the linked tables in Access 2016.<\/p>\n<p><iframe title=\"Microsoft Access 2016 Tutorial: Linking the Tables and Defining the Relationships\" width=\"1140\" height=\"641\" src=\"https:\/\/www.youtube.com\/embed\/g4geW2Ybky8?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<p>If you like the video, please &#8220;Like,&#8221; &#8220;Favorite,&#8221; and &#8220;Share&#8221; 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.<\/p>\n<p>Video URL: https:\/\/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: https:\/\/youtu.be\/1IA4SeajZRw<\/p>\n<p>Link to the working files for the tutorial: https:\/\/kaceli.com\/a\/access2016\/<\/p>\n<p>It is suggested that you continue to part 8 after completing this module.<\/p>\n<p>Keep in touch and please spread the word by subscribing and using the share links below the video and commenting:<br \/>\nWebsite: https:\/\/kaceli.com\/a<br \/>\nYouTube Channel: http:\/\/youtube.com\/skaceli<br \/>\nIf you want to take get a deeper understanding of Microsoft Access, take a look at http:\/\/learn.kaceli.com<\/p>\n<p>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.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 http:\/\/learn.kaceli.com In more detail, this session we will focus on: &#8211; Understand what relational databases are and how to link [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[4,205,107],"tags":[],"class_list":["post-8067","post","type-post","status-publish","format-standard","hentry","category-design-2","category-microsoft-access-2016","category-office-2016-tutorials"],"_links":{"self":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/posts\/8067","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/comments?post=8067"}],"version-history":[{"count":0,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/posts\/8067\/revisions"}],"wp:attachment":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/media?parent=8067"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/categories?post=8067"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/tags?post=8067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}