|
Clients and Projects
121 Fundraising Ltd.
301 Design
Abbey Storage
ABS Wastewater Technology Ltd
Acacia Conservatories
Advice North Lincolnshire
Air Heating (Southern) Ltd.
Allianz Global Corporate & Specialty
Almond Art
Alpha Impact Ltd.
Anitox
Art du Midi
Barconn Limited
Barnet and Chase Farm Hospitals
Blairgowrie Guest House
Brentwood Communications
Broadway Records
Bruce Burlington & Co. Ltd.
Cachet (London) Ltd.
Camping La Corconne
Canon Consumer Imaging
Careys Private Hire
Dartford Council
Disabled Living Foundation
Dellcourt House
ESAB
Excel IT Ltd.
Fleetwood Building and Maintenance
GAP Photos
Gites in the Languedoc
Haymarket Publishing
Hiltongrove Audio Bank
Hiltongrove Business Space
Lansbury International
Le Palais des Roses
Lynwood Lodge
Marie-Louise von Motesiczky
Metacosm
Metal Cleaning UK Ltd
Midaye Somali Development Network
Moving Ahead Online Ltd.
MSL Medical
Pepperneck
Pro-Talk
Regent Carriage Services
Rail Professional
Rail Professional Development
Sea Containers
South Essex Gymnastics Club
South & East Essex Training Group
Standish Metal Treatment Ltd
Sunnyseek
The Gifted Goat
The Lamp Company
Thompson and Morgan
Total Crane Services
Virtual BM
Wasteking
Weatherbys
|
|
Metal Cleaning UK Ltd.
Job Tracking System
The prime purpose of the system was to record details of metal cleaning 'jobs'.
Prime areas of operation:
- Creation of Purchase Orders
- Recording of Enquiries/Contracts
- Production of Quotations
- Production of Job Programme Sheets
- Storage and reporting of Quality Control measurement data
- Storage and reporting of Paint Thickness Measurements
- Production of Advice/Delivery notes
- Production of Invoices
The system was written in Access 2003, and runs on a server to provide centralised access to the data throughout the organisation.
Features multi logon levels to allow different functionality for different users.
Job programme tracking is accommodated for, together with the recording of inspection and environmental details for quality control purposes.
An example output, an Inspection Report.
See examples of some of my Microsoft Access Development and VBA Programming Projects here...
|
|
I initially contacted Dennis to update an old Access 97 system. Dennis completed the work on time and well within budget but still more work was required to turn the old system into a workable database.
Following Dennis's recommendations we started afresh using access 2003 designing a new system far superior to the basic model and capable of much, much more. Explaining the step by step process of a shot blasting and painting operation is not very easy. Dennis soaked up the information, I cannot think of a time when I had to explain a process more than once. It isn't rocket science I know, but it can be pretty complicated at times; the dry film thickness formulas and relationships between coating application, times and climatic conditions etc. All have to be understood prior to programming.
Dennis set certain criteria for information to be entered correctly and added live 'popups' that total financial category data in real time, a real aid when ordering against budgets. The reports produced are brilliant, everyone at both Metal Cleaning UK and Standish Metal Treatment are very pleased with the results so far.
I say so far because I am continually asking Dennis for improvements which are done professionally, on time and to requirement. I cannot recommend him enough, fantastic service.
If you would like to contact me personally for a reference, you can use any of the contact emails or telephone numbers on the MCUK or SMT websites - Steve Brierley QA / H&S Manager.