Learn Microsoft Access from scratch with this complete, hands-on tutorial designed for students, beginners, and database learners. In this full-length course, we build a real-world Books Inventory & Sales Database step by step—covering tables, relationships, referential integrity, forms, queries, and reports.
This tutorial follows a practical project-based approach, making it ideal for:
🎓 College & university students
🧑💼 IT & database professionals
📊 Business intelligence & data learners
📘 Academic semester courses
00:00 – Relational Database Overview
⏱ 05:47 – Solution Overview
⏱ 10:46 – Overview of Completed Project
⏱ 16:21 – Database Design & Referential Integrity (Concepts)
⏱ 28:34 – Overview of Forms in MS Access
⏱ 33:51 – Master-Detail Form for Entering Purchases & Sales ⏱ 39:14 – MS Access Books Database: Creating Project from Scratch
⏱ 42:45 – Creating Tables ⏱ 58:46 – Enforcing Referential Integrity ⏱ 1:05:51 – Creating Books Form & Using Combo Box
⏱ 1:14:47 – Creating Books Transaction Form ⏱ 1:30:46 – Creating Master Transaction Form
⏱ 1:43:17 – Creating Master-Detail Form for Purchases & Sales
⏱ 2:04:35 – Using Command Buttons to Open Forms
⏱ 2:15:18 – Creating Query for Inventory Report
⏱ 2:39:48 – Data Cleaning & Formatting
⏱ 2:36:43 – Creating Inventory Report