Programming in VBA
using Access  

an eWord company

 

Microsoft Office courses are conducted using 2003, however these courses are suitable for users of versions 2000 and XP/2002.

 

 

General Course Information

This 3 day program aims to increase your productivity by providing the skills and knowledge to program VBA in Access effectively.

 

You will learn to

Ø       Understand some of the aspects of developing applications in Access

Ø       Create and assign macros and understand the advantages and disadvantages of using macros

Ø       Understand the programming environment and how forms and modules are used in it

Ø       Create and work with subroutines and function procedures

Ø       Create and work with variables

Ø       Communicate with the user through input boxes and message boxes

Ø       Program decision structures using IF and CASE statements

Ø       Develop a variety of programming loops for repeating operations

Ø       Use the DoCmd object to perform most of the operations associated with a database

Ø       Use DAO to handle working with data in your programs

Ø       Use ADO to handle working with data in your programs

Ø       Use the debugging features of VBA to locate and identify errors

Ø       Develop safeguards in your program and prevent unforeseen errors

 

What skills you need

Participants need to be proficient users of Microsoft Access and should have extensive experience in formatting, reports, queries and relational databases.

 

Electus training

Electus is a South Australian company with 20 years of experience in training.  Trainers and facilitators at Electus are chosen for their expertise, practical and broad experience in their field and a relaxed and friendly manner.

 

Training includes

Each participant receives a training reference manual/workbook and supplementary training materials. 

Refreshments and lunch are provided.

 

Duration

3 days

9:00am-4:30pm

 

 

Who needs to come

This course is designed for proficient Access users who wish to learn how to develop

programs in VBA.

 

 

Regular venue

37 Angas Street

Adelaide SA

(near Victoria Square)

 

 

How to book

Contact Electus by
phone: (08) 8221 5517
fax: (08) 8221 5518
email: mail@electus.com.au

 

 

Course dates

Visit www.electus.com.au for the latest course schedule or ring us on (08) 8221 5517.

 

 

 

Electus–training SA’s primary resource…it’s people                                                                        37 Angas Street, Adelaide SA 5000

                                                                                                                                                                                       Telephone: 08 8221 5517

                                                                                                                                                                                         Facsimile: 08 8221 5518

                                                                                                                                                                               Email: mail@electus.com.au

 

Programming in VBA using Access

 

 

 

Course Content

Development Basics

·         The Access Development Environment

·         The Importance of Splitting Databases

·         Maintaining Links

·         Using The Database Splitter

·         Using Queries for Reports and Forms

·         Access Run-Time

·         Understanding Client/Server

Macros And VBA

·         Creating Macros

·         Assigning Macros

·         Creating More Complex Macros

·         Converting Macros to VBA Code

·         Why you shouldn't use Macros

VBA Essentials

·         Creating a Startup Form

·         Understanding Modules

·         Code Behind Forms

·         Standard Code Modules

·         Standard Vs Class Modules

·         Naming Conventions

VBA Subroutines

·         Understanding Modules

·         The Anatomy of a Module

·         Creating a Subroutine

·         Creating a Function

·         Calling Procedures

·         Passing Parameters

·         Returning Values

·         Scoping Procedures

Variable VBA

·         Creating String Variables

·         Option Explicit

·         Working With Numbers

·         Dealing With Overflows

·         Working With Decimals

·         Working With Dates

·         Default Values

·         Scoping Variables

·         Local Variables

·         Module-Wide Variables

·         Passing Parameters

·         Passing Parameters By Value

Interactive VBA

·         The Act o Communicating

·         Creating a Simple Input Box

·         Creating More Elaborate Input Boxes

·         Global Positioning

·         Simple Message Boxes

·         Creating Larger Messages

·         Breaking a Message Line

·         Customising Icons and Buttons

·         Message Box Functions

·         Responding to Different Buttons

Decisive VBA

·         Decisions Overview

·         Creating an In-Line If

·         Creating a Block If

·         Multiple If

·         Multiple If Using Text

·         Using Case Statements

·         Value Ranges in Case Statements

·         Case Statements with OR

·         Asking Yes/No Questions

Looping VBA

·         Program Loops

·         Creating a While Loop

·         Taking Care of Counters

·         Creating an Until Loop

·         For Each Loops

·         Exiting From Loops

·         For Next Loops

The DoCmd Object

·         Navigating with DoCmd

·         Moving Through Records

·         Filtering Records with DoCmd

·         Opening a Form with DoCmd

·         Opening a Report with DoCmd

·         Closing a Form

·         Creating Variable Reports

 

ActiveX Data Objects - Tables

·         Setting References using VBA

·         Creating a Table with ADO

·         Removing a Table using ADO

·         Populating a Form using ADO

·         Dealing with an Empty Table

ADO Forms & Recordsets

·         Navigating Records in a Form

·         Finding a Record

·         Updating a Record

·         Deleting a Record

·         Adding a New Record

Debugging VBA

·         Setting a BreakPoint

·         Setting Additional Breakpoints

·         Stepping Through a Procedure

·         Viewing the Call Stack

·         Using the Locals and Immediate Windows

·         Adding a Watch

·         Deleting a Watch

Handling Errors In VBA

·         Error Handling Overview

·         Understanding Common Errors

·         Creating a Simple Error Handler

·         Understanding the Error Object Model

·         More Elegant Error Handling

·         Resuming from Errors

·         Forcing an Error

·         Creating Custom Errors

 

 

 

Electus–training SA’s primary resource…it’s people                                                                        37 Angas Street, Adelaide SA 5000

                                                                                                                                                                                       Telephone: 08 8221 5517

                                                                                                                                                                                         Facsimile: 08 8221 5518

                                                                                                                                                                               Email: mail@electus.com.au