Access VBA course
In this course you will learn how to automate tasks in Access using VBA. You will work with the VBA editor, the object model, loops, variables and error handling.
NRTO quality mark
- Automating Access tasks with VBA
- Writing your own functions and loops
- Debugging directly in the VBA editor
- Your own practical case as a starting point
- Trainer adapts to your level
Would you like to make Access work more intelligently and more quickly? In this course you will delve into VBA and automate common tasks. You will learn to write and adjust code in the VBA editor and work with the Access object model. The result: working more efficiently with your databases.
Description
In this course you will get to work with VBA in Access. You will learn how to generate and adapt code using the VBA editor, and you will be introduced to the object model and the specific objects in Access.
You work with subroutines, custom functions, variables, loops and Docmd objects, among other things. ADO techniques, debugging and error handling are also covered. An experienced trainer tailors the content to your starting level and learning objectives, so that you practise specifically with topics that are relevant to you. You can bring your own practical examples to work on straight away.
Topics
- The Access object model and VBA concepts
- Working with the VBA editor
- Using macros and VBA
- Creating subroutines and custom functions
- Using variables
- Building interaction with users
- Applying IF and OR in VBA
- Using loops
- Working with DoCmd objects
- Applying ActiveX Data Objects (ADO)
- Debugging in VBA
- Error handling in VBA
Result
After this course you will be able to automate common tasks in Access using VBA. You will write your own subroutines and functions, work with variables, loops and conditions, and use Docmd objects and ADO to control data. You will also learn to trace errors and handle them properly. The result: working with Access faster and with more enjoyment.
Target audience
This training course is intended for Access users who want to automate tasks with VBA. You have experience with Access and want to go a step further by writing and adapting code yourself. Some basic knowledge of programming is handy, but not a requirement.
Teaching method
You take this course in our open learning format. This means that on a day of your choice you work through your own course material, while an experienced trainer is present in the room to guide you. You work at your own pace and ask questions whenever you get stuck. That way you decide for yourself where to place the focus and which topics deserve extra attention. Do you have a practical example of your own? Feel free to bring it along and work on it directly during the course.
Prior knowledge
You need experience with Access at user level. You know how to create and use tables, queries, forms and reports. Programming experience is not required, but it is useful if you have worked with macros before.
Comments
You take this course in our open learning format: you work independently on assignments at your own pace, with an experienced trainer alongside you for explanation and questions. This way you decide for yourself where to spend extra time and which topics to work through more quickly.
Course format
This training is offered on the basis of our Open Learning teaching method. This means that you work independently, with active guidance from our trainer, to master the material. That way you can achieve your learning objectives at your own pace, without being held back by fellow participants working faster or slower. The trainer makes sure that you stay on schedule and meet your learning objectives. This form of learning leaves room for a tailored approach. You have the opportunity to bring in examples from your own practice and IT environment, so that your learning is even more specific. more...
Practical information
- Number of days
- 2 days
- Course times
- from 10 am to 5 pm
- Teaching hours
- 12 hours
- Education level
- Suitable for all levels
- Preparation time
- None
- Included
- Course materials and lunch on site
- Certificate
- At the end of the course you will receive a certificate of attendance
Language
The course is given in Dutch as standard. The trainer speaks English. English-language course materials can be used. If at least 3 participants register, the course can also be given entirely in English.
This course for your team?
Plan your own group on a date that suits you, at your office, at our premises or online. We tailor the content to your day-to-day work, and training a whole group is cheaper than individual bookings.
- Your date and location
- Tailored content
- Multiple groups or an academy are also possible
- More than 25 years' experience
What others say about this course
“Learned a great deal in a short time, which I can also apply straight away in practice”
“I took the Access Basics course. The trainer is highly knowledgeable and takes all the time needed to help you. Knows how to create a very pleasant atmosphere.”
“A very good training course for learning and working with Access 2003 Basics.”
“Clear course material that you can work through at your own pace.”
"Very good course. It certainly helps you expand your skills."
“The Access Basics course I took through learnit comes with very clear and well-organised course material, and it is further explained and clarified by a very experienced trainer.”
"A good way to improve your software skills independently."
“good course, learned a lot from it”
"I took the Access Basics course, and after completing the training I am able to extract the reports our organisation needs from our client registration system and present them in a professional way. It's good that the exercises you do during the course are easy to translate to what your own organisation needs."
“The Access Basics course ties in very well with practice. It contains some very useful things. The course material matches the learning objectives perfectly and you can easily work at your own pace. I would certainly take another course with Learnit.”
"I am satisfied with the course I attended and will certainly recommend Learnit to others, or take other courses myself in the future. Because you can take the course material home with you, I have a good foundation and reference for what I have learned."
“Even if you have never worked with Access before, the study books let you get started on your own in a good and enjoyable way.”
“My experience with Learnit Training is very positive. Good communication, clear arrangements. The content and delivery of the course were perfectly in order.”
“Completely lived up to expectations.”
“The course has a low entry level and is therefore suitable for a wide range of people. Working at your own pace is pleasant and practical application definitely comes up on the second day.”
"Clear course. The textbooks match the programme perfectly. The material described in the textbooks is more than clear. The exercises are clear and easy to complete with the explanations found in the book. The trainer is at a level where no question goes unanswered. The answers are clear."
"This course and trainer made clear to me what I can do with Access and, above all, what I cannot. Excellent result."
"This course and trainer made clear to me what I can do with Access and, above all, what I cannot. Excellent result."
“Learnit provides a good course, delivered in a relaxed and thorough manner. The trainer makes sure you get suitable support for your own practical questions.”
“The course material on offer is clear and it is good that you can work at your own pace. The trainer takes a proactive approach and is knowledgeable. Good facilities. Recommended”
"Following the Access 2007 Basics course, I would like to tell anyone interested to sign up with Learnit straight away if you want to learn Access, Excel or PowerPoint properly. The material is explained well in the book and the trainer answers any questions immediately."
“I came to Learnit to make my work easier by applying some extra skills. That is certainly going to work out after this instructive and interactive course!”
“The course has a low entry level and is therefore suitable for a wide range of people. Working at your own pace is pleasant and practical application definitely comes up on the second day.”
"A course you can follow at your own pace. It starts with the basics and slowly guides you towards being able to build a simple database yourself. In my view you do need a solid basic knowledge of Excel. But overall an excellent course that I can recommend to anyone."
"A good way to improve your software skills independently."
“The Access Basics course ties in very well with practice. It contains some very useful things. The course material matches the learning objectives perfectly and you can easily work at your own pace. I would certainly take another course with Learnit.”
“An excellent way to get to know Access.”
“Instructive and clear course. Also for people who are less interested in computer programmes. The days flew by.”
“An easy course to follow thanks to the step-by-step explanations and assignments through practice exercises. If anything is unclear, the trainer can give further explanation, after which you can work through the exercises in the book (2 of them) on your own.”
"Good course. This follow-up course ties in well with the basic course."
“I am very positive about Learnit. The course is very clear and the course material goes through the subject matter extensively, step by step. The environment is pleasant and quiet, the group agreeably small and the guidance one-to-one and geared to individual needs. I learned a great deal in two days and now apply it in my work. I warmly recommend Learnit.”
“The Access basics course is a very useful course if you are unfamiliar with the program. It starts from first principles, and even if you have little experience with computers at all it is still perfectly manageable. The coursebook describes step by step and in great detail how to work with the program.”
“Excellent structure. Immediately applicable. Highly recommended!”
“Access Basics is much more than just learning to understand the layout and buttons; with the basics you can already do a lot with Access, which is enough for me to get started with it.”
"The Access 2010 Basics course is very manageable, even for people with no Access experience. Over 2 days you calmly work your way through Access book part 1; if you have any questions you can ask them and they are explained to you personally. Those who are slightly more advanced work through part 1 more quickly and can go into more depth with part 2 — and here too, if you have questions they are explained to you one to one. An enjoyable and instructive course."
“Excellent course, learned a lot. The exercises are very good. Many of these things can be used for your own applications.”
“Clear course material that you can work through at your own pace.”
“The impression I have of Learnit is good; you can work through the material at your own pace and consult the trainer if you have questions.”
“Good course material, a course book with clear explanations and accompanying assignments/cases. After the course you may take both the course book and the DVD home, so you can always go over the course material again.”
"A course you can follow at your own pace. It starts with the basics and slowly guides you towards being able to build a simple database yourself. In my view you do need a solid basic knowledge of Excel. But overall an excellent course that I can recommend to anyone."
“A very good course that fits perfectly with the practical requirements of developing and maintaining a database in Access.”
“A course where time is taken to actually learn something.”
“The impression I have of Learnit is good; you can work through the material at your own pace and consult the trainer if you have questions.”
“To the point training, with your own learning objectives taking centre stage.”
“A pleasant introduction to SQL under the guidance of a knowledgeable and driven trainer.”
“I came to Learnit to make my work easier by applying some extra skills. That is certainly going to work out after this instructive and interactive course!”
“Definitely take this course. Individual guidance works really well. Highly recommended.”
"Good course. This follow-up course ties in well with the basic course."
"No"
"Pleasant course material, nice to be able to work at your own pace and a trainer who is on hand to help you. A good way to take in the material. You work in small groups."
Training formats
Classroom
2 days€ 1100,-- Pleasant venue with a good trainer
- Small groups
- Inspiring and motivating
In-company
Bespoke trainingOn request- 100% for your group
- Bespoke training
- At your place or ours
Workshop
Up to 4 hours for groupsOn request- Suitable for events
- Interactive and inspiring
- Large groups too
Private training
At our place or yoursOn request- 100% just for you
- Achieve a lot in little time
- Whenever you want