Learn MS Access and Build your First Database Today @chandoo_
Learn MS Access and Build your First Database Today  @chandoo_
Uploaded November 2025 | Updated November 2026, 2 hours ago
Microsoft Access is the easiest and best starting database for many businesses and day to day applications. In this comprehensive video, learn how to use MS Access and create your very first database in under 45 minutes!

πŸ“• Concepts covered in this video

What is MS Access
Database theory
Creating tables and adding data in Access
Table design mode vs. data sheet mode
Linking one table with another with relationships
Keys (primary vs. foreign)
Data validation in Access
Creating data entry forms in Access
Linking one form to another (nested forms) in Access
Writing queries in Access - simple and complex example
Creating reports from your database
Saving and reopening Access files



πŸ“ Download Files:

Sample Access DB
github.com/chandoo-org/SQL/raw/refs/heads/main/OUR%20FIRST%20DB.accdb

Customer Data (for copy pasting)
github.com/chandoo-org/SQL/blob/main/customer%20data.xlsx

All other data (for copy pasting)
github.com/chandoo-org/SQL/blob/main/data%20for%20the%20database%20v1.xlsx


πŸ•œ Video chapters:

0:00 - What to expect in this video
00:15 - What is MS Access and how to get started with it?
05:20 - Creating your first database table (customer table)
13:39 - Adding data to Access by copy pasting (from Excel)
20:47 - Setting up table relationships in Access (Primary vs. Foreign Key)
26:18 - Forms in Access
34:05 - Nested Forms in Access
37:09 - Queries in Access
46:20 - Creating your first report in Access
50:21 - Saving and Reopening your Access DB

~

Two tables were having a romantic date πŸ₯°
Another table walks up to them and says...
That looks fun ... Can I join you? πŸ˜‚

#Access #database
Learn MS Access and Build your First Database TodayCompare Two Texts - Excel Formula HackFREE Adv. Masterclass on Power BI - Create a Sales Analytics Dashboard (with files πŸ“)Excel Drop Down Lists that Auto-Expand with Your Data - Easy Trick πŸ’‘Make a Gantt Chart in Excel with Just One Formula!Combine 2 Tables Quickly with this AMAZING Excel FormulaThis Simple VBA Trick Saved me Hours Today πŸ’‘How to make a Map Chart in Excel - Quick & Simple TutorialLearn Advance Excel Formulas in an Hour - FREE MasterclassPower BI Real-time Dashboard - Masterclass (with FREE sample file πŸ“)Power BI Visuals Masterclass – Make Charts That Actually Tell a StoryHow to create a Work Schedule (Roster) using Excel
Chandoo |

Learn MS Access and Build your First Database Today

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER