Microsoft Access 2003 - VBA
Overview
Enhance Access databases with automation using Macros and VBA code.
Target Audience
This course is aimed at advanced users of Microsoft Access 2003 who wish to enhance existing databases with VBA code to create Access Applications.
Prerequisites
Delegates should have a sound knowledge and experience of Access 2003 at Advanced level and preferably possess some experience in the use of Macros and Events within Access or other programming language. Specifically participants need to be fully conversant in:
- Create basic Macros in Access.
- Table Relationships and Database Normalisation.
- Create and use Form objects like buttons and drop down list.
Objectives
Upon completion users will be able to:
- Explore the Access VBA Environment.
- Run and reuse code.
- Use VB Methods, Objects and Properties.
- Use Variables.
- Debug Applications.
Duration
2 days.
Course Content
Where Code is Stored
- Standard modules
- Class modules
Development Environment
- Adding Code to a Form or Report
- Types of Procedures
- Entering Code
Running Code
- Run mode and Design mode
- Running Code from the development environment
- Running Code from the host application
Reusing Code
- Exporting a file
- Importing a file
Variables
- Lifetime and scope of variables
- Using and writing sub-procedures
- Using and writing Function procedure
Controlling Programme Flow
- Conditional structures
- Looping structures
- Trapping errors
Debugging
- Using the Break Mode
- Using the VB Editor Debug features
Using Standard VB
- Input Boxes
- Message Boxes
- Standard VB Functions
- Functions in your Code
Object Module Forms and Events
- Reports and Report Events
- Creating a Workspace Using the Microsoft Jet Engine
- Retrieving a Record set
- Navigating Records
- Updating Records
- Adding Records
- Querying Data
