Access VBA Introduction Training Course
Table of Contents
Access VBA Introduction Overview
Our Access VBA Introduction training course is designed for existing Access users who need to use VBA to automate database tasks or simplify complex database sequences.
We also develop an appreciation of situations when you might prefer to automate Access operations using Access macros rather than Access VBA.
Access VBA Introduction Five Key Topics
- Understanding the DoCmd Object
- Access Document Object Model
- Writing loops in VBA code
- Events to trigger code
- Manipulating Recordsets
Course Duration : 2 day
Course Availability : Monday – Saturday
Course Types : Group booking, 1-2-1 sessions, Bespoke & Public Courses
Training Times : Our courses run run from 09:30 to16:30, course registration 09:00 – 09:30, refreshments available throughout the day. A buffet lunch is available – please discuss with the team.
Facilities : A relaxed environment, air conditioned training rooms, note pads, pens and unlimited access to our online course materials.
Access VBA Introduction Training Course Details
Course Location : Face to face group / public & onsite training available. Virtual training courses available.
Class Size : As a guide we recommend class sizes to be no more than eight.
Virtual / Online training Format : Teams or Zoom.
Tailored Course Content : Our VBA introduction Access courses can be tailored to your requirements – Get In Touch
Tailored Courses : We offer a free consultancy service to help tailor the course to meet your requirements.
Centre and Services
Comfortable & modern facilities
Unlimited access to our online training manuals
Courses delivered by Certified Trainers
Microsoft & CPD courses available
Michael, one of our lead Access trainers, has over 25 years of delivering Access at all levels levels.
All our trainers are encouraged to become Microsoft Accredited within their first year of working at Mouse Training.
Our instructors are very approachable, making the driest subject matter fun.
On Completion of Microsoft Access VBA Introduction
- Use the VBA code editor
- Create message boxes and variables
- Create function procedures
- Understand Visual Basic concepts
- Trigger code in various ways
- Create loops
- Manipulate Recordsets
- Debug procedures and handle errors
- Automate Forms
- Link to Excel and Word
- Modify queries
Access VBA Introduction Course Outline
- Two ways to create modules
- Using Project Explorer
- Basic subroutines and comments
- The all-powerful DoCmd object
- Displaying messages
- Getting input from users
- Using variables
- Passing arguments
- Returning values
- Objects and collections
- Methods and properties
- The Access object model
- Getting help in VBA
- Attaching code to forms
- Attaching code to buttons
- Attaching code to events
- Manipulating form/control properties
- Making code not form-specific
- The four types of loop
- Looping over all open forms
- Looping over controls
- Looping over Access Objects
- Choosing ADO or DAO
- Adding data
- Editing data
- Deleting data
- Stepping through macros
- Setting breakpoints
- Trapping for errors
- Case studies
- Navigation buttons
- Creating a simple menu
- Validating forms
- Criteria forms
- Referencing other applications
- Manipulating Excel from Access
- Basic SQL statements
- Amending queries’ SQL
Is this VBA Introduction Access Course for You?
Give us a call, our admin team will be delighted to assist in making sure you are on the correct course.