Course Outline

Microsoft Access 2016 VBA

Overview

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.

 

How long is this course?

1 Day 

 

What do I need to know before attending?

It is assumed that you have a strong working knowledge of Access. 

 

What will I expect to achieve at the end of the training?
At the end of this course
you will be able to:

  • Create user friendly forms
  • Understand event timing
  • Understand basic VBA programming and write functions and procedures.
  • Correct errors in your VBA code.
  • Create Error handling routines.

 

Price Band:

 Specialised

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.

call us on 01949 212121

www.vtl.co.uk
IIP