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

Met VBA kun je veel voorkomende handelingen en procedures in Access automatiseren en naar je hand zetten. In deze training en leer in twee dagen om te programmeren in VBA waarbij je gebruik maakt van de VBA editor van Access.

Yes, I want to know more

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

learnit Access Base

Course Access VBA

In This two-day training you'll learn how to automate common tasks with VBA. You will learn to generate and modify codes using the VBA editor. You also get acquainted with the Access object model and the specific objects (library).

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
  • Use of IF and OR in VBA
  • Using loops in VBA
  • Working with Docmd objects
  • Use of ActiveX Data objects (ADO) techniques
  • Debugging in VBA
  • Error handling in VBA

The Trainer

You will be accompanied by a very experienced trainer in this training. The trainer discusses at the beginning of the training what your entry level is and what you want to get out of the training, so that you can focus on subjects and exercises that are important to you. Our trainer knows everything about Access VBA and helps you to get to know your level to master everything.

Practice

If you have run into problems yourself or would like to perform certain actions more efficiently, it can be enlightening to take an example from your work environment to the training. You can still get more practice-oriented.

After

After following this training, you will be able to automate many common actions in Access and convert them to your hand using VBA. The result is faster and more enjoyable work with Access.

Prior knowledge

Knowledge and skill at the level of the course Access sequel is recommended.

Note

During this course we use English language course material for Access 2016. This training can be followed in different versions. Please indicate whether you are using Access 2007, 2010, 2013 or 2016.

Lesvorm

This training is offered on the basis of our Open learning form-teaching method. This means that under the active supervision of our trainer, you are working independently to make your own substance. You can achieve your learning goals at your own pace without being bothered by a faster or slower pace of your fellow students. The trainer will ensure that you stay on track and achieve your learning goals. This form of learning offers space for customised work. You will have the opportunity to create examples from your own practice and IT environment that will make you more specific. more...

Language

The training is provided by default in Dutch. The trainer controls the English language. English course material can be used. When registering at least 3 participants, the training can also be provided entirely in English.

Investment

Mentioned prices are per person, including course material. Lunch is included in the training on location.

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

Certificate

After completing the training, a LEARNIT certificate will be issued as proof of participation.


Online

We also organize this training online. For this we use Webbex or Zoom. Logging in with Skype is also possible. On request this training can also be organized with Microsoft Teams.

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

  • Until one year after the training you can participate for free.
  • Against payment of the catering costs you can also participate in a classroom training.

References

De cursus Access VBA is beoordeeld met een gemiddelde van 8.4.

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

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

"A training where time is taken to learn." - Assessment: 9.3

A. de Rop, CEVA Logistics - Access Base

"Good course that's easy to apply in everyday use." - Assessment: 9.3

R. Fiks, Achmea Care and Health - Access Base

"Good teaching materials, textbook with clear explanations and corresponding assignments / cases. After the training you may take both the textbook and the DVD home with you, so that you can repeat the training at all times". - Assessment: 8.2

Roy Delhaye - Access Continued

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

P. Thomas, Ministry of Defence - Access Base

"No"

- Microsoft Access 2003 VBA

"Clear teaching material that you can finish at your own pace." - Assessment: 8.1

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

"I'm satisfied with the training I've had and will definitely recommend Learnit to others or follow other training in the future. Because the teaching material can be taken with me, I have a good basis and reference of what I have learned". - Rating: 8.0

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

"The impression I have of Learnit is good, you can go through the lesson material at your own pace and consult the teacher if you have any questions. - Assessment: 8.4

G.J. Scholten, Nijland B.V. - Access Continued

"Clear course. Textbooks fit in perfectly with the training. the subject matter described in the textbooks is more than clear. Assignments are clear and easy to carry out with the explanation that can be found in the book. Trainer is on a level that no question remains unanswered. answers are clear." - Rating: 9.0

M. Schins, AMC - Access Base

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

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

"good course, a lot of learning." - Assessment: 8.2

P. van der Struijs, NRG - Access Base

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

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

"On the basis of the Access 2007 basic course, I would like to indicate to interested parties that they are interested in joining Learnit if you want to learn Access, Excel or PowerPoint well. The subject matter is well explained in the book and any questions the teacher answers immediately". - Rating: 8.0

S. Polak, Schouten Insurance - Access Base

"It's nice to be able to work independently with the subject matter and all sorts of exercises. The expert teacher is always at your disposal if you have any questions". - Assessment: 9.1

I.K. Geuzenbroek, TU Delft - Access Continued

"Good teaching materials, textbook with clear explanations and corresponding assignments / cases. After the training you may take both the textbook and the DVD home with you, so that you can repeat the training at all times". - Assessment: 8.2

Roy Delhaye - Access Continued

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

Floor Frederiks, Kennemer Gasthuis - Access Base

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

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

"Good teaching materials, textbook with clear explanations and corresponding assignments / cases. After the training you may take both the textbook and the DVD home with you, so that you can repeat the training at all times". - Assessment: 8.2

Roy Delhaye - Access Continued

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

K. Heeringa, Conscious Hotel Vondelpark. - Access Base

"I'm satisfied with the training I've had and will definitely recommend Learnit to others or follow other training in the future. Because the teaching material can be taken with me, I have a good basis and reference of what I have learned". - Rating: 8.0

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

"The Access Basics course fits in very well with practice. It contains very useful things. The course material fits in perfectly with the learning objectives and you can work at your own pace. A next course I would definitely do again at Learnit". - Review: 7.6

M.A. Wildenberg - Access Base

"The subject matter offered is clear and it's nice that you can work at your own pace. Teacher is pro-active and expert. Good facilities. Recommender" - Rating: 8.6

D. Thijssen, CEVA Logistics - Access Base

"Nice teaching material, nice to be able to work at your own pace and a trainer who is ready to help you. Fine way to take the fabric to you. We work in small groups." - Rating: 8.6

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

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

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

"good course, a lot of learning." - Assessment: 8.2

P. van der Struijs, NRG - Access Base

"Good course that's easy to apply in everyday use." - Assessment: 9.3

R. Fiks, Achmea Care and Health - Access Base

"Nice teaching material, nice to be able to work at your own pace and a trainer who is ready to help you. Fine way to take the fabric to you. We work in small groups." - Rating: 8.6

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

"Learnit offers a good training, which is given in a relaxed and thorough way. The instructor will make sure that you receive appropriate support on your own practical questions". - Assessment: 8.6

Rene Friederichs, Municipality of Arnhem - Access 2002 Basic

"Good course that's easy to apply in everyday use." - Assessment: 9.3

R. Fiks, Achmea Care and Health - Access Base

"Learnit offers a good training, which is given in a relaxed and thorough way. The instructor will make sure that you receive appropriate support on your own practical questions". - Assessment: 8.6

Rene Friederichs, Municipality of Arnhem - Access 2002 Basic

"the Access 2010 Basis training is good to do, even for people who don't yet have Access experience. You work in 2 days quietly the book Access part 1 by his questions can ask you and will be explained to you personally, for the more advanced who leafs through the book part 1 faster and with part 2 can make his floor money again, you have questions they will be explained to you again 1 on 1. a fun and educational course." - Rating: 8.0

S. van der Vliet, Rijksdienst voor Ondernemend Nederland - Access Base

"I took the Access Basic course. The teacher 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 Base

"Excellent way to get acquainted with Access." - Assessment: 8.3

I. Dzambo, CBS - Access Base

"To get acquainted with SQL in a pleasant way under the guidance of a skilled and driven instructor." - Review: 7.9

E.C. van Herwaarden-Boekweit, Achmea Care and Health - Access Base

"Learnit offers a good training, which is given in a relaxed and thorough way. The instructor will make sure that you receive appropriate support on your own practical questions". - Assessment: 8.6

Rene Friederichs, Municipality of Arnhem - Access 2002 Basic

"Excellent buildup. Directly applicable. Recommended!" - Assessment: 8.2

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

"I came to Learnit to be able to make my work easier by applying some extra skills. This will certainly succeed after this instructive and interactive course". - Assessment: 8.4

M. Karens, De Persgroep - Access Base

"Nice teaching material, nice to be able to work at your own pace and a trainer who is ready to help you. Fine way to take the fabric to you. We work in small groups." - Rating: 8.6

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

"Very useful training. Interesting and clear teaching material, which you learn from the basics how to build a database. Lots of practice material and variety. Went through it pretty quickly because it was so clear and at the end of day two could already make nice tables, queries, forms and switchboards". - Review: 8.7

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

"Even if you've never worked with Access before, you can get started in a good and fun way with the textbooks." - Review: 7.9

L. Pattikawa, Transcom - Access Base

"Especially taking this course. Individual coaching works super well. Highly recommended." - Assessment: 8.3

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

"In a short period of time I've learned a lot that I can directly apply in practice." - Assessment: 8.1

Gert Lems, Safe region South Holland - Access Base

"Learnit offers a good training, which is given in a relaxed and thorough way. The instructor will make sure that you receive appropriate support on your own practical questions". - Assessment: 8.6

Rene Friederichs, Municipality of Arnhem - Access 2002 Basic

"good course, a lot of learning." - Assessment: 8.2

P. van der Struijs, NRG - Access Base

"Very good training. It certainly helps to expand your skills." - Assessment: 8.3

R. Coal, Kuehne and Nagel Logistics - Access 2003 Continued

"I came to Learnit to be able to make my work easier by applying some extra skills. This will certainly succeed after this instructive and interactive course". - Assessment: 8.4

M. Karens, De Persgroep - Access Base

"To get acquainted with SQL in a pleasant way under the guidance of a skilled and driven instructor." - Review: 7.9

E.C. van Herwaarden-Boekweit, Achmea Care and Health - Access Base

"On the basis of the Access 2007 basic course, I would like to indicate to interested parties that they are interested in joining Learnit if you want to learn Access, Excel or PowerPoint well. The subject matter is well explained in the book and any questions the teacher answers immediately". - Rating: 8.0

S. Polak, Schouten Insurance - Access Base

"This training and trainer has made clear to me what I can and especially what I cannot do with Access. Great result." - Assessment: 7.4

H. Hulsink, MailFactory - Access Base