Home    |    Instructor-led Training    |    Online Training     
         
 
Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
VBA Solutions For Microsoft Office - Level 2
Visual Basic Training Overview

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.

Visual Basic Training Prerequisites

VBA Foundations for Microsoft Office - Level 1.

Visual Basic Training Audience

Programmers who will be developing in VBA6.

Visual Basic Training Course duration

2 Days

Visual Basic Training Course outline

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 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
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
  • Creating Your Own Collections
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
Giving Your Solutions to Others
  • Sharing the Wealth
  • Using Custom Toolbars
  • Office Templates and Add-Ins
  • Securing Your Code
  • Using Microsoft Office Developer 2000 to Deploy Solutions

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved
Copyright © SB