Integrating PDF Forms and Access Databases
Posted on 2009-04-21
Hi there fellas. I am currently contracting for a company that does medical investigations. For quite some time now they have been using a triplicate paper form to report the results of medical background investigations. In addition, they log the search parameters and billing information into an Access database. Every couple weeks they run a billing report using the database. At the end of each billing cycle they have been binding the paper forms, the billing report, and an invoice which is then sent to the customer. Well, the customer has recently expressed their need to go paperless, so my client asked me to convert the documents to PDF in the short term, then assigned me the task of restructuring the process to eliminate the paper form altogether.
I used Adobe Designer to recreate the paper form in PDF format; it took me some time but it looks really nice. It is easy to navigate and enter data, but we are still dependent on the Access database for billing. After the PDF form is filled out, I am still going to have to have them manually enter the data into the Access database. I am beginning to think I got the cart before the horse.
My questions are these: Is there a way to create an Access database from the fields on the PDF form I created, then populate the database with a series of completed PDF forms? Should I have created the Access table first, then an Access form for data entry, then populated the PDF form with data from the database? Am I way off the mark on how something like this should be done?
If any of the above questions are true, how would you go about linking an Access database and the fillable PDF form? I have never worked with ODBC or data connections before, so any thoughts, input, directions or ideas would be greatly appreciated.