Client Portfolio

This isn't an exhaustive list of all the systems that we have written and installed but it will give you a good idea or the range of services we can offer...

Access/Outlook/Word

Government Department

The publicity department of the Foreign and Commonwealth Office needed to replace a non-Millennium compliant Unix system. The new system is required to keep the email address of all UK embassies and legations around the world. Whenever public domain documents become available or when ministers make statements, copies, summaries or details are fed into the system via a Word document. From within Word, the document is catalogued and put on a mailing list. Each mailing list can be a simple list or a list-of-lists. The system is written to ensure that only one copy of the document is sent to an email address even if the address appears more than once. After cataloguing, the document is dispatched to the far-flung corners of the Empire using Microsoft Outlook. About 20,000 emails are sent each month.

Access/Excel/MS Graph

Large car-spares retail-distributor

Database to track rebates from sales. It was important to be able to ask ‘What if?’ questions about the data. An Excel interface was written which allowed Excel users access to the database and to download selected data to be displayed on a graph with a trend line.

Access/Excel

Large electricity Utility

Database to distribute to agencies in order to track and process contracts. Teams of advisers around the country were cold calling on homes and flats and thousands of contracts were being signed. A coordinated approach was needed to ensure quality data, smooth data capture and transmission. An Access 97 database was written that enforced data integrity. At the end of the working day the database produced an Excel spreadsheet which was zipped and emailed to the data processing department. A bar code reader was used to scan the contract numbers, this produced remarkable accuracy in data input.

Access/Lotus Mail

Training department of a large scientific consultancy company

Database to hold details of employees, training history and their needs. It was important to ensure that classrooms, trainers and employees were not double booked. The booking procedure was interfaced with Lotus Notes to allow joining instructions to be sent by email to employees giving details and directions. A bespoke checklist was included for each course as well as the facility to book multi-day and multi-site courses.

Access/Nokia CardPhone/Vodafone Short Message Service

National company specialising in fork-lift-truck breakdown

Database to speed up the handling service calls and the associated paperwork. An Access 2000 database was written to interface with an existing system and to relay jobs to engineers who were equipped with a touch-screen laptop computer fitted with a Nokia card phone. After each job the engineer printed an invoice for the customer and then sent details of the job, spares, mileage and time spent back to base using the Vodafone short message service. The base-station then passed the details back to the main system. A team of 5 engineers have used it for six months. It was well received and has now entered the second phase of development [July 2001] plans are in hand to equip two more teams for further evaluation in areas with limited SMS cover.

Access

  1. Round-the-clock metal finishing company

    Database to meet ISO 9001 requirements and to track work in progress. Speed of data entry was important as, literally, lorry loads of stillage could arrive at any moment. The system holds customer information and prompts the user to record the correct details and processes for each part. At the press of a button a label is produced showing the correct instructions and standards. As the work is shipped back to the customer a delivery note is printed. Later on, a second module was written to utilise the delivery note as the basis of the invoice for each shipment. This simple arrangement has eliminated 90% of telephone queries about what was sent, signed for and billed. A sister company has since taken the package into use.
  2. Local Authority

    Database to replace a non-millennium compliant system that tracked and reported on sickness, absence and leave. The resultant database included a shift diary that handles complex shift and day-off patterns in such a way as to ensure that all absence data is normalised to full time equivalents (fte’s). This data is used to track the authority’s performance. Initially the system was installed as an Access run-time.
  3. Government Department

    Database to monitor the business benefits of a multi-million pound radio system. The database hosts a complex data model which allows the user to extract reports set against individual benefits as well as user experience in meeting a host of different metrics set against that benefit
  4. Supplier of Vehicle Parts

    Database to maintain data for the production of catalogues. This database has been running since 2000, it contains 111 tables.
  5. Fork-Lift-Truck Training Company

    Database to record and acknowledge bookings and to produce lists of students together with their certificates. This database has been running since 2005.
  6. Carer's Charity

    Database to record details of carers and persons who are cared-for together with contact and activity details. This database has been running since 1995.