Learnit Training
Access VBA course
  • Small groups
  • Covid-19 safe
  • Experienced teacher
  • Possible online
  • Practical training

With VBA you can automate and mould many common actions and procedures in Access. In this two-day training course you will learn how to program in VBA using Access' VBA editor.

Yes, I want to know more

"The material that is offered is clear and it is nice that you can work at your own pace. Teacher is pro-active and knowledgeable. Good facilities. Recommended" - Rating: 8.6

learnit Access Basic

Access VBA course

In this two-day training you learn how to automate common tasks with VBA. You will learn how to generate and modify codes using the VBA editor. You will also become familiar with the object model and the specific objects (library) of Access.

Topics

  • Understanding the Access object model and VBA concepts
  • Working effectively with the VBA editor
  • Using macros and VBA
  • VBA subroutines and custom functions
  • Using variables
  • Interactivity with users
  • Using IF and OR in VBA
  • Using loops in VBA
  • Working with Docmd objects
  • Use of ActiveX Data Objects (ADO) techniques
  • Troubleshooting in VBA
  • Error handling in VBA

The trainer

You will be guided in this training by a very experienced trainer. At the start of the course, the trainer will discuss your entry level and what you want to get out of the course, so that you can focus on the topics and exercises that are important to you. Our trainer knows everything about Access VBA and will help you master it at your level.

Case studies

If you have encountered problems yourself or would like to carry out certain actions more efficiently, it can be enlightening to bring an example from your working environment to the training. You can then work in an even more practice-oriented way.

Afterwards

After completing this training course you will be able to automate common actions in Access and mould them to your needs using VBA. The result: working with Access will be faster and more enjoyable.

Prior knowledge

Knowledge and skill at the course level Access Continued is recommended.

Note

We will be using English language course material for Access 2016 during this course. This course can be followed in different versions. Please indicate whether you are using Access 2007, 2010, 2013 or 2016.

Course format

This training is offered on the basis of our Open Learning Method. This means that under the active guidance of our trainer, you work independently to master the material. This enables you to achieve your learning goals at your own pace without being hindered by the faster or slower pace of your fellow course members. The trainer will make sure you stay on track and achieve your learning goals. This type of learning allows for customisation. You are given the opportunity to bring in examples from your own practice and IT environment, which will help you learn even more specifically .

Language

The training is provided in Dutch as standard. The trainer has a good command of the English language. Use can be made of course material in English. With a minimum of three participants, the training can also be provided entirely in English.

Investment

Prices mentioned are per person, including course material. Lunch is included in the on-site training.

On location Online
Duration 2 days 4 sessions of three hours
Price per day, excluding VAT € 375,- € 290,-
Total, incl. VAT € 907,50 € 701,80

Certificate

After completion of the training, a Learnit certificate is issued as proof of participation.


Online

We also organise this training online. For this we use Webbex or Zoom. Login with Skype is also possible. On request, this training can also be organised with Microsoft Teams.

The training lasts 4 sessions of 3 hours, spread over 4 weeks.

  • You can participate again free of charge up to one year after the training.
  • For an additional catering fee, you can also participate in a classroom training.

References

The course Access VBA has been assessed with an average of 8.4.

"I am very positive about Learnit. The training is very clear, the course material is extensive, going through the material step by step. The environment is pleasant, quiet, the group is pleasantly small and the guidance is one-to-one and focused on individual needs. I have learned a lot in two days and now apply it in my work. I highly recommend Learnit." - Rating: 7.7

R. van Nimwegen-Anbeek, Christian Lyceum Veenendaal - Access Basics

"In two days you do indeed get a decent basic knowledge of Access in a very practice-oriented course. What's more, it makes you want to get to work!" - Rating: 8.0

N. van den Berg, Wingman Business Valuators BV - Access 2003 Basic

"In a short time I learned a lot, which I can also apply directly in practice. - Rating: 8.1

Gert Lems, South Holland Safety Region - Access Basic

"Especially follow this course. Individual coaching works really well. Highly recommended." - Rating: 8.3

W. van Pelt, Ericsson Telecommunicatie B.V. - Access Base

"The material that is offered is clear and it is nice that you can work at your own pace. Teacher is pro-active and knowledgeable. Good facilities. Highly recommended". - Grading: 8.6

D. Thijssen, CEVA Logistics - Access Basics

"Access basics is much more than just learning the layout and buttons, with the basics you can already do a lot with acces which is enough for me to get started with it." - Rating: 9.4

M. Ronokarijo, Total Nederland N.V. - Access Base

"The training is based on various levels, from beginners to advanced. The teacher responds very well to this and you immediately feel at home in the group despite the level differences. I can really recommend the training." - Rating: 8.7

F. Bergsma, Rent Control Committee - Access Continued

"Very good training to learn and handle Access 2003 Basics." - Rating: 9.1

Marco Kruijt - Access 2003 Basic

"Good teaching material, textbook with clear explanations and accompanying assignments/cases. After the training you may take both the textbook and the DVD home, so you can repeat the training at any time." - Rating: 8.2

Roy Delhaye - Access Continued

"Clear teaching material that you can complete at your own pace." - Rating: 8.1

H.G.G. Houx, Rabobank Netherlands - Access Basics

"The Access 2010 Basic training is easy to do, even for people who have no Access experience. You work in 2 days quietly the book Access part 1 are there questions you can ask and are explained to you personally, for the slightly advanced who leafs through the book part 1 faster and can make with part 2 his deepening stroke also here applies, you have questions they are again explained to you 1 on 1. a fun and educational course." - Rating: 8.0

S. van der Vliet, Netherlands Government Service for Enterprises - Access Basics

"Very good training. It definitely helps with expanding your skills." - Rating: 8.3

R. Koolen, Kuehne en Nagel Logistics - Access 2003 Continued

"The course has a low entry level and is therefore suitable for a wide range of people. Working at one's own speed is pleasant and practical applicability is certainly addressed on the second day." - Rating: 7.1

F. Tamminga, IHC Merwede - Microsoft Access 2003 VBA

"Good course that is easy to apply in everyday use." - Rating: 9.3

R. Fiks, Achmea Zorg en Gezondheid - Access Basic

"Very good training that perfectly meets practical needs of developing and maintaining a database in Access." - Rating: 9.0

H. de Jong, Diamond Genetics - Access Continued

"Getting acquainted with SQL in a pleasant way under the guidance of a knowledgeable and driven teacher." - Rating: 7.9

E.C. van Herwaarden-Boekweit, Achmea Zorg en Gezondheid - Access Basic

"I have a very good impression of the course taken via Learnit. The most appealing aspect is that you can go through the material at your own pace. You are therefore not dependent on fellow course members. In case of any questions, a competent and very friendly instructor is available for questions." - Rating: 8.0

M. Salman, RSA Netherlands - Access Basics

"The Access basic training is a very useful course if you are unfamiliar with the programme. It starts from the basics, and even if you have very little experience with computers it is still doable. The study book describes step by step and in great detail how to work with the programme." - Rating: 9.0

R. Stolker, Deliflor Chrysanten B.V. - Access Basics

"To the point training where your own learning goals come first." - Rating: 8.4

Floor Frederiks, Kennemer Gasthuis - Access Basic

"I followed the Access Basic training, after following the training I am able to extract the reports needed for our organisation from our client registration system and present them in a professional manner. Nice that the exercises you make in the training are easy to translate to what is needed in your own organisation." - Rating: 10.0

R. Borkent, St. VO Rosa Manus - Access Basic

"Instructive and clear course. Also for people who are less interested in computer programmes. The days flew by." - Rating: 9.0

P. Thomas, Ministry of Defence - Access Base

"Good way to improve working with software independently." - Rating: 8.1

E. Hagemeijer, Kuehne en Nagel Logistics B.V. - Access 2003 Basic

"A training course where the time is taken to learn." - Rating: 9.3

A. de Rop, CEVA Logistics - Access Basics

"Clear course. Textbooks match the course perfectly. The material described in the textbooks is more than clear. assignments are clear and easy to carry out with the explanations that can be found in the book. Trainer is at a level that leaves no question unanswered. Answers are clear." - Rating: 9.0

M. Schins, AMC - Access Base

"No"

- Microsoft Access 2003 VBA

"Excellent course, learned a lot. Exercises are very good. Many things from this can be used for one's own applications." - Rating: 8.0

J. Rensen, Shell Pensioenbureau Nederland B.V. - Access Base

"Learnit's open learning method works well for me. Everyone can absorb the material at his/her own pace. Moreover, several courses can be taught simultaneously. Our teacher was clear in his explanations and created a good atmosphere in the group." - Rating: 8.7

M. Wolthoorn, DJI - Access 2003 Basic

"Followed the Access beginners course in Heerenveen. Small group, good guidance. Course material is pleasant to work with and clear. Learned a lot in two days! - Rating: 8.2

G. Koster-Storteboom, Trustus Capital Management - Access Base

"Good course, learned a lot. - Rating: 8.2

P. van der Struijs, NRG - Access Basics

"A training course that you can follow at your own pace. It starts with the basics and slowly leads you to being able to build a simple database yourself. In my opinion, you do need a sound basic knowledge of Excel. But overall an excellent course which I can recommend to everyone." - Rating: 7.8

W. B. Vermeulen, Theodoor Gilissen Bankiers N.V. - Access Key

"Excellent way to become familiar with Access." - Rating: 8.3

I. Dzambo, CBS - Access Base

"I am satisfied with the training I received and will certainly recommend Learnit to others or follow other training courses myself in the future. Because the course material can be taken along, I have a good basis and reference of what I have learned." - Rating: 8.0

E. de Brouwer, BMW Financial Services B.V. - Access basic

"As a result of the Access 2007 basic course, I would like to indicate to those interested to sign up immediately at Learnit if you want to learn Access, Excel or PowerPoint well. The material is well explained in the book and the instructor answers any questions immediately." - Rating: 8.0

S. Polak, Schouten Insurance - Access Basics

"The Access basics course is very much in line with practice. It contains very useful things. The material fits perfectly with the learning objectives and you can work at your own pace. I would definitely do another course at Learnit." - Rating: 7.6

M.A. Wildenberg - Access Basics

"The training is easy to follow because of the step-by-step explanation and assignments through practice assignments. In case of any lack of clarity, the trainer can provide further explanation after which the exercises in the book (2 copies) can be completed independently." - Rating: 7.6

J. Japenga, SNS Bank - Basic Access

"Good course. This follow-up course fits well with the basic course." - Rating: 8.0

J. Rensen, Shell Pensioenbureau Nederland B.V. - Access Continued

"It is nice to work independently with the material and all kinds of exercises. The expert teacher is always available if you have questions!" - Rating: 9.1

I.K. Geuzenbroek, TU Delft - Access Continued

"If you really want to learn this, this is highly recommended. But do Acces for beginners first to have a good basis." - Rating: 9.8

D. Dijkstra, FrieslandCampina - Access Continued

"I followed the Access Basic course. The instructor is very knowledgeable and takes all the time to help you. Knows how to create a very pleasant atmosphere." - Rating: 8.0

J. de Graaf, Incotec Group B.V. - Access Basics

"Learnit offers a good training, which is given in a relaxed and thorough manner. The teacher ensures that you receive appropriate support for your own practical questions." - Rating: 8.6

Rene Friederichs, Municipality of Arnhem - Access 2002 Basic

"Complied fully with expectations." - Rating: 7.9

R. Vlek, UWV - Access 2002 Continued

"Training Acces Basic that I have followed through learnit is provided with very clear and well-organised teaching materials, in addition, it is further explained and explained by a very experienced teacher." - Rating: 8.0

R. Bell, CEVA Logistics - Access Basics

"Even if you have never worked with Access before, the textbooks allow you to get started yourself in a good and fun way." - Rating: 7.9

L. Pattikawa, Transcom - Access Basics

"Very clear teaching material and teacher; an instructive course and experience!" - Rating: 7.6

K. Heeringa, Conscious Hotel Vondelpark. - Access Basics

"For me, the biggest plus was that the teaching material is very clear. This allows you to follow the training at your leisure without the stress of wondering what they mean. I have been very positively surprised. however, I must say that I already had some knowledge of access."

- Access Basic

"Excellent structure. Directly applicable. Highly recommended!" - Rating: 8.2

J. Joanknecht, Joanknecht Holding b.v. - Access Basic

"My experience with Learnit Training is very positive. Good communication, clear agreements. Content and execution of the training fine." - Rating: 8.0

M. Oostland-Meles, Education Executive Agency (DUO) - Access Basics

"Pleasant teaching material, being able to work at your own pace and a trainer who is ready to help you. A nice way of absorbing the material. We work in small groups." - Rating: 8.6

R. Westerink, Spectrum, partner with Elan - Access basic

"I came to Learnit to be able to make my work easier by applying some extra skills. This is definitely going to work after this instructive and interactive course!" - Rating: 8.4

M. Karens, De Persgroep - Access Basics

"Very useful training. Interesting and clear teaching material, which teaches you from the ground up how to build a database. Lots of practice material and variety. I went through it quite quickly because it was so clear and at the end of day two I could already create beautiful tables, queries, forms and switchboards." - Rating: 8.7

K. Serbassi-Natzijl, Rabobank Amsterdam - Access 2003 Basic