How to add bird sightings?
Data are added by using forms. Every new bird sighting would include data for the following fields: Date, *Species name (common), *Trip Name, *Location, *Birder Name and Sighting Notes among others. Fields preceeded by an asterisk (*) are entered from popup lists which ensure uniformity and consistent spelling for table relationships to work. I had elected not to include fields to store time, plumage, vocalization, abundance/rarity and numbers etc to keep the size of the tables down and to make the database simpler but if these data are important, they can be entered in the Sighting Notes field which is a memo field. There are two forms (SightingsDetailForm and SightingsSimpleForm) available to add your data but you need to use only one of them. The former allows you to view species related data such as size and scientific names during data entry but has a smaller area for SightingNotes. The latter has a larger area for SightingNotes. Since some of the data are entered from popup lists