Users who need to use the added functionality of Access Visual Basic for Applications to build, maintain, manipulate and automate databases.
Objectives:
At the end of the course users will be able to understand and create VBA code. You will be able to create procedures and functions and use VBA to manipulate data from tables and queries.
Prerequisites:
An advanced understanding of creating Access databases, including table and form design.
Duration:
3 Days
Cost:
£695 + VAT
Course Date
Location
Demand led
Call to request dates
Introducing Visual Basic for Applications
Exploring the Visual Basic Editor
Running Code from the Immediate Window
Introducing Visual Basic Code
Understanding Objects & Dot Syntax
Creating & Organising Modules
Commenting & Editing VBA Code
The Access Object Model
Writing VBA Code
Understanding Procedures
Organising Code using With...End With
Writing Clear & Structured Code
Calling Procedures from Different Locations
Using the DoCmd Object to Control Access Interface Features
Variables, Constants & Scope
Understanding & Naming Variables
Declaring Variables & Data Types
Declaring & Using Constants
Assigning Values & Objects to Variables
Performing Calculations in VBA Code
Message Boxes
Creating & Customising Message Boxes
Receiving Information from Message Boxes
Input Boxes
Creating Input Boxes to Receive User Data
Understanding & Customising Input Boxes
Function Procedures
Understanding & Using Intrinsic Functions
Writing User-Defined Functions
Using User-Defined Functions in VBA & the Access Interface
