Analytics-B: Relational Database in Microsoft ACCESS

Theory

Gallaugher Chapter 15: Data Asset

Introduction to Relational Databases (Stanford University) (14 minutes)

Introduction to Database Fundamentals (Microsoft Enterprise Consortium)

The Relational Model (Stanford University) (9 minutes)

Data Model (Microsoft Enterprise Consortium)

Relationships (Microsoft Enterprise Consortium)

Defining Relationships (Microsoft Enterprise Consortium) 
 

Practicals

 Microsoft Access: Beginning from a template (2 minutes)

Importing Excel data into Access

Creating relationships in Access

Creating queries in Access

Creating tables in Access

Creating forms in Access

Explore these Atomic Learning training modules (available for free from Chatham)

Section D "Creating a Database" of the Atomic Learning Access Training Collection (20 minutes)

Section E "Creating a Table" of the Atomic Learning Access Training Collection (20 minutes)

Section F "Working with a Table" of the Atomic Learning Access Training Collection (35 minutes) 

Physical Design Part 1 (Microsoft Enterprise Consortium)

Microsoft Access 2013 Training on Table Relationships - Part 1

Physical Design Part 2: Relationships (5 min) 

Physical Design Part 3 :Primary Key, Unary One-to-Many Relationship, Binary One-to-One Relationship (5 min)

Physical Design Part 4 :Many-to-Many Relationship (5 min)

Physical Design Part 5 :Multivalued Attribute (5 min)

Microsoft Access 2013 Tutorial on relationship - Part 2 (8 min) 

"Understanding Referential Integrity" from Guide to Table Relationships in Access (by Microsoft Office) 

Introduction to SQL with Hour of Code (1 hour)