This organisation used a single user Excel spreadsheet to track many thousands of records. An Access database was developed to:
Track records from input to outcome.
The monthly stats are now produced in one minute, rather than half a day, and at the push of a button.
Flexibility to produce any report through any range of dates.
Automatic generation of standard letters.
Different user levels for security and function.
Ability to create user defined queries without seeing the innards of the database.
Link to e-mail to allow authorisation of tasks.
|