MS Access Business Administration

The Problem

The existing work flow system had "evolved" using a series of Excel spreadsheets. The recording of information from application forms was a time-consuming manual process. Furthermore, a strong involvement by management was essential, as there was no reliable mechanism in place for checking the information as it was entered, nor was there an easy way for key staff to track the completion of individual applications and the receipt of funds, and to report on each stage throughout the process.

The Solution

As the financial products sold are highly specialised, with many checks and procedures required before each application for investment is accepted, we developed a custom work flow system that mirrored this multi-stage process.

By creating a simple to use multi-user database using Microsoft Access, staff were able to process applications quickly. New data input forms restricted the choices available to valid options for each product, improving the accuracy of information entered. With custom validation, work could be delegated to more junior staff, freeing up senior staff for other responsibilities.

With instant reporting, management can now track the exact financial position at any stage of the process. Custom reports track numbers of applications for each phase at any time. In addition, the calculation of commission payable is now automated and can be easily configured on a product by product basis.