An Access Database was being used for job entry and time management. It had been created by a team member as a hobby but had grown and was now very important to the running of the business. Professional support was needed to reduce the risk to the business
Access databases have 2 elements; screens for input and reporting, and the actual data storage element (these 2 elements are generally referred to as the front end and back end). Where multiple users are involved and changes need to be implemented easily it is accepted that the front end and back end should be independent one from the other. This was not the case here which made evolution of the application difficult.
The agreed solution was to move the data storage over to Microsoft SQL Server (a cloud enabled data store). Later the data input area ‘Front End’ would move from an Access Database to a purpose built Windows based application. Moving away from an Access front end would allow better integration with Sage Line 50 and facilitate more sophisticated document production (supporting different printers, changing templates more easily etc.).
Packages which can be involved