Access 2016 Advanced will further build upon the topics covered in the Access 2016 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create and modify Switchboards, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), and use Table Events.
Instructor: Ed McCrae
Student data files are available under Downloads in the course dashboard.
What am I going to get from this course?
- Improve the Structure of a Database
- Maintain a Database
- Work with Access Switchboards
- Configure Access for Multiple Users
- Automate Processed with VBA
- Use Table Events
Prerequisites and Target Audience
What will students need to know or do before starting this course?
Access Introduction and Intermediate courses or equivalent experience.
Who should take this course? Who should not?
Students who wish to learn the more advanced capabilities of Access.
Module 1: Introduction
Student Data Files
Module 2: Improving the Structure of a Database.
Using the Table Analyzer Wizard
Append Querying to Normalize a Table
Creating a Junction Table
Module 3: Maintaining a Database
Backing Up a Database
Using the Compact and Repair Database Tool
Using the Object Dependencies Tool
Using the Database Documenter Tool
Using the Performance Analyzer Tool
Module 4: Working with Access Switchboards
Understanding the Access Switchboard
Using The Switchboard Manager
Modifying a Switchboard
Setting the Startup Options
Module 5: Configuring Access for Multiple Users
Using the Database Splitter
Configuring Trusted Locations
Password Protecting a Database
Password Protecting Modules
Converting a Database to an ACCDE file
Module 6: Automating Processes with VBA
Understanding VBA Basics
Exploring Variables and Control Flow Statements
Exporting a Table or Query with VBA
Converting a Macro to VBA
Module 7: Using Table Events
Understanding Table Events
Using the Before Change Event Command
Using the After Change Event Command
Module 8: Conclusion