Developing Professional MS Office Solutions with VBA

Developing Professional MS Office Solutions with VBA

Three days hands-on course

Language: English

Get your information from an independent source

DESCRIPTION
This comprehensive 5-day training will give you full control over Microsoft Access, Excel, Word, PowerPoint and Outlook, using Visual Basic for Applications.
Students learn application development in "hands-on" sessions: programming real life examples for recognizable situations.
The course emphasizes data movements and Inter-Office Programming: use any Office application to develop a multi-application solution.
You will program for Office 2000, knowing all differences with Office 97. New Office XP capabilities will be demonstrated.
The course will leave you with reusable code for standard situations, and code that can be easily modified to your needs.
You will be introduced to all the best web sites on VBA, offering you tons of free code, discussion platforms and sample programs.

WHO SHOULD ATTEND
Anyone wanting to save time by developing an automated Office solution.
Anyone wanting to support or develop Intranet or Internet solutions with MS Office contents.
This course will satisfy any self-made programmer wanting to acquire good programming practices and adding in-depth knowledge fast.

ASSUMED KNOWLEDGE
You do not need programming experience, but you should be an experienced MS Office user.

WHAT YOU WILL LEARN
Get to know the distinct object models of the different Office applications, and automate every day tasks like creating Excel PivotTables and Charts, generating Word reports and letters and sending Outlook e-mails based on your Access data.
You will learn to use the features of Visual Basic for Applications, which serves as a shared language for automating tasks in the various Office applications.
Get intensive training on Inter-Office programming: using one Office application to control others, with special focus on import and export of data throughout the Office package.
A Web workshop will get you up and going to publish and download Office documents and data on the internet and to develop automated web-based solutions.

OUTLINES

EXPLORING VISUAL BASIC FOR APPLICATIONS

An introduction to VBA
The programming environment: The VBE Editor, windows, menu items, code panes.
The programming model: Object Oriented Programming & Event Driven Programming, run-time & design-time, the basics of programming in VBA
Referencing libraries
Good Programming Practices and Naming Conventions

HANDS-ON VBA

Writing procedures
Using variables and constants
Writing Loop Structures and Conditional Code
Using built-in functions
Error-Handling and Debugging

DEVELOPING MS ACCESS SOLUTIONS

Overview of the Access object model
Automating everyday tasks in Access forms
Automating everyday tasks in Access reports
Using DAO and ADO to work with Access tables and queries
Working with ASCII files

INTER-OFFICE PROGRAMMING WORKSHOP: CONTROL ACCESS

Learn to handle data flows in Access, using DAO and ADO.
Write procedures for sorting, filtering, adding, deleting and modifying data, including import from ASCII files.

DEVELOPING EXCEL SOLUTIONS

Overview of the Excel object model
Using the macro recorder to generate VBA code & adapting the code to suit variable size data lists.
Add menus and toolbars that trigger your procedures
Import data from Access
Working with workbooks and worksheets
Working with ranges and cells
Working with functions
Perform typical Excel tasks: advanced filters, PivotTables and charts
Automate Printing

INTER-OFFICE PROGRAMMING WORKSHOP: CONTROL EXCEL

From within an Access database, we will create and save a new Excel document, export our Access data to it and generate Excel PivotTables and charts for the data.

DEVELOPING WORD SOLUTIONS

Overview of the Word object model
Using the macro recorder to generate VBA code & adapting the code
Add menus and toolbars that trigger your procedures
Add, delete and save documents. Insert paragraphs and sections.
Move through a document and search & replace text
Add tables
Insert objects
Apply formatting

INTER-OFFICE PROGRAMMING WORKSHOP: CONTROL WORD

From within an Access database, we will create and save a Word document, add the Excel PivotTable and Charts to it. The document will be turned into a neat business report, with nicely formatted sections and a table of contents.

DEVELOPING POWERPOINT SOLUTIONS

Basics of the PowerPoint object model
Adding a presentation and adding, modifying and deleting slides to a presentation
Titles, subtitles, bulleted text and graphics
Applying a design template
Creating a ready-to-use slide show based on a Word report

INTER-OFFICE PROGRAMMING WORKSHOP: CONTROL POWERPOINT

From within an Access database, we will get PowerPoint to produce a slide show presentation of our Word report. The presentation will be formatted using a suitable template.

DEVELOPING OUTLOOK SOLUTIONS

Overview of the Outlook object model
Add menus and toolbars that trigger your procedures
Copying email from mail folders to an Access table
Generating a new e-mail and setting subject, body, To, BC, BCC
Adding attachments to a mail
Introduction to working with Outlook forms

INTER-OFFICE PROGRAMMING WORKSHOP: CONTROL OUTLOOK

From within an Access database, we will get Outlook to perform a batch mail task, sending out e-mails containing the Excel, Word and PowerPoint documents we generated.

MAKE OFFICE SOLUTIONS TRUE WEB SOLUTIONS

Using Data Acces Pages (DAP) in Access
Opening a browser from an Office application
VB Script: a baby version of VBA
The Internet Explorer Object model
Strategies and conditions for Web Publishing

FDDI Institute
De Regenboog 11 - 2800 Mechelen - Europe
Tel 32 15 24 50 58 - Fax 32 15 25 10 50