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