Barnet and Chase Farm Hospitals -  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.
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.

Example Report


See examples of some of my Microsoft Access Development and VBA Programming Projects here...
 
© Dennis McDermott 2001-2017  -:-  Dennis McDermott is a Freelance Access Developer at Bespoke Software Development Limited