Home > Courses Certifications > Programming > VBA

VBA (Visual Basic for Applications) Courses and Training

Customise Microsoft Excel and Access to suit your needs!

WHAT IS THE AIM OF THE COURSE?

Until very recently, customers who wanted to customize a software application were required to learn a set of application-specific skills or hire an expert, often at prohibitive cost.

Upon successful completion of this course you will be able to:

Macros : recording macros; assigning macros to toolbar buttons, menus and objects; understanding the limitations of recorded macros; editing recorded macros.
Visual Basic for Applications : introducing the VBA Editor window; creating procedures; basic principles - syntax, commenting, naming conventions; getting help
VBA Fundamentals : using Objects, Properties and Methods; manipulating ranges and cells; using variables; calling procedures; using the With Statement; creating Looping Statement; assigning procedures to workbook events
Debug code and error trap : step through code; interrupt/break code; including simple error trapping code
Dialog Boxes/User Forms : creating message boxes; creating user forms; using the control toolbox

WHO SHOULD ATTEND?

This course is aimed at delegates who have an extensive knowledge of Excel and Access and who need to automate repetitive or complex tasks within a spreadsheet or wanting to create database application.

HOW CAN I RECEIVE THE TRAINING?

You can come to us for Instructor Led Training,
You could even do it Part Time with MyChoice!
We can come to you for Onsite Training
Day or evening training provided

EXAMINATIONS AND ASSESSMENTS

In support of your learning, New Horizons provides reinforcement tools to increase retention of the course material and move you further along your learning lifecycle. From hands-on practice to study aides and resources, we supply you with the tools necessary to enhance your New Horizons Integrated Learning experience.

Learners may elect to write the International Microsoft and CompTIA examinations at New Horizons' Authorised Prometric Testing Centre. The costs for International exams are not included in the course fees.

LEARNING MATERIALS

All standard learning manuals are included in the course fee!

WHAT DOES THE COURSE CONSIST OF?

Beginning Access 2003 VBA

Introduction to Access 2003 VBA.
The Basics of Writing and Testing VBA Code.
Programming Applications Using Objects.
Creating Your Own Objects.
Interacting with Data Using ADO and SQL.
Building Interactive Forms.
Importing, Linking, and Exporting Using External Data Sources.
CCreating Reports and Web-Enabled Output.
Building SQL Server Applications with Access Projects.
Advanced Access Programming.
Finishing the Application.
Case Study 1: Project Tracker Application.
Case Study 2: Customer Service Application.
Appendix A: Exercise Answers.

VBA Excel 2003

What's New in Excel 2003
Exploring Excel
Exploring Visual Basic for Applications
VBA Programming Starter Kit
Creating Sub and Function Procedures
The Application Object
Workbooks and Worksheets
Ranges and Cells
Manipulating Data with VBA
Formatting Excel Objects
Creating Add0Ins and COM Add-Ins
Understanding and Using Events
Manipulating Files
Developing Class Modules
Manipulating Excel Objects
PivotTables and PivotCharts
Command Bars
Customizing Dialog Boxes
Creating User Forms
Creating Advanced User Forms
Excel and Other Office Applications
Excel and Other Structured Query Language
Introducing ADO
Excel Query Program
Excel and the Web
Excel and the Extensible Markup Language(XML)

View the full VBA Excel 2003 course outlines!

Access 2007 VBA

Introduction to Microsoft Access 2007
Access, VBA, and Macros
New Features in Access 2007
Using the VBA Editor
VBA Basics
Using DAO to Access Data
Using ADO to Access Data
Executing VBA
VBA Error Handling
Using VBA to Enhance Forms
Enhancing Reports with VBA
Customizing the Ribbon
Creating Classes in VBA
Extending VBA with APIs
SQL and VBA
Working with Office Applications
Working with SharePoint
Database Security
Understanding Client-Server Development with VBA
Working with the Win32 Registry
Using the ADE Tools
Protecting Yourself with Access 2007 Security

View the full Access 2007 VBA course outlines!

Excel 2010 Power Programming with VBA

Excel 2010: Where It Came From
Excel in a Nutshell
Formula Tricks and Techniques
Understanding Excel Files
What is a Spreadsheet Application
Essentials of Spreadsheet Application Development
Introducing Visual Basic for Applications
VBA Programming Fundamentals
Working with VBA Sub Procedures
Creating Function Procedures
VBA Programming Examples and Techniques Part IV: Working with UserForms
Custom Dialog Box Alternatives
Introducing UserForms
UserForm Examples
Advanced UserForm Techniques
Developing Excel Utilities with VBA
Working with Pivot Tables
Working with Charts
Understanding Excel's Events
Interacting with Other Applications
Creating and Using Add-Ins
Working with the Ribbon
Working with Shortcut Menus
Providing Help for Your Applications
Developing User-Oriented Applications
Compatibility Issues
Manipulating Files with VBA
Manipulating Visual Basic Components
Understanding Class Modules
Working with Colors
Frequently Asked Questions about Excel Programming
Appendix A: Excel Resources Online
Appendix B: VBA Statements and Functions Reference
Appendix C: VBA Error Codes. Appendix D: What's on the CD-ROM. Index. End-User License Agreement