Logo

Computers

Home Sales & Repairs Database Design References Contact Us

Aquabase

Some time ago Toast was approached to design a full and complete management and archiving system for a water scientist.

The scientist required access at the click of a button to many files including library, clients, projects, sites, samples and, ecology and water standards. All this information needed to be linked together because clients had projects, projects had sites, sites had monitoring results and then a system was needed to record, archive and report on these results.

The result to all those requirements was AQUABASE.

AQUABASE is ten relational databases that are interrelated (i.e. talk to each other), enabling you to record & report water analysis information at the click of a button.

AQUABASE is amazingly powerful yet small in size. This gives the user the ability to store the programme on a wide variety of computers.

One of the integral links for all the relational tables, the Clients file stores all the data relating to your client including, name, address, contact and phone / fax details.

Clients can have many projects, this gives the user the ability to have clearly separted projects and retrieval ability. Projects are stored along with a Site ID, Site Description, the Analyte and Method required to be tested. All of this information is available in drop-down boxes.

The Sites database will record all the information relating to each of the sites as registered in the Projects Database. It has many valuable fields including map reference (easting and northing fields for referencing to GIS). It is capable of storing a picture of the site and does so with minimal effect to your hard drive space.

AQUABASE records the result of findings related to each site, which is of course related to the project and the client. AQUABASE has the ability to calculate additional information from received results (such as DIN, TN, DON and TON from component parts).

AQUABASE can also assign a fail or pass according to the analyte selected, it does this by comparing information against known standards, (in essence a simple decision support system (DSS)).

Aquabase allows the water scientist or user to forget about all those hours that are spent calculating Taxa, EPT, Total individuals and MCI. AQUABASE will do it all for you through the Ecology Database. Simply enter from the drop-down boxes, the species and result and AQUABASE will match the family and order and calculate the total Taxa, EPT, Total individuals & MCI. The ability to use alternative Metrics can also be easily accommodated. The KEY message being that this database can be customised for the individual user/s.

Access at the click of a button

The scientist required access at the click of a button to many files including library, clients, projects, sites, samples and, ecology and water standards. All this information needed to be linked together because clients had projects, projects had sites, sites had monitoring results and then a system was needed to record, archive and report on these results. The result to all those requirements was AQUABASE.

© 2017 Toast Computers. All rights reserved.