Course Outline

Programming Microsoft Access with VBA - Open Schedule

Overview

Who is this course for?

This course has been developed for advanced Microsoft Access database developers, who need to automate their database objection using Visual Basic for Applications (VBA).

 

How long is this course?

1 Day 

 

What do I need to know before attending?

Delegates should have attended the Microsoft Access Introduction and Advanced courses or have the equivalent skills and knowledge to that level. 

 

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

  • Enhance forms creating user friendliness
  • Understand timings of when events happen.
  • Understand basic VBA programming and be able to write functions and procedures.
  • Correct errors in your VBA code.
  • Create Error handling routines.

 

Price Band:

 Specialised

Content

Customising Access using VBA
Customising a Command Button.
Making a form read only by default.
Displaying a message to the user.
Creating a Combo Box to find records.
Filtering data.


Understanding Event Procedures
Performing actions as a user moves through a form.
Validating data.
Asking the user a question.


Programming in VBA
Understanding and using Constants.
Create a General Sub Procedure.
Create a General Function.
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.
Display your own message specific error.
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.
Navigate through your application.
Display custom menus and toolbars.


The Final Touches
Control how your application starts.
Customise the applications appearance.
Replace the Microsoft Access Splash screen.

call us on 01949 212121

www.vtl.co.uk
IIP