Overview
This course teaches beginners through experienced users how to efficiently organize and store data using Microsoft Access. By exploring relational databases, creating database tables, importing data, and designing advanced reports and forms, students will learn to navigate the Access interface, automate queries, and use Access Visual Basic for Applications (VBA) for complex automation. The course covers database security and customization options, making it suitable for everyday users looking to enhance their Microsoft Access skills.
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