Access - Advanced

In our Access training courses, students will learn how to take control of their data with software training at Learnit. Our courses will teach you basic to advanced features of Access.

Whether you are new to Access or an advanced user, our Access training courses will cover what you need to know as efficiently as possible. Learnit offers world-class training for several versions, including 2016, 2013, 2010, 2007 and earlier.

Learning Outcomes: 

• Advanced Form Design Techniques 
• Using Switchboards to Navigate Database Objects 
• Designing Macros to Automate Database Tasks 
• Introduction into Access Visual Basic for Complex Automation 
• Linking Tables to Ensure Database Security some text
• Customizing Database Options 

Advanced Form Design Techniques 

• Designing Complex Forms 
• Creating “Keystroke-less” field controls 
• Adding Buttons and Drop-Down Lists for Navigation 

Using Switchboards (Menus) to Navigate Database Objects 

• Create a Main Switchboard 
• Design a Reports Switchboard 

Designing Macros to Automate Database Tasks 

• Create Macros to Open and Close Database Objects 
• Using Message Boxes to Inform Users 
• Automate Parameter Queries with Macros 
• View Related Records in Another Form with Macros 
• Hiding/Un-Hiding Field Controls with Macros 
• Use Macros to Validate Data Entry 

Introduction into Access Visual Basic for Complex Automation 

• Use Visual Basic to Secure Forms with Passwords 
• Create User Input Boxes 
• Use Logic Programming to Interpret Conditions 

Module 6

Linking Tables to Ensure Database Security 

• Place Tables in a Separate Database 
• Manage Tables with the Linked Table Manager 

Customizing Database Options 

• Set Startup Options 
• Applying the Compact and Repair Tool