To start...I am new to access, very new.
I opened my mouth and said I thought that access would be the best
application to house and retreive all of our marine monitoring data (fish,
coral and oceanograghic info) and now I am charged with that task. I have
already built a db for the fish monitoring part and my access research
thus
far has led me to believe that it is not very good. So I turn the the
forums.
A little about the fish work:
Once to twice a year we conduct a fish census at certain reefs. The
census
consists of counting all the fish in binned size cl***** (0-5cm,
6-10cm...)
within a certain area (transect). At each site we conduct 10 transects.
I currently have three tables:
tblFish_names:
family
genus
scientific name
common name
primary trophic level
secondary trophic level
param_a
param_b
tblSite_description:
site
strata
latitude
longitude
tblMaster:
site
month
year
transect#
scientific name
0-5cm
6-10cm
11-15cm
and so on
tblMaster holds the meat of the information and gets very redundant when a
single transect get 50 different species on it.
Could somebody please provide me with some guidance and direction for this
database? I hope to use what I learn from this fish section and apply it
to
the other marine monitoring sections.
Thanks for the help in advance.
Cheers
Jeremiah
