Microsoft Access A to Z: Designing Table Relationships

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.
All of my YouTubes can be found at: https://learncs.w3spaces.com/
Thanks, Lisa Friedrichsen

• #howto_style
• #lisa_friedrichsen
• #friedrichsen
• #database
• #relational_database
• #relationships
• #one_to_many
• #one_to_one
• #1_to_many
• #1_to_1
• #one_to_many
• #many_to_many
• #many_to_many
• #table_relationships
• #lookup_tables