VBA course for Access macro programming - high-level training - course contents
Our intensive VBA training in macro programming for Access teaches you to write advanced macros to automatize work and extend Access features by programming add-ins and functions. VBA stands for Visual Basic for Applications, the programming language for Microsoft Office applications.
Learn to develop Access applications and programs with advanced features. Automate your work by learning how to program data import and export, data gathering and consolidation, integration with Excel, other Office software, as well as Internet services. Program forms for more user-friendly data entry.
You will learn how to use the following Access VBA features, functions and concepts:
- Setup Access in developer mode, ready for VBA programming
- Get to know VBE, the visual basic editor environment
- Create procedures and new Access database functions
- Overview and use available programming objects in Access and the object hierarchy
- Learn the difference between objects, methods and properties (With...)
- Work with forms, buttons, labels and text (graphics, user controls, UserForm, events)
- Use events to schedule program execution at a chosen time and date
- Declare and use variables in the right way (Dim, As)
- Manage and control program workflow (If... End..., Select Case... End, For... Next)
- Importing data and reading files
- Accessing, updating and deleting data through ADO
- Interacting with other Office programs through VBA macros
- Finding bugs and stepping through code (breakpoints, debugging)
- Catch and handle runtime errors
- Package program code as add-ins for distribution to clients and colleagues
We can also aid you in finding answers to specific questions, explore areas of particular interest and delve into VBA-related problems.
