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

Barnet and Chase Farm Hospitals

Equipment Loan Database System

I was approached by a representative of Barnet and Chase Farm Hospitals to design and develop an ‘Equipment Loan Database’ The department in question loans medical equipment to other departments within the hospitals and this database system was required to store information pertaining to those equipment loans.

Main Menu Form

After logging on the user is presented with a main menu, if the user has administrator status then the administration options are available on the main menu, otherwise they are not.

Departments Form

From the main menu an administrator can maintain information regarding the departments who loan equipment

Equipment Form

The administrators also have access to maintain the equipment available for loan, the yellow boxes indicate mandatory information and the system advises the user if they attempt to save a record without completing this mandatory information. A sub form holds information on additional parts which are loaned with the main equipment, for example a power supply.

Users Form

The administrators can also maintain information regarding the users of the system.

Loans Form

All users have access to the loans form. This form details who has loaned equipment, what equipment they have loaned and for what time period, this is important as equipment loans can be setup before the actual loan takes place and the system intelligently only offers equipment for loan that is not already loaned during the same time period.

There is also an option to print the loan agreements from this form, the loan agreement shows all relevant details of the loan and provides space for the relevant parties to sign the equipment out and back in.

Loan Agreement



Report Selection Criteria Form
Report Selection Criteria Form The ‘Report Selection Criteria’ form provides great flexibility in reporting, allowing the user to fine tune what is contained in the report.

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