Business solutions for you portfolio


Company: t–cos GmbH, Feldbrunnen

Technology: MS SQL Server, MS Access, VBA, T–SQL.

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Feb 2004 – Dec 2005

Cost: no details

Implementation of a service recording for the company t-cos Feldbrunnen. In a first prototype, Microsoft Access is used as the database, and the user interfaces are already developed in this prototype using VB .NET. In version 2, the Microsoft Access database is replaced by a Microsoft SQL server and a large part of the logic is transferred from the user interfaces to the backend in the form of stored procedures and functions.

– Developing a performance recording system as a supplement to the worldwide patented
– patented systems of the company t-cos GmbH (working time recording using
– biometric data).
– Times recorded by biometric data are assigned to a project or an order using a service catalogue.
– Services defined in this way are in turn assigned to a client via project or order.
– Client administration is carried out via client administration.
– The time recording data is stored in a Microsoft SQL server.
– The service data is stored in a Microsoft Access 2000 database.
– There is an automated synchronisation (trigger) between time recording data and performance data.
– The user interfaces are developed using VB.NET.
– Requirement engineering, data model by means of design.
– Implementation of customer requirements using Microsoft SQL Server, Microsoft Access 2000, Microsoft Visual Basic for Application, T-SQL and Microsoft VB.NET.
– 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

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.