VBA school training courses in Chicago, IL (public, in-house or online)

In this class you will learn how to Work with objects, use Object Browser, identify collection objects, and use the Controls collection.

Manipulate data by declaring variables, combine data by using expressions, get user input, create Sub and Function procedures, and call one procedure from another.

Use decision structures and use loop structures.

Identify ActiveX Data Objects (ADO) architecture and collections, connect to a database, work with a Record-set, and create a ...

Full archival course description>>

In this class you’ll learn to simplify your work in Excel by automating many of the repetitive tasks that are part of spreadsheet development. You’ll apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks you learned in Excel Introduction and Excel Intermediate.
Our classes are all instructor-led, hands-on learning. Each student has their own computer and is given a student manual with practice files to take home. A free repeat, within six m...

Full archival course description>>

You Will Learn How To

Develop customized solutions using Visual Basic for Applications (VBA)
Apply the object models to program effectively in the Microsoft Office System
Take full advantage of extensive built-in VBA functionality
Exploit ActiveX controls to create functional and familiar user interfaces
Troubleshoot code using VBA’s debugging tools
Secure your code and protect your users from macro viruses

Course Benefits

Effective business solutions do...

Full archival course description>>

This course will introduce students who are familiar with Word, Excel or Access the basics of writing and debugging VBA code. VBA is Microsoft’s Visual Basic for Application and is the tool used to create custom macros and user-interfaces in the Office applications. Students will learn to define variables, create loops and branching statements, define functions, get user input and interface with the application of their choice. Students will need a copy of Microsoft Word, Excel or Access. A...

Full archival course description>>

This advanced Access 2010 training class targets people who intend to design databases at an advanced level and/or improve existing Access databases.

Class Goals
•Learn to manage Access 2010 relational databases.
•Learn advanced form customization techniques.
•Learn to optimize and administer Microsoft Access 2010.
•Learn to manage relational databases.