Creation of a Microsoft Access application, which gets its data from an Oracle database, calculates the life cycles of the individual Novartis Pharma products and supplements or refines existing data. The data is then exported to reports that are implemented in Microsoft Excel. The application is implemented using Oracle and PL SQL as well as SQL, Microsoft Access and VBA as well as SQL and Microsoft Excel and VBA. The end product is the finished reports on the life cycles of the individual Novartis Pharma products.

• Analysis of the existing application.
• Requirement Engineering.
• Create a data model using Dezign.
• Realized using Oracle, Microsoft Access and Microsoft Excel.
• Data from Oracle linked into a Microsoft Access database (Views).
• Creation of queries (SQL) for data transfer using ODBC.
• Programming the wizards for creating the reports.
• Wizards (VBA) control the filtering, refining and sorting of the data.
• Export of the data (entire table) to Excel.
• Calculation and creation of the graphic representation (VBA).
• Testing and documentation (user and technical).