Software Development Case Study
The Scottish Borders Council is the unitary authority for the Scottish Borders, an area covering over 1,800 square miles of beautiful scenery and home to over 106,000 people.
The Council had a proliferation of MS Access database applications in use throughout many departments. Such applications were often crucial to the smooth running of the department concerned, yet they had been developed by past employees or 3rd parties who could no longer provide support for the application.
With their IT department focussed upon support of their own legacy systems, the Council decided to look for an external vendor who could support a wide variety of departmental MS Access and SQL Server applications and develop small departmental systems. Support was required for a wide variety of departments - Corporate Finance, Administration, Personnel, Treasury Management, Transport and Environment to name but a few.
CAS was awarded a multi-year Framework Agreement for MS Access/SQL Server Support and Development Services. Under this agreement CAS provides a telephone help desk, resolution of database issues, distribution of updated software containing 'fixes' and installation of software as required. In addition, CAS develops new applications as requested, converts applications to SQL Server as well as providing full documentation and training where necessary.
“As an existing supplier to the Council, CAS had demonstrated their skills over a number of years in the delivery of systems development and support services to our Social Work Department. With such a proven track record, we were delighted to be able to award a further 2 year contract to CAS. We have been extremely happy with both the support and development services which they have provided. They work closely with us to understand departmental needs and we have been impressed by their professional attitude in delivering systems development and support services."
Henry Thompson, Head of IT, Scottish Borders Council