Visual Basic for Application

Session	Subject	Syllabus
1	About this course	Welcome Introduction and objectives Getting help with the course How the course is structured About the model database About the exercises About Course Project Summary
2	Getting Started with VBA	What Is VBA? What Products Host VBA? What Does a VBA Application Look Like? Working with VBA in a Host Product How Do You Make VBA Code Happen? Starting with VBA by Recording Macros
3	Writing VBA Procedures	Overview of the Visual Basic Editor Working with the Project Explorer Creating Simple Procedures Understanding the Code Window Customizing the Visual Basic Editor
4	Working with Variables and Constants	What Is a Variable? Data Types Using Constants
5	Visual Basic Editor Techniques	Writing Code Efficiently Taking Advantage of IntelliSense Optional and Named Arguments
6	Mastering VBA Control Structures	Branching Structures Looping Structures
7	Investigating Built-In VBA Functions	VBA’s Built-In Functions Using the Object Browser to Find VBA Functions Testing Functions in the Immediate Window VBA Functions You’ll Probably Need
8	Creating Reusable Procedures	Design Before Code Writing the Same Code Once
9	Creating User Forms	Working with User Forms Adding Controls to a User Form Formatting Controls Setting Properties at Design Time Introducing Events Setting Properties at Run Time Working with Methods
10	Handling Errors	Recognizing a Run-Time Error The Error-Handling Standard Exiting the Error Handler Inline Error Handling Combining Types of Error Handling
11	Debugging Your VBA Code	Debugging Your Code Setting a Breakpoint Stepping Through Code Checking Values at Run Time Watch Expressions The Call Stack The Debugging Process
12	Understanding Object Models	Defining the Terms Using the Object Browser Working with Object Models in VBA Object Variables Special VBA Control Structures for Objects Working with the Office Object Models
13	Understanding Events	Events and Event Procedures Which Objects Have Events? User Form Events Control Events Product-Specific Events Is There More?
14	Putting It All Together	Assembling the Pieces Building a Solution in Excel Using the Solution in Word Where Are You Going From Here?
15	Module Summary	Final Examination Project Evaluation Your quiz score Good luck

Session	Subject	Syllabus
1	About this course	Welcome Introduction and objectives Getting help with the course How the course is structured About the model database About the exercises About Course Project Summary
2	Exploring the Object Models of the Office Products	Figuring Out Object Models Working with the Object Browser: Access Knowing the Interactive Product: Word Mining the Help File: Excel
3	Working with Active Objects	Active Properties in Office Excel’s Active and Selection Properties Word’s Active and Selection Properties The Access Screen Object
4	Using Another Product's Features with Automation	Expanding Your Horizons Using Automation Getting to the Object Model Working with Data Using Automation
5	Advanced User Form Techniques	Restricting User Entry Using List Boxes and Combo Boxes Creating a Tabbed Dialog Box Additional ActiveX Controls
6	Techniques with VBA Variables	Scope, Lifetime, and Precedence Passing by Value and by Reference Optional Arguments Creating Your Own Collections
7	Adding Data to Excel, Access, and Outlook	Using VBA to Work with Data Adding Values to an Excel Worksheet Adding ADO Data to Excel Adding a Database Record with ADO Adding an Item to Outlook
8	Charting Your Data	Excel’s Chart Object Creating a Chart Creating an Excel Chart from Access
9	Adding Content to Word and PowerPoint	Adding Text to a Word Document Adding Content to PowerPoint
10	Giving Your Solutions to Others	Sharing the Wealth Using Custom Toolbars Office Templates and Add-Ins Securing Your Code Using Microsoft Office 2003 Developer to Deploy Solutions
11	Module Summary	Final Examination Project Evaluation Your quiz score Good luck