Project Management System. This database was developed on behalf of the Landscape Section of the Sports and Leisure Dept.

Benefits
Project labour and material costs are monitored from their inception thro to their completion.
Reports and graphs are generated instantly to give the full picture of any landscaping project.
Comparison analysis can be made against preset budgets and timescales.

Correspondence Tracker. This system incorporates the interoperability of Microsoft Access with Microsoft Outlook and Microsoft Word. Incoming correspondence is scanned onto the network system, basic details about the correspondence is held on a networked Access database. The shell of the reply document is automatically generated and sent as an incomplete task to the person responsible for replying, along with an attached link to the scanned image of incoming correspondence.

Benefits
Reply deadlines are kept in check.
Uniformity and corporate identity ensured in all reply correspondence.
Correspondence type trends easily monitored.
Dramatic time saving by using automation.
Instant retrieval of any correspondence.

Purchase Ordering and Ledger Control System. Multi-user database used by the Environmental Protection Department. In the past it was difficult to assess on a daily basis what the financial position was from day to day with regard to committed costs and actual costs. This system is used as the main purchase ordering system which then uploads any invoiced data directly to the corporate ledger. A reporting utility calculates what the financial commitment is at any point in time.

Benefits
Budgets are tightly monitored for all cost centres.
Enquiries from suppliers can be dealt with rapidly.
Spending trends can be analysed accurately each year.

Customer Database. This multi-user system was developed primarily as a marketing tool. Customer contacts are maintained and product purchase patterns monitored.

Benefits
Purchasing trends can be monitored.
Sales force can respond quickly to emerging trends, thus beat the competition.
Sales promotions can be done quickly and efficiently using the automated mail-shot utility.
Centrally held data ensures that customer records are up to date.

Sales Analysis. Developed for the accounting department, this system uses ODBC. This is the ability to share data with other types of database systems. The linked sales data is queried using a sophisticated reporting utility which collates the information and summarises it in a more meaningful and user friendly fashion.

Benefits
Well designed summary reports aid the decision processes.
Emerging sales territorys easily identified.
Sales data easily analysed from any angle using the power of Pivot Tables.

H&S Accident / Incident Monitoring System. Developed as replacement of an older DOS based database system. Fully networked with extensive use made of User Group security permissions allowing tight control of what can be accessed and edited by logged on users.

Benefits
Accident and incident trends can be instantly monitored at sectional and departmental level.
History of investigation and recommendations maintained for each incident.
Centrally held data ensures that records are up to date.