1 / 12

Cataloging Diversity

Cataloging Diversity. PLEC Database. Why Use Access?. VS. Access. Excel. VS. Yes. Yes. Spread Sheets. Yes. No. Link Tables/Relationships. Yes. Limited. Query and Sort Data. Yes. No. Create Reports and Forms. UtilityData. Linking Tables With Relationships. SpeciesData.

sinjin
Télécharger la présentation

Cataloging Diversity

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Cataloging Diversity PLEC Database

  2. Why Use Access? VS.

  3. Access Excel VS. Yes Yes Spread Sheets Yes No Link Tables/Relationships Yes Limited Query and Sort Data Yes No Create Reports and Forms

  4. UtilityData Linking Tables With Relationships SpeciesData SampleAreas PlotDescriptions TreeData Database Structure From Zarin et al, 1999, PLEC N&V No. 14

  5. Access Sample Area Table Contains General Data Describing Each Sample Area including: • Land Use Stage • Researcher • Location • Sample Area Number*

  6. 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

  7. Access Plot Description Table Contains a description of each plot within each sample area number including: • Plot Size • Elevation • Soil Type • Plot Number*

  8. 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

  9. 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*

  10. 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

  11. PLEC/Amazonia Sample Database

  12. Kevin coffey New York Botanical Garden E-mail: Kcoffey@NYBG.Org

More Related