Microsoft Access: Visual Basic for Applications (VBA) in Access

Course Overview

Microsoft Access is the most powerful desktop database design product to date from the Microsoft Office professional suite. This course teaches experienced Access users about the greater advantages to be gained by combining the built-in features of Access with the programming abilities of Visual Basic for Applications (VBA).

The course is designed to give delegates a thorough overview of programming within the Access environment, enabling them to improve the functionality of their Access databases, whilst providing a useful introduction to programming, in particular the Visual Basic programming language.

Booking a Microsoft training course with CourseMonster couldn't be easier. Simply click on the date and location that suits you best, confirm your booking and we'll send you all the information that you need.

Related Courses

• Microsoft Access 2003: Visual Basic Applications (VBA)

Audience

Database developers and experienced users of Microsoft Access who wish to utilise the power of VBA. This course covers the basic programming structures such as subroutines and functions and no previous knowledge of programming is necessary.

This course is particularly beneficial for those with a sound knowledge of Access and who are familiar with other features available such as tables, queries, forms, reports, macros and relationships.

Skills Gained

By the end of the course the delegate will be able to:

• Plan and design robust systems
• Build multi user applications
• Design advanced queries, data entry forms and reports
• Build secure applications
• When to use VBA instead of macros

Prerequisites

Delegates should be fully familiar with Access and be able to create tables, queries, forms, reports, macros and relationships. These concepts are covered in the Microsoft Access Advanced course. Prior knowledge of programming is not necessary.

Course Outline

Review of Macros

What is Visual Basic for Applications?

Introduction to the programming environment

• Modules and Procedures
• Creating and Opening a Module
• Module Window Toolbar and Keys

Creating Functions and Procedures

• Function and Sub statements
• Event Procedures

Access Objects, Methods and Events

• Applying Methods to and Opening Objects
• Data Handling techniques
• Objects and collections
• Form and Field handling
• Referencing Objects Literal, Syntax, Collection and Intrinsic
• Defining Recordsets, Dynasets and Workspaces
• Form, Report and Control Object Events and Properties
• Application Initiated Events
• Order of Events
• Foreground and Background Processes

Variables

• What is a variable?
• Declaring Public, Private and Static Variables
• Dimensioning Variables
• Scope Statements
• Data Type Conversion Functions

Object Variables

• Data Access Object Model
• DBEngine and Workspace Objects including ODBCDirect
• Creating Database Object Variables including the OpenRecordset Method

Processing data using SQL commands

Testing and Debugging Applications

• Starting, Halting and Tracing Execution
• Resolving Compile and Run-time Errors
• Working with Breakpoints
• Using the Debug Window

Error Handling and Trapping

• On Error Statement and Err Object

Control Structures

• IF...Then...Else statements
• Select Case statements
• For...Next loop statements
• Do...Loop statements
• While...Wend statement
• With statement
• For Each statement

Declaring and Calling DLL Routines

Security

• Passwords
• Wizard
• Using MDE files

Replication overview