Transcript No Slide Title

Cataloging Diversity
PLEC Database
Why Use Access?
VS.
Access
VS.
Excel
Yes
Spread Sheets
Yes
Yes
Link Tables/Relationships
No
Yes
Query and Sort Data
Limited
Yes
Create Reports and Forms
No
UtilityData
Linking Tables With Relationships
SpeciesData
SampleAreas
PlotDescriptions
TreeData
Database Structure From Zarin et al, 1999, PLEC N&V No. 14
Access
Sample Area Table
Contains General Data Describing Each Sample Area including:
• Land Use Stage
• Location
• Researcher
• Sample Area Number*
The plots within each sample area are linked to the sample
area table by a unique number assigned to each entry in the
sample area table.
Access
Access
Plot Description Table
Contains a description of each plot within each sample area number
including:
• Plot Size
• Elevation
• Soil Type
• Plot Number*
Access
Plot Number
• Data are linked by a
unique plot number
designated to each plot
entry
• Within each plot, tables
can be created to hold more
specific data
Access
Species Data
Data can be recorded on
individuals and species within
each plot, including:
• Abundance of Species
• DBH and Height of Trees
• Species Utility
• Species ID Number*
Excel
Access
Species List
In order to avoid problems with misspellings and inconsistency with
names, a species list can be created. A species list can contain:
• Species ID Number* • Common Name • Scientific Name • Family
PLEC/Amazonia
Sample Database
Kevin coffey
New York Botanical Garden
E-mail: [email protected]