Access Programming with VBA

SpiralTrain BV

In the course Access Programming with VBA you will learn to provide the Microsoft Access Database with extra functionality with Visual Basic for Applications (VBA).

Price

from €1,499

Level

Not specified

Kind

Training

Subject

Automation and IT, Training and education

More information and registration at SpiralTrain BV

Description

Intro VBA The course VBA Access Programming starts with a discussion of the VBA Editor, entering code and executing the code step by step with the debugger. VBA Syntax Next the syntax of VBA is discussed with variables, operators, procedures, functions, parameters, objects and modules. Control Flow Also covered is how to control the output of the code by means of if and else statements, select clauses and for loops. Arrays are then also addressed. Events Events are generated by user interaction such as pressing buttons or entering commands via the keyboard. These events are important for controlling Access and should be handled in event procedures. Forms Additionally attention is paid to how you can give forms and reports more functionality with VBA Access. DAO Finally the Data Access Object model (DAO) and its properties and functions are discussed. With DAO and VBA information can be retrieved from any Access database and the data can be sorted and filtered. With DAO it is also possible to connect to Access databases from Word and Excel with VBA.