Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > Access-L Developer's Libraries > Cerný, Jirí
  New Posts New Posts RSS Feed - Restructure.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

Restructure.mdb

 Post Reply Post Reply
Author
Message
Jirí Cerný View Drop Down
Contributor
Contributor


Joined: 24 Jun 2008
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote Jirí Cerný Quote  Post ReplyReply Direct Link To This Post Topic: Restructure.mdb
    Posted: 10 Jul 2008 at 5:55am
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: uploads/8/Restructure.zip

Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down