Getting data from scanned form

  • Thread starter Thread starter ACE Computers
  • Start date Start date
A

ACE Computers

I need to be able to import data from a data entry form.
Form consists of a variable number of records per page.
and each record consists of 3 sets of 9 check boxs, that
will have 1 box filled, in each set and imported into a
data mask, for a data record. Each form will have a
variable number of records but not more than 1 page or 50
records.
 
ACE said:
I need to be able to import data from a data entry form.
Form consists of a variable number of records per page.
and each record consists of 3 sets of 9 check boxs, that
will have 1 box filled, in each set and imported into a
data mask, for a data record. Each form will have a
variable number of records but not more than 1 page or 50
records.
Click to expand...

This one is not likely to be easy.

The first step will be the scanning process. The scanner and OCR will
have a lot to do with how easy it turns out. I hope your data will always
be located in exactly the same location on the document. Consider making a
mask either physical or software based. It might prove easier to bring the
data into Excel first and then into Access.

How much volume are you looking at? Do you have any dedicated data
readers for the project?
 
Why did you post? You haven't asked a question nor asked for specific help.

What is the form and current residence of the data? What have you already
tried to do as far as importing it is concerned? What didn't work? How
does one import data from a form?

What is your data structure? What are the entities involved? The tables
are the cornerstone of the application, get them right and everything else
is possible. Just what is a data mask and how does one import to it?

What are the things that you've already tried so that we don't foolishly
suggest the same things?

It's pretty well understood in the newsgroups that by posting a single issue
and providing as much data as you can from your end will give you the best
chance of getting meaningful responses. Posts that take the form "My life's
a mess, help me". don't do so well.

Access is a very powerful tool but it has a steep learning curve on the
front end. There are some basics that you have to learn early or you'll pay
a horrible price in work redone, data lost or corrupt and un-maintainable
applications that have to be redesigned and re-coded before they can be
enhanced. What it isn't is a flawed version of Excel. That's the most
common misconception. Like any of the other MS Office applications the most
important early learning is to learn to use the application interactively.
Once you're familiar with it interactively then the concept of an object
model isn't so foreign.

There are lots of books about Access. Lurk your local Barnes & Noble and
Borders bookstores. In a pinch there's always amazon.com and even MS Press
and O'Reilly. There are over 20 newsgroups devoted to Access. This one is
kind of an omnibus group taking in everything from the wading pool to the 10
meter platform. There are others devoted to specific elements or levels of
expertise: microsoft.public.access.gettingstarted, tablesdesign, forms,
etc. It's good manners to post only relevant issues into the more specific
newsgroups. A good Access resource is www.mvps.org/access It's worth the
trip to get in and poke around and, aside from the goodies you'll find
there, it has links to other resources.

HTH
 
Back
Top