Microsoft Access Training
At a basic level, you can use Access to develop simple, personal database-management systems. Some people accululate everything from their wine collections to their home finances.
Companies use Access to develop Customer Databases, Asset Databases and many more. Access makes it easier to not only store information but also to create user forms to suit the user run queries on the stored data and run reports.
Good database design will make a difference for the end user and the amount of effort required in finding the necessary information.
With the help of our excellent trainers, you can learn how to design database that will suit your requirements. From small, one table database design to big databases with multiple tables linked together and automated actions created in Visual Basics, we will be happy to assist with all aspects of database creation.
Please select the version that you’re interested from below:
Please select the level that you’re interested in
Microsoft Access 2016 VBA
Course Overview
- Understand the VBA Environment
- Create Subroutines and Functions
- Understand all VBA Structures
- Apply DAO Model
Audience:
This course is designed for advanced Access users who need to start writing codes to automate database tasks using VBA.
Prerequisite:
You must have strong Microsoft Access skills and understand all concepts from Introduction to Advanced course contents.
Duration:
This is a 2 day MS Access VBA course. The course starts at 09:30 and runs until 16:30. Alternate timings can be arranged upon request. The course can be held on a date that suits you.
Location:
Our Microsoft Access VBA course can be run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.
Access 2016 VBA Course Outline
MACROSCreating Macros Assigning Macros to Controls Group Macros Conditional Macros The AutoExec Macro The AutoKeys Macro VBAAn overview The Environment Working with Modules Converting Macros -DOCMD Events CODING STRUCTURESControl Structures (If, ElseIf, SelectCase) Looping Structures (Do, For, Next) FUNCTIONSPurpose Creating and using Functions | VARIABLESOption Explicit Variable Type Scoping a Variable Testing Variable Contents USER INTERACTIONMsgBox InputBox DEBUGGING AND |
One to One
(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training
Group for up to 8 learners
What Our Clients Say
Extras
This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.