Microsoft Access A to Z: Relating tables

This short screencast covers the steps necessary to relate tables together in proper one-to-many relationships in an Access relational database. It discusses how to determine proper relationships in the first place, how to create primary key fields, the use of the AutoNumber data type, the role of the primary key field in a table, and how to create foreign key fields. Both existing relationships as well as new one-to-many relationships are examined and created. All of my YouTubes can be found at: https://learncs.w3spaces.com/

Join Today
Microsoft Access A to Z: Designing Table Relationships
▶︎

Microsoft Access A to Z: Designing Table Relationships

Microsoft Access A to Z: Relationship Roundup (a summary of why table relationships are important)
▶︎

Microsoft Access A to Z: Relationship Roundup (a summary of why table relationships are important)

Microsoft Access A to Z: Creating select queries with fields from multiple tables and criteria
▶︎

Microsoft Access A to Z: Creating select queries with fields from multiple tables and criteria

Microsoft Access A to Z: Enforcing Referential Integrity on Table Relationships
▶︎

Microsoft Access A to Z: Enforcing Referential Integrity on Table Relationships

How to Make Multiple Relationship Joins to the Same Table in Microsoft Access
▶︎

How to Make Multiple Relationship Joins to the Same Table in Microsoft Access

Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
▶︎

Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF

How to Create Customer Payment Receipts in Microsoft Access
▶︎

How to Create Customer Payment Receipts in Microsoft Access

Microsoft Access Relationships: Relating Multiple Tables, Relational Data, One-to-Many, Many-to-Many
▶︎

Microsoft Access Relationships: Relating Multiple Tables, Relational Data, One-to-Many, Many-to-Many

Access Form With a Subform and Calculated Fields
▶︎

Access Form With a Subform and Calculated Fields

Microsoft Access A to Z: Building lookup tables to create drop-down lists (combo boxes)
▶︎

Microsoft Access A to Z: Building lookup tables to create drop-down lists (combo boxes)

Microsoft Access A to Z: Everything you need to know about subforms
▶︎

Microsoft Access A to Z: Everything you need to know about subforms

Microsoft Access Tutorial - Beginners Level 1 (Quick Start)
▶︎

Microsoft Access Tutorial - Beginners Level 1 (Quick Start)

Creating Employee Management Database in MS Access FULL LESSON | with Leave Management
▶︎

Creating Employee Management Database in MS Access FULL LESSON | with Leave Management

Microsoft Access A to Z: Building Reports using Sections, Labels, and Text Boxes
▶︎

Microsoft Access A to Z: Building Reports using Sections, Labels, and Text Boxes

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

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

Microsoft Access A to Z: An overview of what Access can do
▶︎

Microsoft Access A to Z: An overview of what Access can do

Relationships with More than 2 Tables in Microsoft Access: Assign Orders to Projects for Budgeting
▶︎

Relationships with More than 2 Tables in Microsoft Access: Assign Orders to Projects for Budgeting

Simple Security for Microsoft Access Databases. Hide Tables. Disable Ribbon. Make ACCDE File.
▶︎

Simple Security for Microsoft Access Databases. Hide Tables. Disable Ribbon. Make ACCDE File.

Introduction to Databases: LibreOffice Base Tutorial
▶︎

Introduction to Databases: LibreOffice Base Tutorial

Microsoft Access Genealogy Database. Track Ancestry. Build a Family Tree. Self Join.
▶︎

Microsoft Access Genealogy Database. Track Ancestry. Build a Family Tree. Self Join.