Access

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

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

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

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