Clients - Our Solutions - Their Success
We can work with you and your business as either an ongoing ‘part time developer’ or on a ‘per project’ basis.
Some examples of our client projects (references available). If you have a similar requirement then please get in touch.
Enhanced Financial Reporting
This business already had a central SQL database for all their WIP data but were lacking reporting functionality. Our solution involved a mix of Excel and Access reports and other enhancements making the database the hub of the business and all business reporting.
This stock company had a legacy mix of Access databases and Excel spreadsheets with the usual complications of duplicated or missing data. The solution was a custom developed Microsoft Access and SQL Server database drawing together over 300,000 stock items. The result is a single point of reference for stock control and customer quotations. Exactly what a database should be.
Data Capture for Mobile Workforce
If you have a mobile workforce then you may relate to the issues of paperwork being late or lost, and photographs being taken on mobile phones but not being available back at the office.
The solution was the design and development of a mobile data capture system based upon the Microsoft Power Platform (Power Apps and Power Automate). The result is their data and photographs are received 'back to base' minutes after being completed onsite. And filed to the appropriate job.
Automated Reporting System
An insurance related business that analyses data from Lloyds syndicates was struggling to analyse and report on the volume of data it was receiving in Microsoft Excel and Access. The solution was an automated Microsoft Office 365 based system where one button pressed literally replaced days of work. The result was one very happy customer.
Wix Website Integration / iZettle Integration / SquareSpace Integration
This client had approx. 400 stock records that needed to be fed to the Wix website platform. In addition the stock had numerous attributes and related records. With stock held across multiple Excel files a database was developed to store all the data and provide a central point to upload stock data from. The result was a data feed allowing the client to manage their own data and refresh their Wix website in minutes.
Further additions means the same Access database now feeds iZettle with SquareSpace to follow.
Barcode Printing (Access Database)
This Access database containing multiple stock records needed to generate barcoded labels. A new reporting function was added to allow the quick and easy printing of labels in different sizes.
Sage Line 50 Integration to Access Database
An existing Access/SQL database needed to feed Sage Line 50. A quick development resulted in a daily data feed reducing data re-keying and improving accuracy.
Migration of a .NET 2.0 C# project to .NET 4.5
This client fortunately had the C# source code to a reporting engine developed several years ago. Now requiring some changes the project was migrated to .NET 4.5 and developed further.
Job Control System
This engineering company had an outdated Microsoft Access database. After undertaking an analysis of the requirements a new Access database was developed to facilitate their ordering and paperwork production.
This customer wanted to get data out of Instagram for competitor and keyword analysis. Problem solved with some Excel and Access development and automation.