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

• Revision of the existing application for calculating the budget for calculating the individual products.
• Realized using Microsoft Access 97 and Microsoft Visual Basic for Application.
• Extending the existing application for use in all countries.
• Data are imported using CVS files using batch processing.
• Data are refined and supplemented.
• Consolidation across the entire corporate structure is possible based on criteria.
• The data will be exported to Excel files for the group management.
• Testing and documentation (user and technical).