Business solutions for you portfolio


Company: Novartis AG, Basel

Technology: Oracle, PLSQL, SQL, MS Access, VBA

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Sep 2003 – Jul 2004

Cost: no details

Creation of a Microsoft Access application that obtains its data from an Oracle database, calculates the life cycles of the individual products of the company Novartis Pharma and supplements or refines existing data. Subsequently, the data is exported into reports, which are realised in Microsoft Excel. The application is realised using Oracle and PL SQL as well as SQL, Microsoft Access and VBA as well as SQL and Microsoft Excel and VBA. The final product is the finished reports concerning the life cycles of the individual products of the company Novartis Pharma.

  • Analysis of the existing application.
  • Requirement engineering.
  • Data model creation using Dezign.
  • Realised using Oracle, Microsoft Access and Microsoft Excel.
  • Linked data from Oracle into a Microsoft Access database (Views).
  • Creating the queries (SQL) for the data transfer via ODBC.
  • Programming of the assistants to create the reports.
  • Wizards (VBA) control the filtering, refining and sorting of the data.
  • Exporting the data (entire table) to Excel.
  • Calculating and forming the graphical representation (VBA).
  • Testing and documentation (user and technical).
Back to the portfolio
Order a similar project
Order a project

+41 (0)44 586 53 45
+41 (0)76 737 00 84
+41 (0)77 915 25 52

Order a project
Tell us what kind of project you want to do.
Want to order
Upload your brief
For message
Submit project request

User Agreement

With this questionnaire (application) I officially express my consent to the processing (collection, systematization, accumulation, storage, clarification, (updates, changes), use, distribution (including transmission), depersonalization, blocking and destruction), including automated, my personal data specified in this Questionnaire (application), in accordance with the requirements of the law "On personal data".

The personal data specified by the client are provided for the purpose of communication with the client, as well as for informing about other products and services. Consent is provided from the moment of filling of this application for the entire life of the client.

This consent can be revoked by the client upon submission of an application in simple writing in accordance with legal requirements.