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.

8.7 from 8 reviews 4,6 on Google NRTO quality mark

Free cancellation up to four weeks before the start, so feel free to book now.

For a team or department? Arrange your own group, at your premises or ours. In-company for your team

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.

  • 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.

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.

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.

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.

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.

Request a quote More about Access Advanced in-company

All start dates

2 training days. Confirmed dates first, then in order of date.

  • Tue 8 & Wed 9 December 2026Certain to go ahead Eindhoven · 10:00–17:00 Enrol
  • Wed 16 & Thu 17 December 2026Certain to go ahead Groningen · 10:00–17:00 Enrol
  • Mon 8 & Tue 9 February 2027Certain to go ahead The Hague · 10:00–17:00Free cancellation until 11 January Enrol
  • Mon 1 & Tue 2 March 2027Certain to go ahead Online · 10:00–17:00Free cancellation until 1 February Enrol
  • Tue 2 & Wed 3 March 2027Certain to go ahead Groningen · 10:00–17:00Free cancellation until 2 February Enrol
  • Mon 23 & Tue 24 November 2026 Zwolle · 10:00–17:00 Enrol
  • Tue 8 & Wed 9 December 2026 Online · 10:00–17:00 Enrol
  • Mon 4 & Tue 5 January 2027 Utrecht · 10:00–17:00Free cancellation until 7 December Enrol
  • Mon 25 & Tue 26 January 2027 Amsterdam · 10:00–17:00Free cancellation until 28 December Enrol
  • Tue 2 & Wed 3 March 2027 Zwolle · 10:00–17:00Free cancellation until 2 February Enrol
  • Mon 5 & Tue 6 April 2027 Eindhoven · 10:00–17:00Free cancellation until 8 March Enrol
  • Mon 19 & Tue 20 April 2027 Zwolle · 10:00–17:00Free cancellation until 22 March Enrol
  • Mon 19 & Tue 20 April 2027 Groningen · 10:00–17:00Free cancellation until 22 March Enrol
  • Thu 19 & Fri 20 August 2027 Rotterdam · 10:00–17:00Free cancellation until 22 July Enrol
  • Thu 9 & Fri 10 September 2027 Rotterdam · 10:00–17:00Free cancellation until 12 August Enrol

No suitable start date? Send us a date request, and we'll look at the options together.

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
Request a quote No obligation, an adviser will be in touch shortly How in-company works

What others say about this course

8.7
Access Advanced course: average 8.7 from 8 reviews

“Great to work through the material and all kinds of exercises independently. The expert trainer is always available if you have questions!”

I.K. Geuzenbroek
TU Delft
9.1

“A very good course that fits perfectly with the practical requirements of developing and maintaining a database in Access.”

H. de Jong
Diamond Genetics
9.0

“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.”

T. Sassen
Cromaflo Technologies B.V.
8.7

“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.”

Roy Delhaye8.2

“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.”

G.J. Scholten
Nijland B.V.
8.4

"Good course. This follow-up course ties in well with the basic course."

J. Rensen
Shell Pensioenbureau Nederland B.V.
8.0

Training formats

Classroom

2 days€ 1150,-
  • Pleasant venue with a good trainer
  • Small groups
  • Inspiring and motivating
Choose a date

Online

2 days€ 980,-
  • Online with a trainer
  • Personal
  • Practical and interactive
Choose a date

In-company

Bespoke trainingOn request
  • 100% for your group
  • Bespoke training
  • At your place or ours
View in-company

Workshop

Up to 4 hours for groupsOn request
  • Suitable for events
  • Interactive and inspiring
  • Large groups too
Request a quote

Private training

At our place or yoursOn request
  • 100% just for you
  • Achieve a lot in little time
  • Whenever you want
Request a quote

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.

Does this course also teach me to program in VBA?
You are introduced to VBA and lay a first foundation. Most of the automation is done with macros. It is not a full VBA programming course.

Guaranteed to run: Tue 8 & Wed 9 December 2026 in Eindhoven, also available online

This date already has enough participants. Free cancellation up to four weeks before the start, so you can secure a place now.

€ 1150,-excl. VAT · guaranteed to run on Tue 8 Dec
Choose a date