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

Total Crane Services

Total Crane Services were using an Access database system that kept records of safety certificates against cranes and lifting equipment; this database and was having a few problems.

After analysing the existing system I decided the best way forward would be to streamline the way the existing system interfaced with a website to allow clients to view safety certificates.

This resulted in the removal of many lines of redundant programming code from the old system, and developing a new online system that would present the certificates if a clear and easily navigable manner.

The old system now has a single button to update the website (this used to be a multi stage process where the user and to manipulate files into certain directories and was prone to mistakes)

Clicking the button to update the website creates a snapshot of the required data and then sends this to the website using FTP in the background.

The website has a clean interface, a user logon page shown below

Total Crane Services - Logon

Once logged on the user is presented with their certificates in a tabular form, this data can be easily sorted and searched, and by clicking a button next to each certificate will produce a certificate ready for viewing or printing.

Total Crane Services - Certificates Listing


Example Certificate

Total Crane Services - Example Certificate


Technologies used in this project:
  • ASP
  • CSS
  • Datatables
  • FTP
  • HTML
  • JavaScript
  • JQuery
  • SQL


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