Database Modelling
[05 minutes] Relational Database Concepts
[15 minutes] Entity Relationship Diagram (ERD) Training Video
Normalisation
[03 minutes] what is database normalization Database
[02 minutes] What Is Database Normalization?
[03 minutes] Understanding Normalization
[16 minutes] Database Terminology and Normalization
Overview of the need for databases
[10 minutes] Referential Integrity
[11 minutes] Microsoft Access 2010 Tutorial Part 00 of 12 - Introduction
This is a waffle introduction to terminology etc. No actual Access usage.
[12 minutes] Microsoft Access 2010 Tutorial Part 01 of 12 - Database Terminology
More terminology, No actual Access usage.
Planning tables - Plan ahead
[10 minutes] Microsoft Access 2010 Tutorial Part 02 of 12 - Planning Your Database
Pay attention at 5:15 into the video
[13 minutes] Introduction to Access 2010 Table Relationships
Starting to use Access, explaining the user interface features
[11 minutes] Microsoft Access 2010 Tutorial Part 03 of 12 - The Access Interface
Keys
[06 minutes] Microsoft Access 2010 - The Primary Key - Tutorial
Creating a table and Datatypes
[11 minutes] Microsoft Access 2010 Tutorial Part 04 of 12 - Customer Table, Part 1
[13 minutes] Microsoft Access 2010 Tutorial Part 05 of 12 - Customer Table, Part 2
at 10:50 primary key explained
Entering data directly to a table
[12 minutes] Microsoft Access 2010 Tutorial Part 06 of 12 - Entering Data, Part 1
Queries
Select queries are essentially virtual tables (views)
[12 minutes] Creating Queries with Microsoft Access 2010
[08 minutes] Creating A Simple Select Query in Microsoft Access 2010
[09 minutes] Create Queries with Calculated Fields and Aggregate Functions
[07 minutes] 29/50 - Select Queries (Returning Null Values) - Microsoft Access 2010 Tutorial
Forms
Reports
[15 minutes] Microsoft Access 2010 Tutorial Part 11 of 12
[13 minutes] Sorting and Grouping in Microsoft Access Reports
[06 minutes] Access 2010 Tutorial Creating Subreports