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)


 Post Reply Post Reply
Jirí Cerný View Drop Down

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 

Return to free text... buttons enable user to return inappropriately classified entity to 
Additionally, buttons enabling classification reflect the actual status (ie. when the
classification has been already set, button becomes invisible).

Download Access 2003: uploads/8/

Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down