Migrations & Upgrades
Is your database unable to keep up with your business?
Existing versions of Access can be painlessly upgraded to the current version while old Excel systems can be migrated successfully to Microsoft Access. Similarly Access systems can be upgraded to a more powerful platform or a cloud-based solution to enhance functionality and improve performance.
From Excel to Access
It is very common to start using Excel and end up with spreadsheets that are difficult to manage and report on. We can take these spreadsheets and migrate the information to Access, consolidating your data. This gives you an easy-to-use set of screens for data entry, point-and-click reporting and the ability for multiple users to work on the system at the same time.
Upgrading to Microsoft SQL Server
If your business is experiencing rapid growth you may wish to consider using the more powerful Microsoft SQL Server to store your data. This can accommodate many hundreds of users and offers a number of significant benefits. We are Microsoft Certified SQL Developers and can migrate the data in your current Access system to MS SQL while keeping your existing Access front-end largely unchanged. This allows you to scale up significantly while preserving your development investment and minimising the change and disruption for your users. We can upgrade to either SQL Server on premises or on the Microsoft Azure cloud – the latter is ideal for supporting home and remote workers, mobile teams etc.
Upgrading to Mobile
If you need to make your database available to a mobile workforce or remote and home workers, we can build a mobile/tablet working solution on top of your existing Access database without the need for redeveloping your system. There are a number of ways in which this can be achieved, including building fully bespoke hybrid apps or by integrating with third party mobile solutions.
Enabling multiple users and adding functionality
Tonic Cosmetic Surgery
Upgrading a database to a cloud-based system meant users in a new international office were able to use it. Using Access also meant SMS functionality could be added to remind patients of their appointments.