The form below contains about 50 dynamically overlaid forms for selection of
query parameters. The parameterized queries are used to analyze chemical constituents within
the sediment core samples.
This data analysis screen provide the user with capability
to select and filter from literally 100's of data fields within a
sediment core data set. The form also provides for
multi-parameter comparison of chemical constituents. All queries are
created dynamically in VBA code. This single query screen gives the user the ability do cross subject analysis for correlation
studies and to analyze data for the following subjects:
Microsoft Access is a fully capable database and it's primary limitations is the number of concurrent users it will support. The number of users supported depends on the transaction load and the amount of data but generally we recommend a limit of 10 to 15 users.
We also have 100's of programming examples from simple to complex. You can jump to our Access tutorials here. Visit our contact page if you have comments or questions.
- Numeric Biology Data
- Descriptive Biology Data
- PHI (grain size)
This form looks fairly simply at first glance however the complex queries
generated behind the forms reached the limit of Access's capabilities.
Literally millions of data points where analyzed within a few minutes of