Microsoft VBA 2010 Training

Microsoft VBA software training courses available from CTO:

Microsoft VBA for Access - Introduction

Learning Outcomes:

At the completion of this courseware participants will be able to:

• Understand some of the aspects of developing applications in Access
• Use macros in Access
• Understand the programming environment and how forms and modules are used
• Create and work with subroutines and function procedures
• Create and work with variables
• Communicate with the user through input boxes and message boxes
• Program decision structures using IF and CASE statements
• Develop a variety of programming loops for repeating operations
• Use the DoCmd object to perform most of the operations associated with a database
• Use DAO to handle working with data in your programs
• Use ADO to handle working with data in your programs
• Use the debugging features of VBA to locate and identify errors
• Develop safeguards in your program and prevent unforeseen errors.

Duration: 2 Days

Microsoft VBA for Access - Download course outline in PDF format

Microsoft VBA for Excel - Introduction

Learning Outcomes:

At the completion of this courseware participants will be able to:

• Create recorded macros in Excel
• Use the macro recorder to create a variety of macros
• Understand the Excel object model and VBA concepts
• Work with the three main components of the VBA Editor window
• Create command procedures
• Create and use variables
• Create and work with user-defined functions
• Write code to manipulate Excel objects
• Use a range of common programming techniques
• Create a custom form complete with controls and event procedures
• Create code to drive a user form
• Create procedures that start automatically
• Write a variety of error handling routines

Duration: 2 Days

Microsoft VBA for Excel - Download course outline in PDF format

Microsoft VBA for Word - Introduction

Learning Outcomes:

At the completion of this courseware participants will be able to:

• Understand the Word object model and VBA concepts
• Work with the three main components of the VBA Editor window
• Create command procedures
• Create and use variables
• Create and work with functions
• Use decision structures to control the outcomes of your program
• Use looping structures to repeat sections of code
• Work with text using a range of objects
• Customise the ways in which files and folders are managed
• Create a custom form complete with controls and event procedures
• Create code to drive a user form
• Write a variety of error handling
• Use Word's built-in dialog boxes

Duration: 2 Days

Microsoft VBA for Word - Download course outline in PDF format

Courseware:

High quality learning materials are available for purchase by participants. Participants will also be presented with a certificate of achievement upon completion of the course.