Fleetwood Building and Maintenance -  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.
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-2019  -:-  Dennis McDermott is a Freelance Access Developer at Bespoke Software Development Limited -:- Privacy Policy