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

Midaye Somali Development Network

Midaye Somali Development Network approached me to develop an Access database system for them to record all contact with their clients to a level of detail that would enable them to undertake statistical analysis of the services they offer.

The database is simple to use and consists of a logon screen and the main data screen

Logon Screen

Logon


Main Screen

Main Screen


There are 3 levels of logon, administrator (who can do everything), input (who can undertake restricted operations) and view (who can only view the data)

Each of the areas of the form have validation programmed so that if they are mandatory the system will inform users if they have left anything uncompleted, it also lock certain input areas based on business logic.

There is an option to run a report that provides counts and percentages of a lot of the data captured within a user selection date range. There is also an option to export data to Excel.

I developed a custom ribbon to provide the users with only the functionality required, thereby doing away with the full Access menus which only prove to be confusing to users.

Custom Ribbon

Custom Ribbon

 
© Dennis McDermott 2001-2021  -:-  Dennis McDermott is a Freelance Access Developer at Bespoke Software Development Limited -:- Privacy Policy