Programming Microsoft Access with VBA

(5.0)1 review
Recent reviews of this course provider

Very Good Course

Really good and thorough course. It moved at a good pace and covered many aspect...more

See all reviews
Add to shortlist


Course description

Programming Microsoft Access with VBA:


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).

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.


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.

Additional entry requirements

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

Training for employers

This course has been specifically designed for companies training their employees.

Course info
Start Date: Sat 01st June 2019
JUNE 2019
Sun Mon Tue Wed Thu Fri Sat
Sun Mon Tue Wed Thu Fri Sat


Altrincham, WA14 1TD, Nottingham, NG13 8PF


9:30am - 4:30pm


1 day


Full time


Certificate of Attendance


BeginnerIntermediate Advanced

From: £228

Other Visual Basic courses

Microsoft Access 2013 VBA

Vantage Training Ltd

Duration: Variable

Certificate of Attendance

Microsoft Excel 2013 VBA

Vantage Training Ltd

Duration: Variable

Certificate of Attendance

View 11 courses

Summary of all course reviews for Vantage Training Ltd

1 review


Average student ranking

Course reviews

This course currently has no reviews.

Write a review

Ask a question

Get course info
Next steps
Add to shortlist