Prodiance Database IQ:
Change Management for Microsoft Access Databases
Access Databases and User-developed Applications With higher levels of scrutiny being placed on financial statements, senior executives and auditors are taking action to place new controls over key financial data created in spreadsheets, Microsoft Office Access databases, and other user-developed applications. The reality is that end users with little or no programming experience can develop and deploy powerful business and financial applications with these tools without any support from IT. As such, uncontrolled spreadsheets and Access databases can expose organizations to significant business risks because they are often absent traditional IT controls such as security and access control, version control, input control, change control, backup and archival, documentation, analytics and others.
Establishing Access Database Controls To address these risks, organizations first need to understand their critical spreadsheet and Access database population and implement automated controls to ensure they remain trusted sources of information while satisfying corporate and regulatory compliance mandates. The Prodiance Spreadsheet Compliance Edition provides a comprehensive set of server-side controls for critical spreadsheets and Access databases, and now there is a powerful new tool to compare and track changes to Microsoft Office Access Databases on the desktop.
Prodiance Database IQ Prodiance Database IQ is a powerful tool to help organizations automate change management and for critical Microsoft Office Access databases. Prodiance Database IQ incorporates the following key features:
- Compare Database Changes – Prodiance Database IQ generates a detailed comparison report between two versions of any Access database, allowing users to identify changes made to database objects, including: Tables, Queries, Modules, Macros, Reports, Pages, and Forms.
- Visual and Graphical Comparison – Both graphical and line-by-line textual comparison are available for viewing code changes to database Queries and Modules.
- Printed, PDF or Excel Reports – All Prodiance Database IQ change and comparison reports can be printed to a hard copy printer, or exported to either PDF or Excel format.
Prodiance Database IQ is provided as part of Prodiance Enterprise Spreadsheet Manager.
Get Started Today! If you’re ready to reduce the risk of errors in the financial reporting process, improve compliance, and increase visibility and control over critical Microsoft Access database applications and other user-developed applications (UDAs), contact a Prodiance representative for your personalized demo today!