Learn the fundamentals of Microsoft Access in this beginner tutorial designed for those new to database management or transitioning from Excel or Google Sheets. Master the Access interface and discover how to create and manage tables, build relationships between data, design queries to filter information, develop user-friendly forms, and generate professional reports. Explore essential features including input masks, data types, field properties, and automation through macros and modules. Perfect for professionals, students, or anyone handling large datasets who needs to organize, analyze, and report information more efficiently. By the end of this 1 hour 40 minute training, build a functional, relational database from scratch and confidently navigate Access to streamline data management tasks.
Microsoft Access Beginner Tutorial - Database Management Fundamentals
Overview
Syllabus
Start 0:00
Introduction 0:09
Access Startup Page 1:23
Access Interface 3:06
Access Objects 5:20
Tables 6:01
Queries 7:30
Forms 8:20
Reports 9:18
Macros and Modules 9:50
Working with Tables 12:04
Sorting and Filtering 19:29
Creating a Table 39:05
Field Properties 1:00:37
Look Ups for Dropdown Lists 1:16:32
Creating More Tables 1:17:20
Creating Relationships and Trouble Shooting 1:24:20
Using Lookup Wizard to Create Relationships 1:34: 29
Conclusion 1:39:27
Taught by
Learnit Training
