Course offer

Microsoft Access for users

Querying existing databases

Microsoft Access - Basics

Introduction to relational databases and the creation of simple databases

Microsoft Access - Advanced

Planning and development of complex Access database and introduction to automation

Also as
online course!

Microsoft Access VBA Advanced 1

Duration:	3 days
Target group:	Access database developer
Target:	Deepen the VBA programming knowledge of Access
Prior knowledge:	Access VBA basic knowledge
Content:	Functions and Procedures Creating custom functions Creating custom procedures Data transfer for functions and procedures Error handling debugging program code Error query Access SQL The use of SQL in Access SQL in Basic Code SELECT: Data retrieval INSERT INTO: Append data DELETE: Clear data Working with controls Read and fill list field by code Read and fill combination field by code Data exchange with other Office programs Data transfer to Word Control Word from Access Data transfer to Outlook Control Outlook from Access Automate reports Reporting events Implementation of conditional sections Send reports automatically by e-mail Create user interface Application Configuration Start form Customizing and Extending the Ribbon