Microsoft Access Relational Database Quiz 2: Tables, Relationships, and Junction Tables

Put your Microsoft Access relational database knowledge to the test with five questions covering the building blocks of a well-designed database.This quiz explores how related tables work together, why a vehicle record should store a CustomerID instead of repeating customer details, and how one-to-many relationships handle customers with multiple orders or vehicles.It also covers the many-to-many relationship and the role of junction tables when both sides of a relationship can have multiple related records. A quick, practical review for Access users who want to avoid duplicate data and design cleaner databases.