VBA school training courses in Durham, NC (public, in-house or online)

Student will learn to create and run macros, use the VB editor, learn the use of Interface Boxes, variables and Conditional Routines.


Outline :
Lesson 1: Introduction
Applications Interfaces
Options
Setup


Lesson 2: Programming Languages
OOP & The Excel Object Model
Macros vs. Programming


Lesson 3: Creating & Running Macros
Macros in Excel
Using Macros to Learn & Use Code
Using Macros to Learn Objects


Lesson 4: Visual ...

Full archival course description>>

Student will learn to create and run macros, use the VB editor, learn the use of Interface Boxes, variables and Conditional Routines.
Who should attend:

At completion:

Pre-requisite:

Outline:

Lesson 1: Introduction

Applications Interfaces
Options
Setup

Lesson 2: Programming Languages

OOP & The Excel Object Model
Macros vs. Programming

Lesson 3: Creating & Running Macros

Macros in Excel
Using Macros to Learn & U...

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.

1.Visual Basic Editor A.Visual Basic for Applications
B.Object programming
C.The Object Browser

2.Programming basics A.Data basics
B.Scope of variables
C.Scope of procedures

3.Control structures A.Decision structures
B.Loop structures

4.Custom dialog boxes A.User forms
B.Events

5.Debugging and error handling A.Errors
B.Debugging
C.Error handling