Microsoft Access System Replacement

How First Option Software kept Sure Maintenance’s systems moving smoothly

The Brief

To address Sure’s existing systems and rectify the situation by moving the data into a more manageable system

The Background

As with many successful expanding organisations it is easy for core IT systems to grow in such a fashion that before you know it you are running your business around a set of MS Access databases. There’s nothing wrong with MS Access but there comes a point when this approach reaches the limits of the tool and things get out of hand.
This inevitably leads to inefficiencies in working and an inability to respond to business changes.

The Challenge

The above is the situation we found at Sure when we were invited to review their mission critical database(s). A suite of Access-based applications had been developed over time for day-to-day job management. These all played a vital role running daily operations with both customers and field engineers reliant on their content.
Each application in the suite was very similar but had been altered to cater for specific situations. Adding to the overall change control headache was the reports component that consisted of many versions of the same reports all with minor differences

The Implementation

Sure recognised the issues and our remit was to rectify the situation by moving the data into a more manageable system, in this case Microsoft SQL Server. We used the in-built Business Intelligence tool to provide a suite of reports and added in a JBoss application server to create a web based application that required no client install.

In collaboration with Sure we designed, specified and delivered a solution that would bring their core system back under control. Over a period of 4 months First Option Software worked on the system delivering on-time and on-budget. Sure Maintenance now have their key application on a scalable platform with the ability for it to grow in a controlled fashion in line with their business.

If you are currently wrestling with Access or Excel solutions that are growing out of control then please do give us a call, and let us show you how we can help you.

Book a free demo of CmdCtr

Tell us what you want to achieve with CmdCtr and we’ll show you how. Book a free live demo below to get your tailored introduction to streamlining your park operations.

In 30 minutes, you will...

  • Learn how your business can use CmdCtr
    No scripts, no generic sales pitches. We'll help you understand how CmdCtr can work for your business.
  • See the system in action
    There's no comparison to seeing things in action. We'll help you visualise how the system could fit into your workflow and processes.
  • Ask us anything!
    We created the system and we can do what it takes to fit your needs. If you have any specific requirements that are bespoke to your business, ask us about them and we'll start you on the path to getting exactly what you need for business success.

Discuss your requirements with one of our experts. Request a personalised 1:1 call

We understand that navigating the process of commissioning a software project can be confusing. That's why we offer a free 30 minute session with one of our experts, so that we can help you focus on how technology can transform your business.

In 30 minutes, we'll discuss

  • What are the real-world needs for your business?
    Building bespoke software is a process of converting a real requirement into code and its success is all down to how the requirement is interpreted. We'll look to listen and understand how a software system needs to work for you.
  • Bespoke software vs off the shelf vs system integrations
    Just because we can write the software, it doesn't always mean that it makes most business sense. We'll start to explore this with you.
  • Timescales, budgets, contributing factors
    There's more than one way to approach any software project, so we'll discuss any factors that might influence how we approach your project.