🔗

Module 2: Tables & Relationships

Create tables with data types that reject bad entries, then link them so Access enforces the connections your design assumes.

2
Lessons
46
Minutes
Practice
Files Included
Beginner
Level

Lessons

Complete each lesson in order. Watch the video, review the notes, and finish the challenge.

Lesson 1⏱ 24 min
🔗

Creating Tables and Choosing Data Types

Build tables in Design view and choose data types that make invalid entries impossible rather than merely discouraged.

Lesson 2⏱ 22 min
🔗

Relationships and Referential Integrity

Link tables so Access enforces the connections between them, and understand what referential integrity actually prevents.

Module 3: Queries →