Clients and Projects

Delegate tracking database

I was approached by Rail Professional Development, a company involved in rail safety to provide training to their staff, this training took the form of undertaking the development of this system alongside RDP staff. This enabled the training to be focussed and at the end of the training the customer had a useful working system.

The system was written in Access 2002, and runs on a server to provide centralised access to the data throughout the organisation.

• Features multi logon levels to allow different functionality for different users.

• As part of the training the following topics were covered.
  • Table design
  • Form design
  • Basic query writing
  • Menu customisation
  • VBA programming
    • Functions and Procedures
    • Naming conventions
    • Properties, Events and Methods
    • Defensive programming
    • Control structures

Time tracking database

Following on from the Delegate tracking database system, Rail Professional Development asked me to develop a Time tracking system for them.

This system allows each project the company undertakes to be entered into a database, storing many details about the project, but most importantly the available time to completion.

The system provides facilities to store working hours per consultant against the various projects monitored, and provides extremely flexible reporting facilities. For example reports can be produced that show tasks undertaken by each consultant on each project for a particular client or across all clients, within a selected date range. The system also produces productivity reports against each consultant, this again can be produced to cover a specific period.

Key Features

• Recording of time against, tasks, projects and clients.
• Dynamic highlighting of any project overruns.
• Productivity reporting down to consultant level.
• Fast feedback reporting to clients.