Course
VBA deepening for Microsoft Access («A07»)
Besides object-oriented and event-driven programming with Visual Basic for Applications (VBA), data handling via DAO (Data Access Objects) and ADO (ActiveX Data Objects) is a main topic of this course.
Duration
2 days
Price
1'490.–
Course documents
Digital courseware
Course facts
- Optimising daily processes and increasing the productivity of Access 2016 databases through clever programming and automation, e.g. connecting to different data sources.
- Developing existing Access skills
1 Repetition of the VBA basic knowledge
- The Visual Basic Editor
- Procedures and functions
- Branches and loops
2 Forms
- Add and format controls
- Events
- The DoCmd object
- Link overview form / detail form
- Sort and filter form contents
- Combo boxes
- Option groups
3 Access to Tables and Queries
- Navigating through Record Sets
- Editing data using the DAO access method
- Adding, modifying and deleting records
- Editing data using the ADO access method
4 SQL
- SQL basics
- Combining VBA and SQL
5 Office Programming
- Export Data to Word or Excel
- Import Data from Excel or Text Files
6 Reports
- Dynamic reports
7 Data Macros
- Overview
This course is aimed at database developers and power users who create databases with Access and want to optimize them by programming.
Attendance of the following course or equivalent knowledge is required:
This course is also suitable for users of Access 2013 and 2010.