MIT Sloan: Lead AI Adoption Across Your Organization — Not Just Pilot It
Master Windows Internals - Kernel Programming, Debugging & Architecture
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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
Reviews
5.0 rating, based on 1 Class Central review
Showing Class Central Sort
-
I have successfully completed the Access 2021 Full Course, and it was very useful and well-structured learning experience. The course covers all essential topics, starting from the basics of database and moving to more advanced features like queries, forms reports, macros, and VBA.
I especially liked how clearly the concepts were explained, making it easy to undersatand even for beginners. The step by step approach helped me learn how to create database, manage tables, and write queries using SQL.
This course gave me an essential foundation in Microsoft Access and improved my understanding of database systems overall. I would like to recommend to everyone who is going to start learning Access.