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 2

Duration:	3 days
Target group:	Access database developer
Target:	Deepen the VBA programming knowledge of Access
Prior knowledge:	Access VBA knowledge
Content:	Graphical user interface Advanced programming of controls, forms and reports Integrated controls and ActiveX controls (status bar) In-depth knowledge of the relevant objects and corresponding events Program-controlled sending of reports as PDFs via e-mail Advanced database programming Creating and changing schema objects with ADOX Object-oriented interface for safety-relevant tasks Other data providers and access to external formats Data macros SQL server Access as front-end for powerful applications Client/Server database development Access projects Special features and tips for migrating an Access application to the SQL Server Programming interfaces Extended access to the Windows API, the clipboard and the FilesystemObject Automated data exchange with MS-Excel, MS-Outlook Programming the Ribbon and Backstage View Adapting the Access interface for own extensions/applications using VBA and XML