Microsoft Access

Introduction

Intermediate Level 1

Intermediate Level 2

Queries

Advanced

VBA Level 1

VBA Level 2

Version 2007 Upgrade

 

Register Now

 

View Course Outline PDF

(all Access Courses show in one PDF file)
 

 

Pay $ 345. to $ 645. for this course using TICKETS instead (Minimum Purchase of 11 Tickets).…Click here for More Information.

 

Course Dates (9am to 4pm)

 

Versions

North York

 

   

Version 2003

Apr 9/10/11

Aug 25/26/27

 

 

 

 

 

Course Prerequisites

 

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

 

Course Description

This course looks at using Access Visual Basic for Applications. Topics include: form, report and database modules, events, writing procedures, and using memory variables. 

Detailed List of Topics

 

Overview

Macros vs. Code

Module Types

Understanding Events

 

Code Employee Form

Close Button with Wizard

Close Button without Wizard

Deleting a Procedure

Adding Comments

Setting Values in Fields

Basic If Statements

Displaying a MsgBox

More about If Statements

Change Events

Cancel an Event

About Control & Object Names

Control Level Security

Add Note Command Button

Format() Function

IsNull()

Procedure Level Variables

SendKeys

Module Window Screen

 

Code Customer Form

Select Case

Showing/Hiding Controls

Setting Control Properties

Setting Values of Controls

Calling Procedures

Creating General Procedures

Creating Database Modules

Passing Parameters

Setting Input Masks

Find Combo Box

Email Command Button

Delete Records

MsgBox() Function

 

Code Orders Form

Moving Through Records

Opening Other Forms

Requery Controls

Referencing Forms

Is a Form Open?

Variable Types

ElseIf

Error Handling

Dlookup(), DCount() Functions

Case vs. If

Input Box

Debug/Immediate Window

Null vs. ""

Creating Labels

 

 

 

  

Computer Training Courses, SoftSkills Seminars & Access Database Development

Computer Help is a division of MPM Skills Development Inc.
Toronto, Ontario, Canada.

Phone: 416.494.4912, Fax: 416.494.9952

www.Computer-Help.ca

Question or Comment - Email Us