The illustrations were created in cooperation between humans and artificial intelligence. They show a future in which technology is omnipresent, but people remain at the center.
AI-generated illustration
.svg)
.svg)
€ 1.190,-
plus VAT.
€ 1.416,10
incl. VAT.
Booking number
41163
Venue
Online
.svg)
2 dates
€ 1.190,-
plus VAT.
€ 1.416,10
incl. VAT.
Booking number
41163
Venue
Online
2 dates
plus VAT.
incl. VAT.
Booking number
Venue
0 Dates
Become a certified
Machine Learning Engineer
Machine Learning Engineer
This course is part of the certified Master Class "Machine Learning Engineer". If you book the entire Master Class, you save over 15 percent compared to booking this individual module.
To the Master Class
In-house training
In-house training for your Employees only - exclusive and effective.
Inquiries
In cooperation with
In addition to 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 Microsoft Access course.
Contents
1. repetition of basic VBA knowledge
- Working with the Visual Basic Editor
- Procedures and functions
- Instructions, jumps and loops
2. forms
- Placing and formatting control elements
- Events
- Working with the DoCmd object
- Link overview form / detail form
- Sort and filter form contents
- Combo boxes
- Option groups
3. access to tables and queries
- Moving in data records
- Edit data with the DAO access method
- Add, change, delete data records
- Editing data with the ADO access method
4. SQL
- Basics of SQL
- Combining VBA and SQL
5. office programming
- Transferring data to Word or Excel
- Importing data from Excel or text files
6. reports
- Design reports dynamically
7. data macros
- Overview
Your benefit
Optimize everyday processes and increase the productivity of Access 2016 databases through clever programming and automation, e.g. connection to various data sources. Targeted further development of existing Access skills
trainer
Daniel Lisak
Methods
This course consists of training training and is led by a trainer who supervises the participants live. Theory and practice are taught with live demonstrations and practical exercises. The video conferencing software Zoom is used.
Final examination
Recommended for
Database developers and power users who want to create databases with Access and optimize them using programming.
.svg)
