VBA Solutions for Microsoft Office XP Level 2 Courses and other IT courses from TEKsystems Education Services

Note: All fields are required

First Name:

Last Name:

Company:

Title:

Email Address:

Phone Number:

Address:

City:

State:

Zip Code:

Which Topic(s) Currently Interests Your Organization:

Tell Us More:

I have an immediate training or educational service need and I wish to be contacted today

I am a current TEKsystems Education Services client and wish to speak to someone

I have a training budget approved and I am ready to talk to someone about the details of my organization’s training need

I do not have an approved training budget, but I have a need and would like to talk to TEKsystems Education Services about their solutions

Unfortunately, I do not have a group training request

At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.

My Delivery Method Needed Is:

Instructor-Led Classroom Training

Instructor-Led Virtual Training

Self-Paced Online Training

Code Number:

We Value Your Privacy!

Course Code:	CS 32
Course Abstract:	Understanding how VBA works opens up a whole world of possibilities for making tasks with the computer easier. In VBA Solutions for Microsoft Office, participants will learn how to begin solving more complex work problems.
Audience:	This course is designed for anyone who completes repetitive tasks using Microsoft Excel, Microsoft Word, or Microsoft Access.
Duration:	2 days
Learning Outcomes:	Upon completion of this course, the participant will be able to: > Recognize the Object Browser and online Help–the tools you’ll need to figure out any product’s object model > Determine what objects the user is working with when your code runs > Apply the techniques you’ll need to create solutions that use the features of more than one product > Open a table in a database to read and change its records > Use different techniques to add data to an Excel workbook > Create charts from code using information in Excel or the result of a database query > Get information from Word documents to create new documents or PowerPoint presentations > Automatically send an Outlook e-mail message while you’re working in Excel or Access
Course Topics:	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 Using the Macro Recorder: PowerPoint 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 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 the Developer Edition to Deploy Solutions
Prerequisites:	You should fit the prerequisites for Level 1 and have attended our Level 1, VBA Foundations for Microsoft Office seminar.

VBA Solutions for Microsoft Office XP Level 2 Course

Hot Courses

Top Skills

Testimonials

Agile
AJAX and Web 2.0
Business Analysis
Business Practices
Cisco
Communications
Customer Service/Communications
Data Warehousing
Database Developer
End User
Enterprise Architecture
Internet Application Developer
Lotus
Mainframe
Messaging Infrastructure
Networking
Operating Systems
Programming Languages
Programming Methodologies
Project Management
Project Management
Quality Assurance
Relational Databases
Reporting Tools
SAP
Scrum Master
Security
Server Applications
SQL & PL/SQL Programming
Testing
Testing and Quality Assurance
Virtualization
Web Technologies
Wireless Technology