top of page
Whiteboard mit Beschriftung Access

Access

databases

Access is one of the most popular database software for developing single or multi-user applications. This includes the development of your own database structures as well as the integration of external data such as Excel, CSV or SQL data.

With queries, forms and reports, Access offers the possibility of developing cost-effective and powerful applications.  Through the connection to Excel, data from Excel can be queried very easily via Access, displayed in forms or output in report form .

The programming language VBA enables the development of complex applications. 

  • 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 topics

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

bottom of page