Print Page | Close Window

Restructure.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Cerný, Jirí
Forum Description: Jirí Cerný's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=210
Printed Date: 28 Mar 2024 at 5:36am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: Restructure.mdb
Posted By: Jirí Cerný
Subject: Restructure.mdb
Date 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: http://www.rogersaccesslibrary.com/forum/uploads/8/Restructure.zip - uploads/8/Restructure.zip



-------------
--

Email: mailto:Jiri.Cerny@pragonet.cz - Jiri.Cerny@pragonet.cz



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net