Overview
Embark on a comprehensive 6-hour journey through Microsoft Access 2021 in this in-depth tutorial. Master the fundamentals of relational databases, navigate the Access interface, and learn to plan, design, and create database tables. Explore data import techniques, sorting and filtering, and establish table relationships. Dive into creating queries, forms, and reports, and discover how to automate processes using macros and Visual Basic for Applications (VBA). Cover advanced topics such as report and form design, switchboard creation, database security, and customization options. Suitable for beginners and experienced users alike, this course aims to enhance your efficiency and proficiency in Microsoft Access, equipping you with the skills to organize, store, and analyze data effectively.
Syllabus
Introduction
Database Objects and the Access Interface
Creating New Databases
Entering Data into Tables
Relationships
Queries, Forms, and Reports
Query Reports and Complex Queries
Advanced Reports, Automating Queries, and Using Query Wizards
Action Queries
Advanced Forms and Automation
Designing Macros to Automating Database Tasks
Access Visual Basic for Complex Automation
Database Security and Options
Conclusion
Taught by
Learnit Training