David Nye Bespoke Fleet Management Example
Scope
| Client: | SGB Fleet Services division, based in Crawley, West Sussex, UK. |
| Objective: | To replace the existing Eurofleet package with a bespoke MS Access database application. |
| Size: | Nationwide vehicle fleet of over 1000 cars, vans, fork lift trucks and HGV, with 600 drivers. |
| Users: | Initially 14 users on Windows LAN in Crawley. Remote access for 5 regional workshops. |
Background
- The existing Eurofleet system had become expensive and difficult to maintain and upgrade, being based on proprietary technology.
- Much of the data it contained was inaccessible.
- It did not appear to be able to handle the growing number of users satisfactorily.
- Core financial systems being converted to Oracle, so the fleet management system to interface with Oracle.
- Standalone Microsoft Access databases have already been developed in-house to supplement the existing system, for example, the Time & Mileage journal calculations. These existing Access databases could be integrated into the new system where appropriate.
- Accounting staff are easily able to manipulate data in Access databases, affording great operational flexibility.
- The new Access front end can be converted to use an Oracle or SQL Server database engine in the future if required.
- Needed to eliminate duplication of input.
- Needed to include external hire vehicles.
Features
- Comprehensive vehicle records and reporting
- Vehicle allocation to driver (if applicable), cost centre and workshop with full history and Speedo readings
- Vehicle maintenance history and comprehensive cost analysis
- Monthly time and mileage charge calculation and export to Excel for management reporting and journals
- User recharge tracking, analysis, and export to Excel for management reporting and journals
- P11D mileage returns input
- Accident report and claims tracking
- Fuel card and mobile phone records
- MOT and VED reminders
- Purchase Orders