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
Back to the main page
| 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
|
Course dates Microsoft Access VBA Advanced 2
