Project Management & Tracking

Databases are excellent for keeping track of key dates, activities that are due to happen, who is due to do a particular task and who has actually done what.

Being MS Access and MS SQL specialists which can design a system to track projects and processes specifically for your business.

Management and exception reports, along with emails and other forms of alert can be used to bring problems to your attention quickly.

Resources can be better managed by understanding where the capacity or lack of capacity actually is in your business any any point in time.

Examples of recent project management & tracking systems we have worked on:

Project  tracking for pharmaceutical company

A large pharmaceutical company, required a simple to use project tracking system to enable them to monitor the progress of projects across a number of areas of the business.

The system was required to provide a high level overview of the status and progress of projects rather an being a detailed task management or project management system.

We were able to develop a simple, clear and easy to use dashboard based system which used colour coding and charts to provide a quick overview of the project portfolio.

Project tracker dashboardx


Project tracker charts

In additional to tracking the status of projects the system was also able to track the people involved with the project and a list of outstanding actions.

The system was later expanded to track and manage project expenditure against budget.