Business solutions for you portfolio


Company: Swiss Life, Zurich

Technology: MS Access, VBA.

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Sep 2004 – Dec 2004

Cost: no details

Creation of a budget calculation for the individual areas of the company Swiss Life in Zurich. Data is imported from files, refined and completed, calculated and output in the form of reports in Excel. The application is realised using Microsoft Access, SQL, VBA and Microsoft Excel. A corresponding application is made available for each corporate region and corporate division.

  • Revision of the already existing application for calculating the budgets for calculating the individual products.
  • Realised using Microsoft Access 97 and Microsoft Visual Basic for Application.
  • Extending the existing application for use in all countries.
  • Data is imported by means of CVS files through batch processing.
  • Data is refined and supplemented.
  • Consolidation across the entire company structure based on criteria is possible.
  • An export of the data into Excel files is realised for the group management.
  • 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.