Students will learn the advanced features and functionality of Access 2016.
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 by using the table analyzer wizard and creating a junction table. They will explore how to maintain an Access database, including how to back up a database and how to use various tools such as the object dependencies tool. Students will also learn how to create and modify Switchboards, how to configure security and access for multi-user environments, how to automate processes with VBA (Visual Basic for Applications), and finally how to use Table Events.
- 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
Access Introduction and Intermediate courses or equivalent experience.
Who is this course intended for?
Students who wish to learn the more advanced capabilities of Access.
|Improving the Structure of a Database|
|Using the Table Analyzer Wizard||00:00:00|
|Append Querying to Normalize a Table||00:00:00|
|Creating a Junction Table||00:00:00|
|Maintaining a Database|
|Backing Up a Database||00:00:00|
|Using the Compact and Repair Database Tool||00:00:00|
|Using the Object Dependencies Tool||00:00:00|
|Using the Database Documenter Tool||00:00:00|
|Using the Performance Analyzer Tool||00:00:00|
|Working with Access Switchboards|
|Understanding the Access Switchboard||00:00:00|
|Using The Switchboard Manager||00:00:00|
|Modifying a Switchboard||00:00:00|
|Setting the Startup Options||00:00:00|
|Configuring Access for Multiple Users|
|Using the Database Splitter||00:00:00|
|Configuring Trusted Locations||00:00:00|
|Password Protecting a Database||00:00:00|
|Password Protecting Modules||00:00:00|
|Converting a Database to an ACCDE file||00:00:00|
|Automating Processes with VBA|
|Understanding VBA Basics||00:00:00|
|Exploring Variables and Control Flow Statements||00:00:00|
|Exporting a Table or Query with VBA||00:00:00|
|Converting a Macro to VBA||00:00:00|
|Using Table Events|
|Understanding Table Events||00:00:00|
|Using the Before Change Event Command||00:00:00|
|Using the After Change Event Command||00:00:00|
No Reviews found for this course.