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.
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.
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.
For teams and organisations. Does your department work with Access databases, and do several colleagues want to automate recurring tasks with VBA? We also run this course in-company. In consultation, we work with examples from your own practice.
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.
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.
The course is also suitable for application administrators, key users and administration, finance or planning staff who maintain an Access database and want to automate recurring tasks in it.
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.
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.
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.
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...
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.
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.
"Very good course. It certainly helps you expand your skills."
“A very complete course, and in my case with a highly skilled trainer. Prior knowledge of Access is definitely required, otherwise the course would become too complicated. A particular plus is the option to bring your own practical examples on a USB stick or similar, so you can work on them or go through specific issues with the trainer. I found the open learning format pleasant, because you can work at your own pace and have the freedom to skip parts (because you already know how to apply something) or choose your own order for the material to be covered.”
"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."
“Definitely take this course. Individual guidance works really well. Highly recommended.”
“Completely lived up to expectations.”
"No"
“An excellent way to get to know Access.”
“good course, learned a lot from it”
“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.”
“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.”
“In two days you really do gain a solid basic knowledge of Access in a very practically oriented course. What is more, it makes you keen to get started with it!”
"Very useful course. Interesting and clear material that teaches you from the ground up how to build a database. Plenty of practice material and variety. I got through it fairly quickly because it was so clear, and by the end of day two I was already able to create good tables, queries, forms and switchboards."
"For me, the biggest plus was that the course material is very clear. This means you can follow the course at your own pace, without the stress of wondering what they actually mean. I was very pleasantly surprised. I should say, though, that I already had some knowledge of Access."
"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."
“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!”
“To the point training, with your own learning objectives taking centre stage.”
"A good course that is easy to apply in day-to-day use."
“Learned a great deal in a short time, which I can also apply straight away in practice”
“A very good course that fits perfectly with the practical requirements of developing and maintaining a database in Access.”
"I took the Access beginners course in Heerenveen. Small group, good guidance. The course material is pleasant to work with and well organised. Learned a lot in two days!"
“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.”
“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.”
“An excellent way to get to know Access.”
“A very good training course for learning and working with Access 2003 Basics.”
“Very clear course material and trainer; an instructive course and experience!”
“Definitely take this course. Individual guidance works really well. Highly recommended.”
“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!”
“A very complete course, and in my case with a highly skilled trainer. Prior knowledge of Access is definitely required, otherwise the course would become too complicated. A particular plus is the option to bring your own practical examples on a USB stick or similar, so you can work on them or go through specific issues with the trainer. I found the open learning format pleasant, because you can work at your own pace and have the freedom to skip parts (because you already know how to apply something) or choose your own order for the material to be covered.”
"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."
“My experience with Learnit Training is very positive. Good communication, clear arrangements. The content and delivery of the course were perfectly in order.”
"Very good course. It certainly helps you expand your skills."
“If you really want to learn this, it comes highly recommended. Do take Access for beginners first, so you have a good foundation.”
"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."
“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.”
“Learnit's open learning format works perfectly for me. Everyone can take in the material at their own pace. What's more, several courses can be run at the same time. Our trainer explained things clearly and created a good atmosphere in the group.”
“Great to work through the material and all kinds of exercises independently. The expert trainer is always available if you have questions!”
“My experience with Learnit Training is very positive. Good communication, clear arrangements. The content and delivery of the course were perfectly in order.”
“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."
“Completely lived up to expectations.”
"A good way to improve your software skills independently."
“Instructive and clear course. Also for people who are less interested in computer programmes. The days flew by.”
“A course where time is taken to actually learn something.”
“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!”
“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.”
"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."
"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."
“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.”
"A good way to improve your software skills independently."
"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."