Leicester City Council
Replacing a Microsoft Access system originally built in 1997 with a bespoke desktop application for the Highways Department's job costing and operational reporting.
The challenge
Leicester City Council's Highways Department relied on an ageing Access system to support its work. Dependencies on other software, problems following updates and repeated workarounds made the existing setup difficult to maintain.
What BSPOKE built
Launched in 2015, the replacement put Job Costing at the centre of a connected desktop software suite. It tracks work orders, labour hours, associated costs and income, with user permissions and a shared central database connecting the department's applications.
The system also supports allocating operatives to jobs, producing timesheets and Job Cards, and exporting financial and performance reports to Excel and PDF.
Why the example matters
This was an Access replacement built around the department's operational requirements. It shows that modernisation can preserve the detail of a specialist workflow without retaining the old application. The delivered example is desktop software, not a cloud-migration case.
Planning a similar replacement?
Our Microsoft Access replacement service explains how we assess the existing application, its data and its business rules before agreeing a replacement. For broader options, including stabilising or extending an existing system, see legacy modernisation.
What the system does
- Tracks work orders, labour hours, associated costs and income received
- User-friendly Windows tiled layout with role-based permissions
- Barcoding to quickly assign operatives to jobs
- Produces timesheets, pay slips and detailed Job Cards
- Shared central database integrated with the wider software suite
- Financial and performance reports exportable to Excel and PDF
Technology and capabilities
Highlighted capabilities link through to the relevant service.
Screens and outputs
How we could help your business
Microsoft Access Replacement
Assess an Access application and, where change is justified, replace it around the data, rules and daily work it already holds.
Learn moreLegacy Modernisation
Stabilise, extend or replace older business systems, with data migration and the transition planned around your operation.
Learn moreCustom Software Development
Bespoke systems built entirely around your unique ways of working and the daily tasks that keep your business running.
Learn moreCustom ERP Software
Purpose-built core business systems for manufacturing and operational companies that have outgrown generic, off-the-shelf software.
Learn more