Local government (Highways Department)

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.

Before Microsoft Access system (1997) Workarounds; patches; high maintenance
After Bespoke Job Costing suite Integrated; modern; reliable
2015 Job Costing replaced a
1997 Access system
Leicester City Council Local government (Highways Department)

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.

Discuss your existing system

Inside the build

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

Windows desktop application Central database Barcoding Reporting (Excel and PDF)

Highlighted capabilities link through to the relevant service.

A look at the system

Screens and outputs

Have a process that needs software built around it?

Tell us how your business actually works. We will give you an honest view on what a practical first phase could look like, and what it would take to build it.