Introduction to ChemPoint


The ChemPoint Database

See Also:

Client/Server Database


The ChemPoint Professional database has the following features:

  • Data stored in Microsoft Access 2003 (or later) format or MS SQL Server Database
  • ChemPoint access the database using Microsoft ActiveX Data Objects (ADO) technology
  • Open architecture database design
  • All data for a facility are stored in a single MS Access database file with an MDB extension or MS SQL Server Database
  • Store data for multiple facilities in a single database, or use multiple databases
  • Supports multiple user access in a client/server environment



The ChemPoint User Interface


Tasks that you perform in ChemPoint are organized into the following views:



Views are selected from the View menu, or from the Views shortcut bar in the left pane of the ChemPoint main window.


image\SHORTCUT.gif Entering Data


There are two general methods for getting your data into ChemPoint.


  1. Import data from an existing database, as described below.
  2. Enter data manually.


To enter data manually, select the appropriate view as described above. In most views, you can double click on any data item to edit data for that item. Right-mouse click in any view to access a context sensitive menu for that view. Most context-sensitive menus include commands to add new data.


When starting a new facility, you should enter data in the following order:

  1. From the Facility Selection View, create a new facility, or import data for a facility.
  2. From Data | Edit Facility Data, enter facility specific information such as name, address, and locations.
  3. Use the Dates and Locations view to enter data for all of the sampling points such as monitoring wells and soil sampling locations.
  4. Enter data for each sampling date at the time you prepare the sample containers for the sampling event.
  5. Use the Sampling Event view to enter the data for each sampling container at the time you prepare the container for the sampling event. You may ignore the sampling containers if you choose. ChemPoint will create containers automatically as they are required.
  6. After receiving the analysis for each container, enter the final parameter concentrations in the Post Analysis view.



image\SHORTCUT.gif Importing Data


ChemPoint provides powerful data import capabilities for competing products, and for custom formatted databases in dBase, MS Access, MS FoxPro, or tab-delimited text files. You can create a new facility database by importing data from an existing database in the following formats:


Use the Universal Importer if you want to import new data to an existing ChemPoint database. The Universal Importer will allow you to import data from dBase, MS Access, MS FoxPro or tab-delimited text database files. You can also use the Universal Importer to import data from these database formats into an all new ChemPoint database.


Refer to the ChemPoint User's Guide for more information on importing these types of files.


image\SHORTCUT.gif Exporting Data


You can export data to the following formats:



For greater flexibility when exporting to text files, you can export any of the reports to a tab-delimited text file.



image\SHORTCUT.gif Creating and Printing Reports


ChemPoint includes eleven basic styles of printable reports. Each report can be customized with respect to fonts, colors, borders, and in many cases, data fields displayed in the report. You can also limit reports to specific dates, locations, and parameters. There are many other options as well. Customized reports can be saved as template files and used later. There are also options for how non-detects are represented.


You can also export reports to a tab-delimited text file. This is one of the most powerful method of exporting data from ChemPoint.



image\SHORTCUT.gif Creating and Printing Well Diagrams


ChemPoint can create and print professional quality well construction diagrams. Diagrams are drawn using one of many available style templates. Templates control fonts, colors, and diagram styles. You can use one of the templates included with ChemPoint, or create your own. Diagrams are also drawn to specifications for each well. There are four diagram styles available for wells. These are piezometer, monitoring well, open hole pumping well, and screened pumping well. Pumping wells are drawn with a lightly larger diameter than monitoring wells. Diagrams are also drawn with materials, pad, and flush mount as specified for each well.