top of page
Whiteboard mit Beschriftung TEAMS

TEAMS

Microsoft 365 offers extensive tools for communication and collaboration in workgroups. 


In addition to a theoretical introduction, during the seminar you will learn how to create working groups and channels, conduct chats and online meetings or install and use selected apps. 
 

Depending on the requirements, the basic seminar can be included or
two
-day seminar can be held.

  • ACCESS - basic seminar (2 days)
    seminar objective The seminar is aimed at employees who use Access to organize, store and evaluate operational data or who work with existing databases. In addition to the general structure of a database, you will receive all the information you need to create Access databases, define tables and relationships and post data evaluate different criteria. and output. Content Normalization and data modeling Table design, data types and properties Data entry, data import and export Create and edit relationships Create select queries, simple SQL expressions Use forms as user interface Create forms and reports Tips and tricks for using Access
  • ACCESS - advanced seminar (2 days)
    seminar objective As part of the seminar, you will learn about other ways of adapting Access to your requirements. This applies in particular to the creation of more complex queries and the design of forms and reports. You will get additional information about automation with macro instructions and managing your database. Content Discussion of practical questions, refresher basic knowledge Create queries with functions Create queries with query wizard Creating action queries Incorporate Access data into Excel Create and edit forms Create and edit reports Create macro statements Database administration and support
  • ACCESS - Application Development with VBA (3 days)
    seminar objective The programming language Visual Basic for Applications (VBA) included in Access offers the possibility to develop tailor-made applications through automation. In this seminar you will get to know the structure and programming options of VBA. Content Introduction to Access Programming The VBA development environment Basic program elements Program flow control Arrays and advanced language elements Event-driven programming Troubleshooting and Debugging Working with the Access Object Model Access to forms and reports Data access with VBA and ADO Use of SQL statements in VBA Design application interfaces Communication with Office applications
  • ACCESS - Workshop application development with VBA
    seminar objective The programming language Visual Basic for Applications (VBA) included in Access offers the possibility to develop tailor-made applications through automation. The topics of the VBA workshop can be set according to your requirements. This includes the deepening of the topics of the VBA basic seminar as well as the discussion of additional topics. If you have already developed applications, they can be used during the workshop. Content by arrangement

Seminar overview

Please note that the content and topics may differ in some cases, depending on the version you are using. Choose  here to get your custom quote.

bottom of page