Is your original developer no longer available? We specialise in safe rescues and takeovers Find Out More
Is your original developer no longer available? We specialise in safe rescues and takeovers Find Out More
With over 20 years experience developing and supporting Microsoft Access database solutions we have experience across a wide range of industry sectors. From advertising and aeronautics to universities and waste disposal, we have built database systems across a range of industries for companies based both in the UK and abroad.
Please see below for some examples and get in touch to see how we can help you.
We have worked with charities in various sectors including:
System we have worked on for charity clients include:
Systems to track and managing property snagging prior to sale.
Systems to record and manage customer issue post sale, including generation of remedial work orders to suppliers
Systems to record details of properties/sites under development and potential/actual sales.
Various databases to manage details of properties and tenants
Purchase ordering to keep track of materials, plant and people purchased and invoiced.
For a leading planning consultancy we developed a CRM system to remove their dependence on customer contact and lead details being kept in numerous private spreadsheets and Outlook profiles. This was expanded to manage quotes, jobs, time & expenses, financial forecasting, invoicing and detailed reporting.
Estimating and job management database extending through to fitter scheduling, purchase order management and application for payment.
Time and job management for bespoke kitchen builders
Helped enhance clients existing database for tracking and managing samples taken during the building of roads to ensure legal standards are met.
We have worked with a number of universities on systems such as:
Working with Learning Grid we developed a system to track and report on the participation of school and college pupils in educational activities organised in conjunction with private companies. This system was integration with the EDUBASE database of UK educational establishments.
Working with a regional electricity company we were able to quickly extract data from their legacy database, a task which was holding up the implementation of a new system.
Provision of consultancy, general advice and provision of a prototype database to a solar energy company to allow them to develop a system to track assets and manage/schedule maintenance jobs.
Recording and reporting of faults. Tracking details of repair work undertaken to ensure safety requirements and working practices are complied with.
We have developed and supported Access database solutions for a range of engineering clients. Examples include:
We have built and worked on product/ingredient databases for a number of food producers allowing them to manage product recipes, quickly see what ingredients/suppliers are used for which products and apply price changes instantly.
For a small grower and distributor of organic veg boxes out database allowed them to schedule customer deliveries using mapping software to optimise the delivery routes.
Our bakery client had a number of shops all using a legacy EPOS system. We were able to integrate with this and extract data automatically which could then be analysed further in Access and Excel to identify sales trends and manage stock distribution.
For Subway we worked to enhance an existing database used to report on profitability.
We have worked on Access databases for apple growers, potato growers and other similar clients often integration with specialist machines used to weigh and calibrate product.
Reporting systems for the NHS at a regional level.
We have developed data collection and reporting systems for a number of hospital consultants to assist in the treatment of patients and in research projects. Specialities covered include cardiology, optometry and orthopaedics.
Development and support of appointment management systems and reporting systems for NHS weight-loss and other specialist clinics.
Patient databases and appointment management systems for private health clinics including features such as automatic letter generation for appointments, followups and SMS reminders.
For a national grouping of specialist NHS consultants we enhanced a system developed to allow anonymous patient data to be collated and analysed centrally.
For pharmaceutical companies we have developed systems to keep track of patients participated in trials and collate their test results. We have also developed a system to keep track of cancer drugs being sent to hospitals and to predict future requirements based on order history.