Desktop Database for Researchers

This Microsoft Access database and its interface program were developed specifically for the ATBI.
Numerous provisions have been made to support data and collection protocols that differ according to the organisms being studied, but share many features common to all of these projects.
Indeed, this database can be portrayed as a composite of individual project databases sharing the same format and interface.
Accordingly, some data can be analyzed globally across all projects, while other data fields are strictly organism and/or protocol dependent.

Components to Download:

Data Entry:

Site Coordinates:

Exact coordinates of collection sites are part of this inventory.
- We expect GPS readings to be checked by displaying point locations on a topographic map.
- If you do not have a GPS, marking the collection site on the map and reading off coordinates is acceptable.
- GPS instructions are available at Guidelines for Collecting GPS Data.
Park maps are available at Quad Maps of Great Smoky Mountains National Park.
- If you do not have software for easy map display and coordinate editing, free software is available on CD to researchers with collecting permit in the Park at NPS Research Permit and Reporting System.
  - A tutorial is available for this mapping program - validating_coordinates.pdf (514 KB).

Submitting Data:

If you use our interface program to enter new data, you can ship us the data file ATBI_data.mdb (or renamed) either zipped as an e-mail attachment to Michael_Kunze@nps.gov, or simply copied on CD by mail.
- Michael Kunze
  Great Smoky Mountains National Park
  1314 Cherokee Orchard Road
  Gatlinburg, TN 37738
If the above option does not work for you please contact Michael Kunze (865-436-1703) so we can try our best to accommodate your needs.

Technical Information:

The structure of the database can be visualized by a diagram showing the Relationships between Tables - access_relationships.pdf (78 KB).