Microsoft Access Programming with VBA

Our classes are always live and instructor led from our Exton, PA or EPIC Partner locations. Springhouse AnywhereLive options require Internet Access. Select classes are Guaranteed to Run (GTR). View our complete schedule policies.





e5ff92b3-41f3-e811-a3ed-00155d0a14062019-08-07T08:00:00Z1050.00000000000039:00 AM4:00 PMExtone5ff92b3-41f3-e811-a3ed-00155d0a1406


Access Programming with VBA class teaches students how to examine and plan an application. Topics covered include automating forms, creating custom toolbars and menu bars, working with VBA code, and advanced VBA programming.

Intended Audience

At Completion

  • Identify components of and plan an application.
  • Automate the application interface, automate dialog boxes, use Visual Basic for Applications (VBA) code elements, and automate navigation across forms.
  • Create Switchboard forms and create and automate Splash Screen forms.
  • Create macro groups, custom toolbars, menu bars, shortcut menus, and set the startup properties for toolbars and menus.
  • Use different VBA programming elements, work with modules, and create procedures in modules.
  • Use control and loop structures in VBA code, handle events by automating controls on forms, trap and resolve errors in code, add Web browser controls to forms, and work with MDE files.


Before taking this course, students should have completed Access Level 1, Level 2 and Level 3 or possess equivalent knowledge

Exams & Certifications


Course Outline

Lesson 1: Designing an Application

Examining the components of an application; Identifying the objectives of an application; Resolving design issues in an application; Planning application objects


Lesson 2: Automating Forms

Examining the properties of a dialog box; Examining the properties of controls on a dialog box; Examining and creating a macro group; Attaching a macro group to command buttons; Discussing VBA; Examining the VBE window; Examining a command button code; Programming a button on a form to open another form; Disabling and enabling command buttons


Lesson 3: Working with Switchboard and Splash Screen Forms

Creating a Switchboard form by using the Switchboard Manager; Testing Switchboard objects; Modifying a Switchboard form; Observing a Splash Screen form; Creating a Splash Screen form; Setting label properties; Setting the properties of a Splash Screen form; Displaying the Splash Screen form on database startup; Displaying the Splash Screen form for a specified time; Opening a Switchboard form automatically after the Splash Screen form


Lesson 4: Creating Custom Toolbars and Menu Bars

Creating a macro group to show or hide a toolbar; Replacing the built-in toolbar with a custom toolbar; Adding buttons to a custom toolbar; Examining a custom menu bar; Creating a custom menu bar; Adding commands to a custom menu bar; Creating a custom shortcut menu; Setting startup properties for toolbars, menus, and Access Special Keys


Lesson 5: Working with VBA Code

Discussing data types; Using variables and constants; Examining the Code window; Examining a VBA code; Creating a Sub procedure in a standard module; Calling a Sub procedure; Creating a Function procedure in a standard module; Calling a Function procedure


Lesson 6: Working with Advanced VBA Programming

Using the If…Then statement; Using the If…Then…Else statement; Using the If…Then…ElseIf statement; Using the For…Next loop; Using the Do While…loop; Assigning event handling code to a text box; Assigning event handling code to a combo box; Assigning event handling code to coordinate events across two forms; Assigning the Undo event procedure for a form; Assigning the Unload event procedure to a form; Adding error-handling code; Testing an error-handling code; Adding a Web browser control to a form; Displaying a Web site on the form; Creating an MDE file



Microsoft Access Programming with VBA Access Programming with VBA

Get More Information




Help us prove you're not a robot:

 ‭(Hidden)‬ Catalog-Item Reuse

Microsoft Gold Partner


AXELOS Limited

The Microsoft Gold CPLS logo is a mark of Microsoft, Inc.

The PMI R.E.P. logo is a mark of the Project Management Institute, Inc.

ITIL® is a registered trade mark of AXELOS Limited.
IT Infrastructure Library® is a registered trade mark of AXELOS Limited
The Swirl logo™ is a registered trade mark of AXELOS Limited
Accredited course material is property of ITSM Academy.

Connect with us

Springhouse Education & Consulting Services

Corporate HQ:Eagleview Corporate Park
707 Eagleview Boulevard
Suite 207
Exton, PA 19341

610-321-3500 -