Business solutions for you portfolio


Company: UBS AG, Zurich

Technology: MS Access, VBA, SQL, MS Excel, VB 6.0.

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Jan 2001 – Jan 2001

Cost: no details

Creation of a project monitoring application for the office of the Board of Directors of UBS AG. Projects are managed in terms of budget and expenditure and are compared with the actual financial data. The application was developed using Microsoft Access, VBA, SQL, Microsoft Excel and VB 6.0.

  • Create a system for project monitoring.
  • Employees record their working hours at the task level of the project (online).
  • The required performance catalogue is made available at project level by means of a Microsoft project file.
  • The times recorded by the employees are consolidated and displayed daily and transferred to a Microsoft Access 97 database.
  • In the application (Microsoft Access 97) a synchronisation with the MS project file takes place and the effectively worked times of the employees are entered into the Microsoft project file.
  • Planning deviations are immediately displayed and measures are suggested automatically.
  • Requirement Engineering.
  • Data model creation using Dezign.
  • Implementation of customer requirements using Microsoft Access 97.
  • Microsoft Visual Basic for Application.
  • Providing the synchronisation (Microsoft Access 97 and Microsoft Project).
  • Data transfer from time recording.
  • Testing and documentation (user and technical).
Back to the portfolio
Order a similar project
Order a project

+41 (0)44 586 53 45
+41 (0)76 737 00 84
+41 (0)77 915 25 52


[email protected]

Order a project
Tell us what kind of project you want to do.
Want to order
Upload your brief
For message
Submit project request

User Agreement

With this questionnaire (application) I officially express my consent to the processing (collection, systematization, accumulation, storage, clarification, (updates, changes), use, distribution (including transmission), depersonalization, blocking and destruction), including automated, my personal data specified in this Questionnaire (application), in accordance with the requirements of the law "On personal data".

The personal data specified by the client are provided for the purpose of communication with the client, as well as for informing about other products and services. Consent is provided from the moment of filling of this application for the entire life of the client.

This consent can be revoked by the client upon submission of an application in simple writing in accordance with legal requirements.