Skip to main content

Access: VBA Programming

Version: Office 365
Duration: 3 days
Price incompany training: € 3750 VAT excl. / Terms for incompany training.

Description

Make impressive applications with our Access VBA Programming course

Automating your Access databases with macros? It’s a possibility. But it won’t be long before you come up against the limitations of macros. Visual Basic for Applications (VBA) is the solution you’re looking for!

In our Access VBA Programming course, you’ll get to know the basic principles of Visual Basic. And from there, we will show you how to implement your knowledge in Access. Are you looking to make impressive applications from your database with VBA? That seamlessly respond to the actions of the end-user? Just follow our Access VBA Programming course and you’ll discover how useful it is to have a tool like VBA in your toolbox.

Objectives

What will you learn in the Access VBA Programming course?

Ready for your Access VBA programming course?You’ll soon:

  • know the foundations of Visual Basic by heart;
  • effortlessly automate forms and reports;
  • work smoothly with objects in forms or reports;
  • easily write code to request data.

Target Group

Anyone who wants or needs to automate their database with VBA.

Prerequisites

Participants have a good knowledge of Access (tables, queries, forms and reports). There is no prior knowledge of Visual Basic required.

Content

Visual Basic

  • The VBE (Visual Basic Editor)
  • Modules
  • Variables (Boolean, Integer, Long, Single, Double, Date, String, etc.);
  • Procedures and functions;
  • Inputbox and Msgbox;
  • Decision structures (If … End If, Select case, End select);
  • Loops (For… Next, For each … Next, Do … loop until, Do… loop while, Do until… loop, Do while…loop);
  • Error Handling
  • Working with various controls in forms and reports;
  • Actions, properties and events of controls;
  • Changing properties of controls in run-time;
  • Working with collections (Forms, Reports, Controls).
  • Introduction to DAO;
  • Working with DAO objects and collections (Recordsets, Querydefs, TableDef);
  • Record sets (requesting data via code, adding records);
  • TableDefs (changing tables);

Access objects

  • Working with various controls in forms and reports;
  • Actions, properties and events of controls;
  • Changing properties of controls in run-time;
  • Working with collections (Forms, Reports, Controls).

Data Access Objects

  • Introduction to DAO;
  • Working with DAO objects and collections (Recordsets, Querydefs, TableDef);
  • Record sets (requesting data via code, adding records);
  • TableDefs (chanigng tables);
  • QueryDefs (parameter queries by filling in code, queries by making code, etc.).
View all our trainings

Request a quote

"*" indicates required fields

Address*
Name*
In which language(s) do you wish to organise this training?
You apply for this course as:
Do you want the training online or on-site?