Dive into an expert-level tutorial on Microsoft Access 2021, designed for users ranging from beginners to experienced professionals seeking to enhance their skills and boost efficiency. Learn to navigate and create relational databases, mastering the Access interface and essential objects. Explore table design, data import from Excel, manual data entry, sorting, and filtering techniques. Delve into table relationships, query creation, form design, and report generation. Advance to complex topics such as switchboard creation, macro writing, and Visual Basic for Applications (VBA) implementation for advanced automation. Discover database security measures and customization options to optimize your Access experience. Gain hands-on practice with provided exercise files and access additional resources for comprehensive learning.
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
