Computer Help Training: Access Courses - Toronto - North York - Mississauga

Access
VBA Level 1

3 Days (9am to 4pm)
$ 825. or 3 Tickets

Other Access Course Levels

Introduction
Intermediate Level 1
Intermediate Level 2
Queries
Advanced
VBA Level 1
VBA Level 2
Version 2007/2010 Upgrade

Register Now

Contact Us

View PDF Course Outlines for All Access Courses

Locations

Toronto
20 Queen Street West, Suite 3306
(Toronto Eaton Centre)

North York
2 Lansing Square, Suite 505
(Hwy 401 & Hwy 404/DVP)

Mississauga
1087 Meyerside Drive, Unit 10
(Dixie Rd. & Hwy. 401)

Newmarket
16635 Yonge Street, Unit 19
(Yonge St. & Mulock Dr.)

As powerful and customizable as Access can be, there are times when you need to customize it even further. Visual Basic for Applications is a built-in programming language that lets you change the way all parts of Office work. This course focuses on the core concepts of Visual Basic programming, in the context of using them specifically with Access.

Course Prerequisite: Required: Solid understanding of all Access Introduction & Intermediate Level I topics. Recommended: Understanding of Queries course topics and Advanced topics.

Overview

Macros vs. Code

Module Types

Understanding Events

Events

Click

BeforeUpdate

AfterUpdate

NotInList

Close Events

Open Events

Delete Events

Cancel Events

Form Current

Procedures & Modules

Understanding Wizard Code

Module Window

Deleting Procedures

Comments

About Control & Object Names

Procedure Level Variables

Creating General Procedures

Creating Database Modules

Debug/Immediate Window

Intrinsic Constants

Commands

Closing Objects

Setting Values in Controls (text, numbers, formulas)

If, Else, ElseIf, Endif

Select Case

Displaying a MsgBox

SendKeys

Delete Records

Showing/Hiding Controls

Setting Control Properties

Calling Procedures

Passing Parameters

Setting Input Masks

Find Combo Box

Email Command Button

Moving Through Records

Requery Controls

Referencing Forms

Is a Form Open?

Error Handling

Case vs. If

Null vs. ""

Creating Labels

Functions

MsgBox()

CurrentUser()

Format()

IsNull()

Dlookup()

Dmax()

DCount()

InputBox()

Versions	North York
2007/2010	Mar 14/15/16