ZFS - Microsoft Access, VBA, Microsoft Excel, SQL Double function as project manager
Company: Zürich Versicherung, Schlieren
Technology: MS Access, VBA, MS Excel, SQL.
Link: Not available
People in the project: Stefan Tröhler
Implementation period: Apr 2005 – Jul 2005
Cost: no details
Creation of the ZFS application to manage the tickets of Zurich Insurance. An MS Access solution serves as the database and the frontend and forms are implemented using Access Forms and VBA. Logic is also implemented using VBA.
- Data is transferred directly from the ticket system (Seapine).
- Data is imported into Microsoft Access 2000.
- Various functions regarding data evaluation and other special functionalities such as the duration until a ticket was processed, the costs for processing a ticket or the ranking of processed tickets were newly realised.
- Provision of reports (Microsoft Access 2000).
- Provision of consolidated evaluations (Microsoft Excel).
- Testing and documentation (user and technical).