VBA deepening for Microsoft Access («A07»)

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:

COURSE
Interface design and process control with Microsoft Access («A05»)
2 days
• Basel, Berne, Geneva, Lausanne, Virtual Training, Zürich
CHF
1'300.–
Learn more

This course is also suitable for users of Access 2013 and 2010.