Workshop 8: Access VBA, Design and Advanced Methods

Learn new secrets to creating awesome Microsoft Access databases and VBA coding not covered in any of my other courses!

Created by: Bruce Myron
Productivity Specialist

What Will I Learn?

• Create an "Add or Go" combo box that will Add a new record or Go to an existing Customer
• Learn how to use Excel Date functions not available inside Access by using VBA
• Learn a simple, yet flexible way to add the ability to have quantity discounts on inventory items
• Learn how to add default values to Parameter Queries, plus several additional handy tricks
• Learn how to tab through the fields in the pages of a tab control
• Learn how to create professional looking custom buttons to forms

Requirements

• Students should be familiar with Access and have taken the Introductory VBA course

Target audience

• Students who have learned the basics of Access and VBA and are looking for more advanced techniques