microsoft
Picasso – Microsoft Access, VBA, Microsoft Excel, SQL
Picasso is the corporate structure of the Bankverein. Since there were considerable adjustments to this company structure during the time of the merger of UBS AG and the Bankverein, the existing Microsoft Excel solution had to be replaced by a dynamic Access application. The aim was to be able to make manipulations to the tree structure quickly and easily. The application was implemented using Microsoft Access, VBA as well as SQL.
Crystal Reports – Microsoft Access, VBA, Crystal Reports, SQL
Project support: The initial situation is an Access database with an Access front-end and an Access back-end implemented logic using Visual Basic for Application, which is now to be extended by dynamic reports created by Crystal Reports. The task here is to train and support the developers who design and implement these reports.
Central Access Management - Microsoft Access, VBA, SQL
Developing an Access administration: Using an Access database, new Microsoft Access applications can be generated through table entries. The values read from the tables form the properties of the individual objects such as forms, queries and reports. A standard is defined as to how these applications or how the future user interfaces are to look. For each of the 120 applications of the central laboratory in Belgium, a migration of the applications can thus be carried out quickly and efficiently.