Design Examples

The data in all examples is fictitious.


In 2004 a large Multinational company wanted to be able to manage the training requirements for 1,400 UK staff. This form allows the Training Manager to see what courses are booked, who wants a course and who is booked on a specific course. The form works in a synchronised way. The user filters for a specific course and is then presented with a summary list of requests received in a given quarter (light blue form - top left). The form shows requirements and unallocated requests. By selecting a row from this list the three other forms are updated.
The right hand form (green) changes to show courses that have been booked and placed in the programme.
The lower left hand form (darker blue) shows the name of employees who have made a request but as yet, have not been allocated a place.
By selecting a course in the green form the lower right hand form (pink) also changes to show who is already booked on that course.
The buttons in the lower panes allow students to be placed on, or removed from, a course.

Training Manager 2

This is a form we developed in order to provide a reliable tree-view form for Access. The article together with a working example was published on The Code Project site on 27 May 2013. It can be downloaded from here

Treeview Form

This is a case tracking system that allows a family mediation organisation to track clients and partners by case. It produce a series of reports to support claims to central government. Note the search options in the Ribbon bar. The user types the first two or three characters of either parties name and the drop down list to the right of it fills with matched names. Alternatively the case number can be used.

Case Manager

This is the main form to record details of carers and persons who are cared-for together with contact and activity details. It produces statistics for a local authority in the form of an Excel spreadsheet. The database has been running since 1995, it holds records for 10,000 carers.

Carers main screen

This is a proof-of-concept interface designed as part of a presentation for a transport-logistics database. The user types two arbitrary dates and displays a diary for that period or inserts a period relative to today's date by selecting from the drop-down menu. The red line at the bottom of the page indicates to the transport manager that this journey does not have a driver. Forms for drivers, destinations, clients and a calendar would be displayed by double clicking the appropriate column.

trainsport Logistics

This form is completed when an order is received and an engineering company is seeking out availability and cost of materials to build a component. Clicking the send-email button sends a formatted email to each supplier asking for a quote. Individual emails can be sent by following the instruction in the lower left of the form.

Engineering supplies data formn

This form was used to track contract data where a customer decided to change their electricity or gas supplier. The address and meter numbers were cross checked against a large database called The Utility Register in real time and any anomalies were immediately flagged up. The interface was designed for rapid keying; at its busiest, the database was receiving input from 25 operators. When the project closed there were more than 400,000 records in the database.

Contract Tracker

The Training Manager database is a diary system linked to the personnel records system so that, whenever an employee attends a course, their records are automatically updated. Each course has a bespoke check-list. Joining instructions and a map can be sent via email and Lotus Notes on a point and click basis. The system ensures that trainers and rooms are not double booked.

Training Manager 1

This is a variation on the Sparkline feature found in MS Excel. It has been adapted for an Access report in order to provide 'at a glance' feedback of sales figures. Notice in the histogram that the green bars show the maximum value and the red the minimum. The code was adapted from the Access Blog featuring an article by Phillipe Bonnardell.

Report with sparklines

We wrote a short acticle for the Access blog illustrating how to use a partition query, this is a little known feature of Access queries.

The query was set up to analyse the date-of-birth field from a list of clients but it could use a numeric field instead.

Output from the query showing 5-year-buckets...