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 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

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...
 
© Dennis McDermott 2001-2024  -:-  Dennis McDermott is a Freelance Access Developer at Bespoke Software Development Limited -:- Privacy Policy