<%dim crumb crumb="Database Snapshots > Chemical Constituent Analysis" %> Sediment Core Analysis of Offshore Core Samples Database Example
Home  Fees/Services  MS Access Templates  MS Access Tutorial  Access Download  Articles  Search  Forums  Blockchain Tech  Contact  Privacy  Links
Access Programmers & Database Consultants

 Home > Fees & Services <% response.write "> " & crumb %>

Getting Started
Customer Support
Why Blue Claw?
Consulting Rates
Consulting Credentials
Clients' FAQs
Visitor Feedback
Recent Clients
Database Conversion
Programming Quickly
Access Templates

Access Screen Samples

<% dim Gnum,Ynum Gnum="1388500666" Ynum="26695" %>

Chemical Constituent Analysis of Sediment Core Sample

Demonstration of Complex Query Form for Constituent Analysis of Sediment Core Samples

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:

  • Chemistry
  • Numeric Biology Data
  • Descriptive Biology Data
  • Mineralogy
  • Lithology
  • PHI (grain size)
  • Stratigraphy
  • Texture

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 processing time.

Sediment Sample Core Analysis Query Definition Form

Contact Information

<% Response.write "Copyright 2000-" & year(now) & " Blue Claw Database Design" %>