portfolio

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.

Lessons at the SIZ in Microsoft applications such as Microsoft Excel, Microsoft Word, Microsoft PowerPoint and Microsoft Access. The lessons cover everything from installing the programme and using it to programming simple and complex functionalities using Microsoft VBA. Additional assignments as an examination expert for the SIZ final examination.

Creation of an application for managing folders using Microsoft Access for the corporate management of the Adecco company. The folders, their contents, the storage location in the form of the shelf and the exact location on the shelf are catalogued. An interface for importing existing Excel files is implemented. The application is developed using Microsoft Access and VBA.