Microsoft Access A to Z: Designing Table Relationships




About this tutorial:

Video duration: 00:10:40
In this short video we’ll examine table relationships in a number of different Access applications including the classic Northwind database. Proper table relationships are foundational to data accuracy and peak database performance. We’ll define how one-to-many relationships work with the primary key field and foreign key field, discuss one-to-one relationships, and also show how to create many-to-many relationships using junction tables. We’ll also examine Lookup tables, and how they help define and constrain values for a field.
~Lisa Friedrichsen

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads