Barconn Limited -  I am a Freelance Microsoft Access Database and WEB Systems Developer/Programmer specialising in Database Development, Access, SQL, Foxpro. Design, Programming and Development of both local network and Internet based applications. +44 (0)20 8123 0528  

E-mail: 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-2017  -:-  Dennis McDermott is now Bespoke Software Development Limited