Microsoft Access VBA Training Courses
Short course
In Twickenham
Description
-
Type
Short course
-
Location
Twickenham
-
Start date
Different dates available
Microsoft Access is a Database Management System (DBMS) that you can use to store, query and report on your data.
Using Access ‘out of the box’ can be a powerful tool but to make the most of your investment you will no doubt benefit from making use of Visual Basic for Applications (VBA), a programming language which can be used to build your own applications.
Within this Integrated Development Environment (VBA is part of the Microsoft Office suite so no additional software is required) you create ‘macros’ which are step-by-step procedures written in Visual Basic. These procedures can then be run, triggered, by actions through the forms and reports events.
No previous programming experience is required. Our course will introduce you to coding by example and will demonstrate how to use VBA to interact with Access so you can automate...
Facilities
Location
Start date
Start date
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 14 years
Subjects
- Access
- Programming
- Visual Basic training
- Microsoft Access
- Visual Basic
- Code Editor
- Navigating
- Data Types
- Variable Scope
- Controlling Program Execution
- Recordsets
- Debugging Code
- Handling Errors
- Trapping Errors <br /> <br /> <br /> <br />
Course programme
Getting Started
Introduction to Programming in Access
Why Program in Access?
Understanding the Development Environment
Using Visual Basic Help
Working with Procedures and Functions
Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures
Creating a Function Procedure
Naming Procedures
Organising Code and Procedures
Working with the Code Editor
Understanding Objects
Understanding Classes and Objects
Navigating the Access Object Hierarchy
Understanding Collections
Using the Object Browser
Working with the Application Object
Understanding the Form Object
Working with Properties
Using the With Statement
Working with Methods
Understanding the DoCmd Object
Working with Events
Understanding the Order of Events
Using Expressions, Variables, and Intrinsic Functions
Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Working with Variable Scope
Working with Variable Lifetime
Considering Variable Scope and Lifetime Together
Using Intrinsic Functions
Understanding Constants
Using Intrinsic Constants
Using Message Boxes
Using Input Boxes
Controlling Program Execution
Understanding Control-of-Flow Structures
Working with Boolean Expressions
Using the If…End If Decision Structures
Using the Select Case…End Select Structure
Using the For…Next Structure
Using the For Each…Next Structure
Using the Do…Loop Structure
Guidelines for use of Branching Structures
Working with Recordsets
Declaring and Creating Object Variables
Working with the DAO Recordset Object
Debugging Code
Understanding Errors
Using Debugging Tools
Setting Breakpoints
Setting Break Expressions
Using Break Mode during Run Mode
Stepping through Code
Determining the Value of Expressions
Handling Errors
Understanding Error Handling
Understanding VBA’s Error Trapping Options
Trapping Errors with the On Error Statement
Understanding the Err Object
Writing an Error-Handling Routine
Working with Inline Error Handling
Additional information
1 to 1 training £425
2 to 4 delegates £595
5 to 8 delegates £795
Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £795. All prices exclude VAT. Please note this is a two day course.
Microsoft Access VBA Training Courses