Microsoft Access 2016 VBA

Who is this course for?

This course will enable the delegate to automate database tasks, add command buttons to forms, respond to data entry events, write functions and procedures, create a custom user interface, and display custom menus and toolbars. The course will provide knowledge of customising Access to an Advanced level and an introductory to intermediate level of VBA.

Content

Customising Access using VBA

Some practical uses for VBA in your applications, including:

Customising command buttons, making a form read only by default.

Displaying a message to the user, and using combo-boxes to find records.

Understanding Event Procedures

Performing actions as a user moves through a form

Validating data.

Asking the user a question.

Programming in VBA

Introducing some commonly used commands to give more power and flexibility to your code:

Understanding and using constants.

Toggling settings.

Managing user-input and displaying messages.

Declaring and using variables.

Use of conditional statements.

Responding to 'Events'.

Creating sub-procedures and functions.

Use General Functions on a form.

Monitor And Debug Your Code

Stepping through code line by line.

Monitoring variables and other values.

Finding and fixing bugs in your code.

Respond To Unexpected Errors

Replace standard error messages with your own message.

Respond to a Combo Box error.

Create error-handling routines.

Create a Custom Application

Gather information from a dialogue box.

Filtering data in a report.

Display custom toolbars.

Control how your application starts.

Customise the applications appearance.

Replace the Microsoft Access Splash screen.

Additional Topics

Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.