Dennis McDermott
Freelance Database Systems and Web Developer Tel: 0208 123 0528 Email: admin@dennismcdermott.co.uk |
Home - About Me - Clients and Projects - Training - Software/Programming/Technologies - Hosting - Websites - Testimonials - Contact |
Clients and ProjectsThese 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 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 |
Anitox (Security through science)
Modification of two Access databases located in Europe and the USA, and creation of web application for analysis of scientific data. The Databases Anitox had a requirement to bring together data that was currently being captured in two different Access Databases, these databases have completely different data structures, tables, field names. The first task was to produce outputs from both of these databases that would form a consistent input to the web application, this was quite a task as the database were recording measured values in different ways. I embedded procedures in both the European and USA databases that would collect and clean the data and then FTP this data to the back end of the web application by the click of a single button. The Web Application I developed a password protected web application for Anitox that allows their staff to preform sophisticated analysis on the test results from the European and USA database. The application allows the selection of many criteria, such as test date range, locations within Europe and the USA, ingredients, the company’s products and doses. The test results display quantities, averages, counts and percentile values for various aspects. See examples of some of my Microsoft Access Development and VBA Programming Projects here... |
|||