Dive into advanced Microsoft Access 2021 techniques in this comprehensive tutorial designed for users of all levels seeking to enhance their database management skills. Learn to navigate and create complex relational databases, mastering the Access interface and essential objects. Explore table design, data import, and manipulation techniques before delving into advanced form creation, including subforms, tabbed forms, and split forms. Discover how to automate tasks using macros and Visual Basic for Applications (VBA), implement database security measures, and customize options for optimal performance. By the end of this tutorial, you'll be equipped to create sophisticated, efficient, and secure Access databases tailored to your specific needs.
Overview
Syllabus
Start
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
