VBA programming in Access

Objectives: After completing this course an Attendee will be able to add Visual Basic coding to a Microsoft Access database.

Pre Requisites: An Understanding of Microsoft Access is essential.

Duration: 2 days

The topics covered are as follows:

1 VBA Development Environment
• When to use VBA
• Options
• Navigation

2 Creating Modules, Functions and Sub-routines
• New Modules
• Creating a Function or Procedure
• Passing Arguments and Returning values

3 Using Variables and Expressions
• Naming Conventions
• Declarations
• Assigning Values

4 Declaring Variables and Data Types
• Dimension Statement
• Data Types

5 Branching and Looping commands
• Indenting Code
• If … Then
• Select Case
• For … Next
• Do … Loop

6 Arguments
• Named and Optional

7 "Bugs"
• Types of Error
• Syntax or Logical
• Debug Window
• Breakpoints
• Using Message Boxes

8 Example Functions
• Text Functions
• Date Examples

9 Event Procedures on Forms
• Using the Builder
• Form Events and Properties
• Form Modules
• Validation Procedures

10 Writing Event Procedures
• Bespoke Functions
• Changing Controls

11 Trapping Errors
• On Error
• Error Codes

12 Manipulating Record Sets
• Opening Databases
• Recordset Objects
• Manipulating Data
• Finding Data
• Modifying Queries

microcomputing serves the Tyne & Wear, Northeast England region, with software training courses arranged for all types of companies in Sunderland, Washington, Gateshead and Newcastle as well as County Durham, Northumberland and the Teeside area with courses for organisations in Middlesbrough, Darlington and Stockton.