Access 2019 Advanced
Advanced
1h
By: Edward McCrae
Overview
Access 2019 Advanced will further build upon the topics covered in the Access 2019 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create backups, create and modify Navigation Forms, set startup options, split a database, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), convert macros to VBA, and use Table Events.
Modules
1. Introduction
1.1 Access 2019 Advanced Introduction1 min
2. Improving the Structure of a Database
2.1 Using the Table Analyzer Wizard7 min
2.2 Append Querying to Normalize a Table6 min
2.3 Creating a Junction Table5 min
3. Maintaining a Database
3.1 Backing up a Database2 min
3.2 Using the Compact and Repair Database Tool3 min
3.3 Using the Object Dependencies Tool2 min
3.4 Using the Database Documenter Tool2 min
3.5 Using the Analyze Performance Tool2 min
4. Working with Navigation Forms and Startup
4.1 Creating a Navigation Form3 min
4.2 Modifying a Navigation Form3 min
4.3 Setting the Startup Options2 min
5. Configuring Access for Muliple Users
5.1 Using the Database Splitter3 min
5.2 Configuring Trusted Locations3 min
5.3 Password Protecting a Database3 min
5.4 Password Protecting Modules2 min
5.5 Converting a Database to an ACCDE File2 min
6. Automating Processes with VBA
6.1 Understanding VBA Basics3 min
6.2 Exploring Variables and Control Flow Statements7 min
6.3 Exporting a Table or Query with VBA10 min
6.4 Converting a Macro to VBA3 min
7. Using Table Events
7.1 Understanding Table Events2 min
7.2 Using the Before Change Event Command5 min
7.3 Using the After Update Event Command3 min
8. Conclusion
8.1 Access 2019 Advanced Recap1 min
Ready to Elevate Your Team's Learning?
Talk with our sales team to see how StormWind can transform the way your organization trains and grows.
CONTACT SALES