Metal Cleaning UK Ltd. - Access Database FoxPro SQL Server VB VBA ASP WEB Programming

The prime purpose of the system was to record details of metal cleaning 'jobs'.

Prime areas of operation:

Client Comments:
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.


	Clients and Projects These are a few of the companies I have worked with recently.
	Clients and Projects 301 Design Abbey Storage ABS Wastewater Technology Ltd Acacia Conservatories Air Heating (Southern) Ltd. Art du Midi Blairgowrie Guest House Broadway Records Bruce Burlington & Co. Ltd. Cachet (London) Ltd. Canon Consumer Imaging Careys Private Hire Dartford Council Excel IT Ltd. Gites in the Languedoc Haymarket Publishing Hiltongrove Audio Bank Hiltongrove Business Space Le Palais des Roses Lynwood Lodge Marie-Louise von Motesiczky Metacosm Metal Cleaning UK Ltd Moving Ahead Online Ltd. MSL Medical Pepperneck Pro-Talk Regent Carriage Services Rail Professional Development Save Your Feet Sea Containers Shopping Alley South Essex Gymnastics Club South & East Essex Training Group Standish Metal Treatment Ltd Sunnyseek Sunnyseek World The Digital Donkey The Gifted Goat The Fashion Fish The Furnished Frog The Holiday Hippo The Lamp Company 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. Enquiries and Contracts are stored, the system calculates many of the parameters used when answering clients enquiries, ensuring consistent client responses. 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. Client Comments: 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.

Clients and Projects