MS Access Complete Tutorial | Database Design, Forms, Queries & Reports | Step-by-Step Project

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