Welcome to Insight

Delivering private IT training for businesses,
public sector and voluntary organisations

We deliver our training
Onsite & Offsite

We Provide
A Wide Range
of Business Skills courses

We Can Help You
Build Your Own
Tailored Courses

The Training You Want
When & Where
You Want It

Keep an Eye on
Our Special Offers
Updated Regularly

Welcome to Insight

Delivering private IT training from businesses,
public sector and voluntary organisations

Microsoft Access VBA 1 Day

< Back to Microsoft and Office Courses | Insight IT Training

Course Details

vba

Course Duration – One day

Benefits of Microsoft Access VBA 1 Day Course

This Microsoft Access VBA course has been designed to give experienced Access users the skills they need to understand the basics of VBA Programming. The course is 100% hands-on, with exercises to practice the skills as you learn them.

Visual Basic is, by far, the most widely used programming language in the world. VBA is no different from regular Visual Basic, but it can only be used to add features to Microsoft Office applications rather than to write free-standing applications. During the VBA course you will learn how to design an application, automate forms, create custom navigation and work with switchboards. You will also acquire the knowledge of working with VBA code and advanced VBA programming.

Our trainers are fully conversant with the Microsoft Office product suite and have many years of practical experience.

Trainees should have attended the Advanced Microsoft Access course or have a good working knowledge of table creation, basic query and report writing functions and relational database concepts. No programming experience is needed..

Course Content

Designing an application

  • Examining an application
  • Planning an application

Automating forms

  • Working with dialog boxes
  • Working with macro groups
  • Automating navigation across forms

Working with Switchboard and Splash Screen forms

  • Working with Switchboard forms
  • Working with Splash Screen forms
  • Automating Splash Screen forms

Creating custom naviagtion (ribbons & tabs)

  • Working with ribbons
  • Creating custom and shortcut menus

Working with VBA code

  • Discussing VBA programming elements
  • Working with modules
  • Creating procedures

Advanced VBA programming

  • Using control structures
  • Handling events
  • Resolving errors
  • Displaying a Web site
  • Working with MDE files
 

Prerequisites

Trainees should have attended the advanced Access course or have a good working knowledge of table creation, basic query and report writing functions and relational database concepts. No programming experience is needed.

Contact Us

Interested in our service? Then get in touch today with Insight IT to see how we can tailor your training to suit your needs.

Call us on: 08452 306 099 or contact us online here.