Dennis McDermott
Freelance Database Systems and Web Developer

Tel:  +44 (0)20 8123 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

ESAB - Talent Management Database

I was approached by ESAB to develop a Talent Management Profiles Database for use in the human resources department. The client knew Access and believed that was the right tool for the job.

After receiving details of the data to be held I discussed with the client the best way incorporate photos of the staff members and talent web graphics.

The system was created in Access 2003 and uses a technique I have developed to provide self maintaining dropdown boxes, these go a long way to ensuring consistent data whilst still providing flexibility.

The system validates the users entries and prevents records being added to the database where the validation rules are not met.

The system has a single button to export the data to Excel, this can either be all the data, or a subset of the data if the user applies a filter before exporting, the caption of the export button changes to reflect whether a full or filtered export will be undertaken. The system pops up a dialog box for the user to save the Excel export file, but initially sets it to go to the users desktop and gives it a filename using the current date and time.

The system was demonstrated to the client and installed remotely using the excellent Mikogo software.

The system has a custom menu which I designed to provide all the functionality the client requires without all the confusing clutter Access provides by default.

ESAB Talent Management Database

Client Comments:
I needed a practical and quick database to help manage talent in my organisation. Dennis provided a very user friendly, fit for purpose bespoke solution in a very quick time. I have already recommended him to others in my profession and will certainly be using him again. Great job!

Steve Kelsey
Global Head of L & D
ESAB


See examples of some of my Microsoft Access Development and VBA Programming Projects here...
 
© Dennis McDermott 2001-2021  -:-  Dennis McDermott is a Freelance Access Developer at Bespoke Software Development Limited -:- Privacy Policy