Access: VBA Programming

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 (chanigng tables);
  • QueryDefs (parameter queries by filling in code, queries by making code, etc.).

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

Request an offer



Share this course on Facebook, Twitter, LinkedIn or e-mail

This training as in-company training?

Would you like to organize this training course for your employees? At your offices and/or with adapted content? We transform your requirements into the perfect solution.

Request