Our most in-demand Data Services are:
Data migration and verification
For moving data between applications when switching or upgrading software. Successful migration involves backing up, and rigorous checking. We use Excel functions and macros that give confidence in the whole process.
Cross-platform import or export
Preparing data, creating workbooks, and using custom functions to convert data between formats. Workbooks are designed with repeated use in mind, and for easy integration with larger automated systems.
User-friendly front-end forms for database and data table management. Essential for effective data management.
Preparing databases from scratch
Constructing a database from scratch requires an advanced understanding of the purpose of the database and its future applications. We have acquired this over the years, giving us an understanding of where redundancies need to be built in to future-proof the end result.
Including macros for file listing, copying, naming, moving and deleting, to form the basis of an effective file management policy.
We have built up a considerable library of examples, tools and aids for data management, which means that very time-consuming tasks can often be automated.
Other, more bespoke systems can be built to order – contact us to find out more.