**ABSTRACT NOT FOR CITATION WITHOUT AUTHOR PERMISSION. The title, authors, and abstract for this completion report are provided below.  For a copy of the full completion report, or with questions, please contact the GLFC via email at stp@glfc.org or via telephone at 734-662-3209.**

Development of a lakewide electronic database for lower trophic level monitoring in Lake Erie

Timothy B. Johnson¹, Elizabeth Trometer², Nick Preston³

¹ Ontario Ministry of Natural Resources

Lake Erie Fisheries Station

Wheatley, Ontario N0P 2P0

²US Fish and Wildlife Service

Lower Great Lakes Fishery Resource Office

Amherst, New York 14228

³ 44 Bedford Crescent

Ottawa, Ontario K1K 0E5

January 2003

ABSTRACT:

The Great Lakes Fishery Commission (GLFC) Coordination Activities Program supported the development of a database for managing information and reporting on the state of the lower trophic levels in Lake Erie. The database was developed in MS Access, utilising modules created in Visual Basic to analyse and export data to MS Excel. The database provides a user friendly environment accessible to all Lake Erie agencies to provide timely updates on the state of the Lake. Information is reported annually in the Lake Erie Forage Task Group report.