Microsoft - Project Monitoring

MS Access, VBA, VB 6.0, MS Excel, MS Word, Outlook, MS SQL Server

UBS AG, Zürich

PROJECT LINK: Not available
People in the PROJECT: Stefan Troehler
PROJECT Duration: 12 months
PROJECT Value: SFR. 200'000.00

Project portfolio

HOURS REQUIRED

CUP OF COFFEE

LINES IN THE CODE

EXPERTS IN THE PROJECT

Creating a project monitoring system.
Employees record their working hours at the task level of the project (online).
The service catalog required for this is made available by means of a Microsoft project file at project level.
The times recorded by the employees are displayed in consolidated form on a daily basis and transferred to a Microsoft Access 97 database.
In the application (Microsoft Access 97) there is a synchronization with the MS project file and the times effectively worked by the employees are entered in the Microsoft project file.
Deviations from planning are shown immediately and measures are proposed automatically.
Requirement Engineering.
Create a data model using Dezign.
Implementation of customer requirements using Microsoft Access 97.
Microsoft Visual Basic for Application.
Providing synchronization (Microsoft Access 97 and Microsoft Project).
Data transfer from the time recording.
Testing and documentation (user and technical).