Access 365 Advanced
Advanced
2h
By: Edward McCrae
Overview
Access 365 Advanced will further build upon the topics covered in the Access 365 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 365 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 Backup up a Database3 min
3.2 Using the Compact and Repair Database Tool3 min
3.3 Using the Object Dependencies Tool3 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 Form5 min
4.3 Setting the Startup Options3 min
5. Configuring Access for Muliple Users
5.1 Using the Database Splitter4 min
5.2 Configuring Trusted Locations3 min
5.3 Password Protecting a Database4 min
5.4 Password Protecting Modules2 min
5.5 Converting a Database to an ACCDE File2 min
6. Automating Processes
6.1 Understanding VBA Basics3 min
6.2 Exploring Variables and Control Flow Statements10 min
6.3 Exporting a Table or Query with VBA9 min
6.4 Converting a Macro to VBA2 min
7. Using Table Events
7.1 Understanding Table Events2 min
7.2 Using the Before Change Event Command7 min
7.3 Using the After Update Event Command4 min
8. Conclusion
8.1 Access 365 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