In the Access Advanced course you will learn to create advanced forms and reports, automate with macros and VBA, set up security and exchange data with Excel, Word, Outlook and SQL Server.
Free cancellation up to four weeks before the start, so feel free to book now.
In brief. Access Advanced is a classroom-based course lasting 2 days. You can attend it in Amsterdam, Utrecht, The Hague and Rotterdam, among other locations, or online, in a group of up to 8 participants. The price is EUR-teken 1150 excl. VAT per participant, including course materials, lunch on site and a certificate of attendance. We also run this course for teams or departments in-company.
Do you want to get more out of Access than just basic databases and simple queries? In this follow-up course you take the step towards real development work. You will learn how to set up relationships between tables intelligently, build complex forms, refine reports and automate tasks with macros and VBA. You will also see how Access works together with other Office programmes and with a SQL server. By the end of the course you will have a database that does exactly what you want.
The Access Advanced course is intended for anyone who has mastered the basics of Access and wants to take the next step. You go deeper into designing databases with relationships, you build advanced forms with combo boxes, option buttons and tab controls, and you learn how to use expressions to display data intelligently.
A large part of the course is about automation. You learn to create, test and run macros, you work with macro groups and add conditions. After that you get to know VBA, so you gain even more control over your database. Security is also covered: you set passwords, define users and assign rights.
Finally, you discover how to make Access work together with Excel, Word and Outlook and how to exchange data with an SQL server. You may bring practical examples from your own work, so that the exercises match what you do on a daily basis.
For teams and organisations. If your department works with Access databases, we also run this follow-up course in-company. In consultation, we work with examples from your own practice.
After this course you will build complex forms and reports in Access and set up relationships between tables in a considered way. You automate recurring tasks with macros and you have a first grounding in VBA. You secure your database with passwords and user rights and you know how to exchange data with Excel, Word, Outlook and a SQL Server. This allows you to use Access as a powerful and flexible tool in your work.
The course is intended for anyone who already works with Access and wants to get more out of the programme. Think of employees who manage or develop databases themselves, administrative professionals who want to link data from different sources, and analysts who want to refine reports and forms. If you want to use Access to automate processes in your department, you are also in the right place.
The course is also suitable for application managers and key users who maintain and extend an existing Access database in their department, for example for a registration system or stock management.
The course is classroom-based and highly practical. You work in small groups, so the trainer has time for your questions and examples. At the start, the trainer discusses your starting level and learning objectives, so that the focus is on what matters to you. You alternate short explanations with plenty of exercises at the computer. You are welcome to bring your own practical examples, so that you can apply what you learn directly to your own work.
For this course you need prior knowledge at the level of Access Basics. You already work with tables, simple queries, forms and reports. Experience with other Office programmes such as Excel is an advantage, but not a requirement.
This training course can be taken in various versions. Please indicate whether you use Access 2010, 2013 or 2016.
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.
Would you like to organise this training for a whole group or several groups? This can be cost-effective. For example, we can tailor the content entirely to your organisation, and training a whole group is also cheaper.
Are you looking at large numbers of participants or a complete academy? That involves a great deal. Consider planning and communication, for example, or identifying and agreeing the objectives and content of the training. Or differences in level, feedback mechanisms and safeguarding. Fortunately, Learnit has extensive experience in this field (more than 25 years) and we are happy to help you through this process.
2 training days. Confirmed dates first, then in order of date.
No suitable start date? Send us a date request, and we'll look at the options together.
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.
“Great to work through the material and all kinds of exercises independently. The expert trainer is always available if you have questions!”
“A very good course that fits perfectly with the practical requirements of developing and maintaining a database in Access.”
“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.”
“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.”
“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. This follow-up course ties in well with the basic course."
"The course caters for all kinds of levels, from beginners to advanced users. The trainer responds to that very well and you feel at home in the group straight away, despite the differences in level. I can genuinely recommend the course."
“If you really want to learn this, it comes highly recommended. Do take Access for beginners first, so you have a good foundation.”
“A very good course that fits perfectly with the practical requirements of developing and maintaining a database in Access.”
"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."
“My experience with Learnit Training is very positive. Good communication, clear arrangements. The content and delivery of the course were perfectly in order.”
"Good course. This follow-up course ties in well with the basic course."
“If you really want to learn this, it comes highly recommended. Do take Access for beginners first, so you have a good foundation.”
"The course caters for all kinds of levels, from beginners to advanced users. The trainer responds to that very well and you feel at home in the group straight away, despite the differences in level. I can genuinely recommend the course."
“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.”
"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."
"A good way to improve your software skills independently."
"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."
“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.”
“Clear course material that you can work through at your own pace.”
"No"
“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.”
"Very good course. It certainly helps you expand your skills."
“Very clear course material and trainer; an instructive course and experience!”
"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."
“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 course where time is taken to actually learn something.”
“If you really want to learn this, it comes highly recommended. Do take Access for beginners first, so you have a good foundation.”
“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.”
“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.”
“good course, learned a lot from it”
"This course and trainer made clear to me what I can do with Access and, above all, what I cannot. Excellent result."
“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 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.”
“An excellent way to get to know Access.”
“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.”
“A pleasant introduction to SQL under the guidance of a knowledgeable and driven trainer.”
“To the point training, with your own learning objectives taking centre stage.”
"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."
“Learned a great deal in a short time, which I can also apply straight away in practice”
“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 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.”
“A very good training course for learning and working with Access 2003 Basics.”
“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”
“My experience with Learnit Training is very positive. Good communication, clear arrangements. The content and delivery of the course were perfectly in order.”
“Excellent structure. Immediately applicable. Highly recommended!”
“Very clear course material and trainer; an instructive course and experience!”
“Great to work through the material and all kinds of exercises independently. The expert trainer is always available if you have questions!”
“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.”
"This course and trainer made clear to me what I can do with Access and, above all, what I cannot. Excellent result."
Yes. Up to four weeks before the first day of the course you can cancel free of charge, without giving a reason. You then receive a credit note or, if you have already paid, a refund. If you cancel later, you pay part of the course fee: 25% between four and two weeks before the start, 75% in the two weeks before it and 100% in the final week. Moving to another start date is free of charge up to two weeks before the start, after that 50%. Sending a colleague in your place is always possible. Read the cancellation terms.
You learn the advanced features of Access. Think of complex forms and reports, relationships between tables, expressions and automating tasks with macros and VBA. You also learn to secure your database and exchange data with Excel, Word, Outlook and a SQL Server.
The course is suitable for anyone who already works with Access and wants to get more out of the programme. For example, employees who manage or develop databases, administrative professionals who want to link data and analysts who want to refine their reports.
You need prior knowledge at the level of Access Basics. You already work with tables, simple queries, forms and reports. Programming experience is not required.
You alternate short explanations with plenty of exercises at the computer. At the start of the course the trainer discusses your starting level and learning objectives, so that the focus is on what matters to you. You are welcome to bring your own practical examples.
The course is classroom-based, in a small group. This leaves plenty of room for personal questions and guidance. You work along actively on your own computer or laptop.
You will be guided by a skilled and personable trainer with extensive experience in Access and database development. The trainer tailors the content to the level and wishes of the group.
You will receive a Learnit certificate as proof of participation. You will also receive course materials that you can continue to use as a reference work after the course.
No specific preparation is needed. It is useful, though, to think beforehand about what you want to achieve with Access and which questions or practical examples you would like to bring along. That way the trainer can tailor the content even more precisely.
Unable to attend after all? Then contact us as soon as possible. We will reschedule you for another date in consultation, so that you do not have to miss anything.
Yes, on completion you receive a Learnit certificate as proof of participation.
You register via the course page on our website. Choose a date and fill in your details. During registration you can indicate which version of Access you use, so that we can prepare the right materials for you.
You will find the current price at the top right of the course page.
This date already has enough participants. Free cancellation up to four weeks before the start, so you can secure a place now.