Print PDF
Print Course Overview

Bookmark and Share

Microsoft: Visual Basic for Applications

Microsoft VBA Training CourseVisual Basic for Applications is a great way to expand your skills in the Microsoft Office packages. The Office packages can be enhanced using VBA code to project their use beyond the standard office commands. VBA provides the opportunity to allow unlimited functionality in any of your databases, documents or spreadsheets.  View Microsoft Visual Basic for Applications Subject Details

Stage 6: VBA Access: Programming in Code ITD03

Scheduled Training Courses

 07/06/2012  07/08/2012  07/09/2012  07/11/2012  07/12/2012

This Training course can also be run on request as a One to One or a Classroom Booking.

Overview

This course builds on the subjects discussed in the previous levels of:

  • Visual Basic Environment Introduction
  • Visual Basic Controls (Events, Properties, Text, Methods, Forms, Focus)
  • Visual Basic Definitions (General, Event, Function, Sub procedures and Modules)
  • Controlling Access Forms (Control Form Components, Forms Come To Life)
  • Using Variables (Text Handling / Property / Functions / Strings / Variants )
  • Conditions and Loops (If Statement / Loops )
  • Error Handling ( Message Boxes / Debugging )
  • Dialog Control Boxes Within Code ( Print Menu / Format / File Open / File Save )
  • Differences Between VB and Macros
  • External Application Links ( Linking To Word / Linking To Excel / Linking To Outlook )
  • Updating Data ( Edit, Sort & Filter Records In Code, ADO and DOA Controls )

Related Training Courses

Stage 4: VBA Word: Programming in Word ITD00
Stage 5: VBA Excel: Programming in Excel Part 1 ITD01
Stage 5: VBA Excel: Programming in Excel Part 2 ITD02
Stage 6: VBA Access: Programming in Code ITD03

Find Training Courses

Search The Pringle PCS Training Brochure View All Training Courses

Book This Training

CALL 0114 281 3350

Or email us

sales@pcs-limited.com

Single Booking £175.00

£105.00 40 % Discounted Price
Normal Price £175.00
* Discounts Apply When Booking More Than One Person On The Same Scheduled Course ex vat  
One delegate in a mixed group at Skywalker House

One To One

Price £395.00 ex vat  
One delegate one trainer either Skywalker House or at your premises
* Rates may vary for training at your premises if your premises are over 70 miles from Skywalker House

Company Classroom

Price £445.00 ex vat  
A dedicated trainer for your company either Skywalker House or at your premises
* Rates may vary for training at your premises if your premises are over 70 miles from Skywalker House