Jon,
If you are looking to develop an in-house insect pest database, check
out the recommended field list published by the International IPM
Working Group on their website
(http://www.museumpests.net/monitoring.asp).
The ZPEST database (also linked from this site) might also give you some
ideas.
As a practical guide, in order to be able to make use of pivot tables
and graph tools to analyse the data, I would aim to develop a base table
that for each separate insect species caught in a trap on a given date
there should be a new row. In other words for a trap checked today
(21/11/2011) containing 3 anthrenus sarnicus casts and 2 silver fish,
there should be 2 rows.
For data entry this layout is far from ideal, so if you can design a
data entry screen that has a nested table for the insects within a
single 'trap event' record this will speed up data creation.
The NHM has migrated its data from Excel to Access and now to KeEMu
(screen shots attached). If you would like more info on the structure,
perhaps we can talk off list?
cheers
David Smith
Collections Manager (Petrology, Ocean Bottom Deposits, Foreign Building
Stones)
Natural History Museum, London
[log in to unmask]
-----Original Message-----
From: The Natural Science Collections Association discussion list
[mailto:[log in to unmask]] On Behalf Of Jon Radley
Sent: 21 November 2011 12:15
To: [log in to unmask]
Subject: Pest-check tables
Dear All,
I'm seeking examples of simple pest-checking record tables. Do you have
anything that I can adapt for use at the Warwickshire Museum?
With thanks,
Jon Radley
[log in to unmask]
|