I use Microsoft Access to keep my field notes, storing them as paragraphs in text strings (max: 255 chars) ordered by date and sequence number. An example of raw notes can be seen at:
http://www.schweich.com/fn2007.html#Para20070624 Back at home, I can cross reference to location name data, and photograph data, then as plants come out of presses I can cross reference to collection data, determinations, and vouchers -- ultimately printing labels and updating my web site. An example of this can be seen at: http://www.schweich.com/fn2005.html#Para20050420010 The data base was initially designed for the Carl Purpus web site (http://ucjeps.berkeley.edu/Purpus/index.html) and then adapted for the Annie Alexander web site (http://ucjeps.berkeley.edu/Alexander/indexA.html) and then for my own needs. It works. However, after 11 years including vacation photos, I've got 8500 paragraphs, 2200 photographs, and 7000 cross-reference records, and it's getting a little unwieldy. So far Access seems to handle the volume, but generating the complete web site takes about an hour. Michael Batcher wrote: > Does anyone have suggestions for a database with which to keep field > notes. I use ACCESS, but the text field length is limited. I want to be > able to search notes by date, species, location, and other fields and > develop queries and reports as a result. Thanks in advance. > > >
