This course aims to teach learners how to efficiently use Microsoft Access for organizing and storing data. By the end of the course, students will be able to navigate databases, design tables, create queries, forms, and reports, automate tasks using macros and VBA, and enhance database security. The course covers skills such as designing forms, creating switchboards, writing macros, using VBA for automation, and customizing database options. The teaching method includes hands-on exercises, demonstrations, and practical examples. The course is designed for beginners to experienced users seeking to enhance their skills in Microsoft Access.
Overview
Syllabus
Start
Introduction
Introduction to Advanced Forms and Automation
Creating Main Forms and Subforms
Using Subform Control to Connect Sub and Main Forms
Creating Tabbed Forms and Populating Pages
Populating, Aligning, and Spacing Fields and Testing Tabbed Forms
Renaming Page Tabs and Adding Form Headers to Tabbed Forms
Creating Split Forms
Adding Default Values to Form Fields for Data Entry
Adjusting the Tab Order on a Form
Adding Command Buttons to Forms for Navigation
Adding Switchboard Managers to the QAT
Adding Items to Switchboards
Introduction to Designing Macros to Automate Database Tasks
Creating and Testing AutoExec Macros
Using Message Boxes to Inform Users
Automating Parameter Queries with Macros
Viewing Related Records in a Form with Macros
Hiding and Unhiding Field Controls with Macros
Testing the Previous Macro
Using Macros to Validate Data Entry
Introduction to Access Visual Basic for Complex Automation
Using VBA to Secure a Form with a Password
Creating User Input Boxes with VBA
Using Logic Programming to Interpret One or Multiple Conditions
Advanced Forms and Automation Recap
Introduction to Database Security and Options
Splitting Databases for Table Security
Examining Back-End Databases
Moving Back-End Databases and Using the Linked Table Manager to Point to a New Path
Customizing Database Options
Applying the Compact and Repair Tool
Generating Database and Relationship Reports
Database Security and Options Recap
Conclusion
Taught by
Learnit Training
