Access Database Developed for Project Tracking and Reporting
Our client is a multi-national provider of technology products and services for businesses, governments and educational establishments. They approached Xlteq to improve and unify their project tracking and reporting. The existing system used a number of Excel spreadsheets.
The scope of their requirements included:
- New project creation tool
- Project budget calculation functionality
- Project tracking functionality, including actions, risks and comments logging
- Timesheet and work forecast tools
- Project reporting suite
- Management summary reporting
The Solution - Access Database
The first stage was for our Access Developers to meet with the client and fully scope the requirement for the new database. After our initial consultation we proposed a solution based around storing the data in an SQL database and designing an Access frontend for the users to manipulate the data in the database. Reporting would be displayed in Excel by transferring data from SQL into Excel with calculations instructed via the Access Database frontend. This method was implemented due to the complexity of the reporting.