This program demonstrates how disorganized data (such as obtained through
import of poorly structured plain text data file) can be restructured. Manual action of
the operator is facilitated to transfer data from table tblFreeText (which contains
string data (free text), to table tblProcessed, each record in both tables is identified
through DOC_Name (PK in tblProcessed, FK in tblFreeText).
Each record in tblProcessed can gain value of certain attribute (in this example
State, Town or Person), however human operator most decide which unstructured
record from tblFreeText is to be considered State, Town, Person or left aside. In
other words tblFreeText records have to be classified and copied to tblProcessed
appropriate fields.
Classification is done through click on "buttons" (in fact text boxes) and
consequently string is copied to the tblProcessed and in the same time deleted from
tblFreeText.
Return to free text... buttons enable user to return inappropriately classified entity to
tblFreeText. Additionally, buttons enabling classification reflect the actual status (ie. when the
classification has been already set, button becomes invisible).
Download Access 2003: http://www.rogersaccesslibrary.com/forum/uploads/8/Restructure.zip - uploads/8/Restructure.zip
------------- --
Email: mailto:Jiri.Cerny@pragonet.cz - Jiri.Cerny@pragonet.cz
|