30 January 2009

Real World Access (40)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.

 Jeanette Cunningham's Roads and Bridges

kangarooParkRoads is an MS Access based road and bridge asset management program.

It is designed for use by rangers and other road management staff in Parks Victoria, a national park management agency, in Victoria, Australia.

The program:

  • records assets on roads, including the road surface;
  • assesses the condition of the asset;
  • develops works schedules for maintenance and upgrade works;
  • calculates repair cost estimates;
  • prioritises works based on structural condition and cost estimates;
  • tracks progress of works.

Reports can be generated on screen, in Access templates, or exported to Excel worksheets.

Photographs, technical reports, and assessments can be attached to the database.

The program is designed to be intuitive for non-engineer type road managers, and does not require extensive training courses.


Post a Comment

Links to this post:

Create a Link

<< Home