CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

ATVBA62 - VBA Solutions for Microsoft Office - Level 2

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

ITCourseware's VBA for Microsoft Office courseware will teach you to start thinking in terms of how you can make your work life simpler. This courseware gets you going in VBA by showing you the tools to start automating little tasks right away.

Click here for a printer-friendly version of this page

Prerequisites

Detailed Class Syllabus

Prerequisites:
VBA Foundations for Microsoft Office - Level 1.

Exploring the Object Models of the Office Products

Figuring Out Object Models

Working with the Object Browser: Microsoft Access

Knowing the Interactive Product: Microsoft Word

Mining the Help File: Microsoft Excel

Working with Active Objects

Active Properties in Office

Excel's Active and Selection Properties

Word's Active and Selection Properties

The Access Screen Object

Using Another Product's Features with Automation

Expanding Your Horizons Using Automation

Getting to the Object Model

Working with an Existing Instance

Working with Data Using ADO

Introducing ActiveX Data Objects

Working with Data in Recordsets

Moving Through a Recordset

Creating a Recordset Based on a SQL String

Adding a Recordset to a Worksheet

How and When to Use DAO

Advanced User Form Techniques

Restricting User Entry

Using List Boxes and Combo Boxes

Creating a Tabbed Dialog Box

Additional ActiveX Controls

Techniques with VBA Variables

Scope, Lifetime, and Precedence

Passing by Value and by Reference

Optional Arguments

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

Working With the ADO Command Object

Adding an Item to Outlook

Adding Content to Word and PowerPoint

Adding Text to a Word Document

Adding Content to PowerPoint

Charting Your Data

Excel's Chart Object

Creating a Chart

Creating an Excel Chart from Access

Pasting excel Charts into Other Documents

Giving Your Solutions to Others

Sharing the Wealth

Using Custom Toolbars

Office Templates and Add-Ins

Securing Your Code

Using Microsoft Office Developer to Deploy Solutions