On Calls – Microsoft Access, VBA

Company: City Bank, Zurich

Technology: MS Access, VBA.

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Feb 2001 – Oct 2001

Cost: no details

Create or further develop an application for the administration of support tickets. The application was created using Microsoft Access and VBA and the task is to adapt it to the new requirements of the business. Implementation using Microsoft Access and VBA.

• Extending an existing Microsoft Access 97 application to manage customer calls (support).
• The existing application had to be extended with new functionality.
• The background of this extension was the creation of a detailed report system.
• The existing application was realised using Microsoft Access 97.
• Up to this point, data entry was done manually. This function was replaced with the extension and the data is now taken directly from the ticket system and imported into Microsoft Access 97.
• Further 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
• Testing and documentation (user and technical).