Dennis McDermott
Freelance Database Systems and Web Developer

Tel:  0208 123 0528
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.


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


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


Metal Cleaning UK Ltd

Midaye Somali Development Network

Moving Ahead Online Ltd.

MSL Medical



Regent Carriage Services

Rail Professional

Rail Professional Development

Sea Containers

South Essex Gymnastics Club

South & East Essex Training Group

Standish Metal Treatment Ltd


The Gifted Goat

The Lamp Company

Thompson and Morgan

Total Crane Services

Virtual BM



Fleetwood Building and Maintenance

Job Sheet System

I was approached by Fleetwood Building and Maintenance to develop an Access Database system to replace their current method of working which involved the use of Excel spreadsheets.

The day to day production of job sheets and reporting to their client was becoming more and more difficult to undertake using these spreadsheets.

Two of the main advantages of the system I developed are the fact that it is multi user and that it automates and controls the processing of Job Sheets and reports.

Logon Form
When a user sucessfully logs on the system determines their user type and access rights

Main Menu
Based on the users access rights some of the options on the main menu may not be available

The user is able to enter Job Sheet or Invoice numbers which will appear on the appropriate reports, upon running these reports the individual job sheets are marked to automate Job Sheet and Invoice reporting.

Operatives Form
Here administrators can maintain a list of operatives that can be selected on the main Job Sheet form

Users Form
Here administrators can maintain a list of users of the system, assign passwords and set user types

VAT Form
Here administrators can set the current rate of VAT to be used throughout the system

Main Job Sheet Form
Here users can enter details of Jobs

This form checks for manadatory data, allows the addition of multiple job elements, setting of quantities and marking of extra work. This form also keep a running total of costs and provides buttons to print the Job Sheet and Works Order.

This form is very easy to use, as all of the main data in the lower half is pre-populated when a job code is selected form the drop down lists on the left.

The printing history is only editable by administrators, and the form contains quick filtering by use of a dropdown filter selector.

SOR code Search Form
Clicking any of the magnifying glass icons on the main form will popup this SOR code search form, here the user can type part of a job description and the form will display all jobs with that text in the description. Then a single click will populate the main form and close this search form.

Example Works Order

Example Job Sheet

Example Invoice Report

Example Job Sheet Report

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