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

Prijs

vanaf € 1.499

Niveau

Niet opgegeven

Soort

Training

Thema

Automatisering en ICT, Opleiden en onderwijs

Meer informatie en aanmelden bij SpiralTrain BV

Beschrijving

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.