Standish Metal Treatment Ltd. - Access Database FoxPro SQL Server VB VBA ASP WEB Programming - Freelance Database Systems and Web Developer

The prime purpose of the system was to record details of Standish Metal Treatment '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 121 Fundraising Ltd. 301 Design Abbey Storage ABS Wastewater Technology Ltd Acacia Conservatories Air Heating (Southern) Ltd. Almond Art Alpha Impact Ltd. Art du Midi Blairgowrie Guest House Broadway Records Bruce Burlington & Co. Ltd. Buy it Here Cachet (London) Ltd. Camping La Corconne Canon Consumer Imaging Careys Private Hire Dartford Council Dellcourt House Denew DIY or PRO DIY or TRADE Excel IT Ltd. GAP Photos 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 Trade and DIY The Holiday Hippo The Lamp Company Weatherbys		Standish Metal Treatment Ltd. Job Tracking System The prime purpose of the system was to record details of Standish Metal Treatment 'jobs'. Prime areas of operation: Storage and reporting of Quality Control measurement data Storage and reporting of Paint Thickness Measurements Production of Advice/Delivery notes Production of Invoices Creation of Purchase Orders Recording of Enquiries/Contracts Production of Quotations Production of Job Programme Sheets 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. See examples of some of my Microsoft Access Development and VBA Programming Projects here... 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