In order to make the data more handy and to be able to produce reports from the data, we developed an IPM database.  The main table in this database is the observations tables.  (We have a separate observations table for each of the two floors in the building.  I will explain the need for two tables later.)  This table is quite simple.  It contains only a limited number of fields describing each observation event: type of pest (name), location (sector), the date, life stage of the pest (age), whether living or dead (status), number of individuals seen (at one location), and the risk factor (high, moderate, low or none).  The pests, age and status tables provide the data to be used in drop-down lists on the data entry form.