Access VBA Programming Introduction
Introduction
Microsoft Access is one of the world’s leading database packages. Good databases can become brilliant systems when VBA is used to customise what it does.
Objectives
To teach the basics of Visual Basic programming within Access including automatic/background processing of data. The trainees will learn how to create a Wizard, interact with the user, process data in the background and run queries from user input.
Designed for
Experienced users of Access. No previous experience of programming is required.
Duration
2 Days
Topics
- Programming Basics
- The Visual Basic Editor
- Objects & Properties
- Methods & Arguments
- Message Boxes
- Input Boxes
- Include comments
- Event Driven Procedures
- Variables
- Create variables
- Variable types
- Setting variables
- Scope of Variables
- Data Processing
- Find records
- Update records
- Recordsets
- Create recordsets
- Loops
- Edit and Update Records
- Query by Form
- SQL
- The Querydefs collection
- Advanced Programming
- Debug
- Calling Procedures
- Trapping Errors
- Passing variables to other procedures
Follow-up
Individual consultancy and tuition as required