Access Advanced course
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.
NRTO quality markFree cancellation up to four weeks before the start, so feel free to book now.
In brief. Access Advanced is a 2-day classroom course. You can take it in Amsterdam, Utrecht, Rotterdam and The Hague, among other locations, or online, in a group of no more than 8 participants. The price is € 1150,- excl. VAT per participant, including course materials, lunch on location and a certificate of attendance. For a team or department we also deliver this course in-company.
- Build advanced forms and reports in Access
- Automate tasks with macros and an introduction to VBA
- Exchange data with Excel, Word, Outlook and SQL Server
- Personal guidance; your own practical examples are welcome
- Training tailored to your version of Access
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.
Description
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.
Topics
- Advanced forms and reports
- List boxes, option buttons and tab controls
- Tab order and expressions
- Creating, testing and running macros
- Adding macro groups and conditions
- Creating and customising toolbars
- Security with passwords and user definitions
- Assigning permissions
- Introduction to VBA
- Exchanging data with Excel, Word and Outlook
- Exchanging data with SQL Server
Result
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.
Target audience
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.
Teaching method
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.
Prior knowledge
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.
Comments
This training course can be taken in various versions. Please indicate whether you use Access 2010, 2013 or 2016.
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
- Cancel
- Free up to four weeks before the start (cancellation terms)
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.
In-company
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.
All start dates
2 training days. Confirmed dates first, then in order of date.
- Mon 12 & Tue 13 October 2026Certain to go ahead Zwolle · 10:00–17:00 Enrol
- Mon 26 & Tue 27 October 2026Certain to go ahead Utrecht · 10:00–17:00 Enrol
- Thu 29 & Fri 30 October 2026Certain to go ahead Rotterdam · 10:00–17:00 Enrol
- Mon 23 & Tue 24 November 2026Certain to go ahead Zwolle · 10:00–17:00Free cancellation until 26 October Enrol
- Mon 9 & Tue 10 November 2026 Arnhem · 10:00–17:00Free cancellation until 12 October Enrol
- Mon 23 & Tue 24 November 2026 Online · 10:00–17:00Free cancellation until 26 October Enrol
- Tue 8 & Wed 9 December 2026 Eindhoven · 10:00–17:00Free cancellation until 10 November Enrol
- Mon 25 & Tue 26 January 2027 Amsterdam · 10:00–17:00Free cancellation until 28 December Enrol
- Mon 8 & Tue 9 February 2027 The Hague · 10:00–17:00Free cancellation until 11 January Enrol
- Mon 1 & Tue 2 March 2027 Zwolle · 10:00–17:00Free cancellation until 1 February Enrol
- Mon 1 & Tue 2 March 2027 Groningen · 10:00–17:00Free cancellation until 1 February Enrol
- Mon 5 & Tue 6 April 2027 Eindhoven · 10:00–17:00Free cancellation until 8 March Enrol
- Mon 3 & Tue 4 May 2027 Utrecht · 10:00–17:00Free cancellation until 5 April Enrol
- Thu 12 & Fri 13 August 2027 Rotterdam · 10:00–17:00Free cancellation until 15 July Enrol
No suitable start date? Send us a date request, and we'll look at the options together.
This course by city
- Access in The Hague2 dates
- Access in Eindhoven4 dates
- Access in Rotterdam4 dates
- Access in Utrecht4 dates
- Access in Zwolle6 dates
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
Access Advanced course: average 8.7 from 8 reviews
“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."
“If you really want to learn this, it comes highly recommended. Do take Access for beginners first, so you have a good foundation.”
“Great to work through the material and all kinds of exercises independently. The expert trainer is always available if you have questions!”
“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 good course that fits perfectly with the practical requirements of developing and maintaining a database in Access.”
"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."
“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 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.”
"A good way to improve your software skills independently."
“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.”
"No"
“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.”
“Excellent course, learned a lot. The exercises are very good. Many of these things can be used for your own applications.”
“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.”
“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.”
“Definitely take this course. Individual guidance works really well. Highly recommended.”
“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.”
“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 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."
“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 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.”
“Instructive and clear course. Also for people who are less interested in computer programmes. The days flew by.”
“I have a very good impression of the course I took with Learnit. The most appealing thing is that you can work through the material at your own pace. So you aren't dependent on fellow participants. If you have any questions, a skilled and very friendly trainer is on hand to answer them.”
“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 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.”
"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."
“A very good course that fits perfectly with the practical requirements of developing and maintaining a database in Access.”
“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.”
"Very good course. It certainly helps you expand your skills."
“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.”
"A good way to improve your software skills independently."
“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.”
“If you really want to learn this, it comes highly recommended. Do take Access for beginners first, so you have a good foundation.”
“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.”
"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 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.”
“Great to work through the material and all kinds of exercises independently. The expert trainer is always available 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.”
“good course, learned a lot from it”
"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."
"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."
“Completely lived up to expectations.”
“Very clear course material and trainer; an instructive course and experience!”
"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."
“Learned a great deal in a short time, which I can also apply straight away in practice”
"Very good course. It certainly helps you expand your skills."
“Definitely take this course. Individual guidance works really well. Highly recommended.”
Training formats
Classroom
2 days€ 1150,-- 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
Frequently asked questions
Can I cancel free of charge?
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.
What will I learn in this course?
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.
Who is this course for?
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.
What prior knowledge do I need?
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.
What does the course look like?
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.
What is the delivery format?
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.
Who teaches the course?
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.
What do I get after the course?
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.
How can I prepare?
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.
What if I can't attend?
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.
Do I receive a certificate?
Yes, on completion you receive a Learnit certificate as proof of participation.
How do I register?
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.
What does the course cost?
You will find the current price at the top right of the course page.
Others also viewed
Want more? Your next course
Read our blog
Guaranteed to run: Mon 12 & Tue 13 October 2026 in Zwolle
This date already has enough participants. Free cancellation up to four weeks before the start, so you can secure a place now.