Database Solution for Controlling

Design and coding of a database solution for controlling for a publishing house, based on previously used Excel spreadsheets and formulas. Compared to Excel the transformation to a an SQL-Server database performs better particularly in higher data consistency and protection against erroneous user input of data.

• flexible object-oriented data model, extensibility via custom front-end administration interface

• development of a formula machine within the SQL-database to calculate special client-supported formulas
• comprehensive data consistency safeguarding, multilevel privilege system

• archiving functions in accounting periods

• extensive statistics and reporting functionality for next level management

• import modules interfacing to accounting and financial departments
• testing mode database extension for case studies

• client/server solution based on MS-Access/SQL-Server