Microsoft Access VBA Training
Course
In London
Description
-
Type
Course
-
Location
London
-
Duration
2 Days
This Microsoft Access VBA training course will teach you how to manipulate your Access database using VBA (Visual Basic for Applications) code, automating the database. Access VBA extends the features of the database, providing you with the full power of Visual Basic programming to manipulate Access objects.
This course is instructor led, involving the use of numerous examples and exercises in a workshop environment in order to practice the techniques and methods that have been taught.
Facilities
Location
Start date
Start date
About this course
This course will ensure that you go back to your office as a confident, relaxed Access VBA programmer. It will lead you through programming and controlling Access using VBA using multiple examples to reinforce the concepts that you are being taught.
This Access VBA course requires prior knowledge of Access up to the level in our Advanced Microsoft Access training course. No prior knowledge of Access macros or Visual Basic for Applications (VBA) is required.
Our courses run from 9.30 am to approximately 4.15pm. While you are with us we are focused on offering you a relaxed and productive learning environment. When you book a course with use you get the following:
A full colour training manual/book.
The exercises that you have worked on during your course to allow you to practice afterwards.
USB stick to take the exercises away.
Certificate of attendance
Freshly prepared lunch.
Refreshments throughout the day.
Training in fully air conditioned facilities from an experienced instructor.
Reviews
-
.
← | →
Course rating
Recommended
Centre rating
Tori Citrine
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 10 years
Subjects
- Excel
- Word
- Access
- Visual Basic training
- Database
- SQL
- Database training
- Visual Basic
- Programming
- MS Excel
- Microsoft Access
- Ms Word
Course programme
- 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 buttons
- Attaching code to events
- Making code not form-specific
- Manipulating Form/Control Properties
- The four types of loop
- Looping over all open forms
- Looping over controls
- Looping over Access Objects
- Basic SQL statements
- Amending queries’ SQL
- Choosing ADO or DAO
- Adding data
- Editing data
- Deleting data
- Stepping through macros
- Setting breakpoints
- Trapping for errors
- Referencing other applications
- Manipulating Excel from Access
Microsoft Access VBA Training