This course is designed to give proficiency in the Visual Basic Editor (VBE), Word objects, basic VBA programming, control structures, debugging tools, advanced VBA programming, and event handling.

Prerequisites: A strong knowledge in all Microsoft Office Applications, especially Word.

Course Content:

Getting Started with the Visual Basic Editor

·         Visual Basic for Applications

·         Properties and modules

·         The Code window

·         The Object Browser

Programming basics

·         Working with variables and functions

·         Scope of variables

·         Scope of procedures

Word Objects

·         Programming with Objects

·         The Documents collection

·         The Tables collection

Control Structures

·         Using Decision Structures

·         Using Loop Structures

Forms

·         Working with Forms

·         Using Events in Forms

Debugging and Error Handling

·         Errors

·         Debugging

·         Error-handling

Objectives

·         Use VBA and examine the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures.

·         Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope.

·         Work with VBA objects; create, open, save, and close documents by using a Document collection; create a table by using the Tables collection; and work with the Table object.

·         Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks.