Exporting Word Form to MSAccess form

[osimini1]

Is there any means or possibility of importing or converting word form to access form. Best yet using word form as a data entry form and access as a database.

Thanks for your help.

 

[MajP]

Sure you can use a word for as an entry form. Here is an example:

http://blogs.techrepublic.com.com/howdoi/?p=187

There are several ways to do this depending on how you want to interact with the DB. Do you want the db open and have it launch the form? Do you just want to enter data in a form and never open the DB?

Provide a little more detail on exactly how you want to do this.

 

[osimini1]

Thank you very much.

What I want the db open and have it launch the word form and then to enter data in a form and never open the DB. OR to enter data in a form and never open the DB. The attached is the word form that I am talking about. Any solution to this. Please help.

Form Sample

Doctor’s First Name: <<First_Name>> Last Name: <<Last_Name>>
License #: <<License_No>> Primary Specialty: <<SPEC_DESC>>
Please fill in the box for your desired response. Acceptable: ? ? ?

Scheduling an Appointment

Q1. What days of the week does this doctor have office hours at this location?
? Monday ? Tuesday ? Wednesday ? Thursday ? Friday ? Saturday ? Sunday

Q2. Please record the number of calendar days until the next available appointment. If longer than 5 days, please write in the number of days on the line.



A. An urgent medical condition Same Day 1 2 3 4 5 Other
? ? ? ? ? ? ____
B. A non-urgent (routine primary care) medical condition Same Day 1 2 3 4 5 Other
? ? ? ? ? ? ____
C. A child’s annual physical exam Same Day 1 2 3 4 5 Other
? ? ? ? ? ? ____
D. A child’s preventative health/CHDP visit Same Day 1 2 3 4 5 Other
? ? ? ? ? ? ____


E. A child’s Initial Health Assessment (IHA) Same Day 1 2 3 4 5 Other Same Day 1 2 3 4 5 Other
? ? ? ? ? ? ____ ? ? ? ? ? ? ____


F. A Sexually Transmitted Disease Same Day 1 2 3 4 5 Other Same Day 1 2 3 4 5 Other
? ? ? ? ? ? ____ ? ? ? ? ? ? ____
G. HIV testing and counseling Same Day 1 2 3 4 5 Other Same Day 1 2 3 4 5 Other
? ? ? ? ? ? ____ ? ? ? ? ? ? ____
H. Minor consent services Same Day 1 2 3 4 5 Other 9 10 11 12 13 14 Other
? ? ? ? ? ? ____ ? ? ? ? ? ? ____
I. Pregnant women services Same Day 1 2 3 4 5 Other Same Day 1 2 3 4 5 Other
? ? ? ? ? ? ____ ? ? ? ? ? ? ____
Q3. Please record the number of calendar days. If longer than14 days, please write in the number of days on the line.
Same Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Other
A. For approval for a specialty referral ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ____
B. For an urgent specialty appointment (once referral is approved) ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ____
C. For a routine specialty appointment (once referral is approved) ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ____

Specialty Care Difficulty

Q4. In what areas of specialty care do your patients have difficulty obtaining an appointment, and why?
Area of specialty Why it is difficult to obtain a specialty care appointment (check all that apply)
Scarcity of specialists practicing in this field Scarcity of specialists in geographic region No Pediatric specialists – must use non-Ped specialists Specialist will not take Medi-Cal Other reason
A. ? Dermatology ? ? ? ? _____________________

B. ? ENT ? ? ? ? _____________________

C. ? Gastroenterology ? ? ? ? _____________________

D. ? General Surgery ? ? ? ? _____________________

E. ? Neurology ? ? ? ? _____________________

F. ? OB-GYN ? ? ? ? _____________________

G. ? Opthalmology ? ? ? ? _____________________

H. ? Orthopedics ? ? ? ? _____________________

I. ? Other_____________________
? ? ? ? _____________________

Q5. What additional barriers do you believe impact patients’ access to health care services?
_________________________________________________________________________________________________________________________
Q6. L.A. Care’s Specialty Care Liaison program helps members and providers locate hard-to-find specialists and obtain timely appointments. Would you like to receive information about the program? ? Yes ? No

Appointment Types

Q7. How are patients seen at your office? ? Appointment ? Walk-in ? Both

Q8. If you take appointments, do you send reminder cards before scheduled appointments? ? Yes ? No ? No Appointments

Q9. Do you follow up with patients who miss or cancel appointments? ? Yes ? No

Q10. Does your office staff use e-mail to communicate with patients? ? Often ? Sometimes ? Rarely ? Never



In-Office Wait

Q11. From the time a patient walks into your office, about how many minutes do they wait:
A. Before being taken to an exam room? _______ minutes
B. Before being seen by physician? _______ minutes

After Hours Access

Q12. What type of after hours answering system do you use?
? Professional Exchange Service – live telephone support when physician’s staff is unavailable
? Automated Answering System – pre-recorded message that offers the caller options to connect to a live party or page a doctor
? Answering Machine – pre-recorded outbound message and option for caller to leave a message
? No after hours answering system
? Other: ______________________________________________________________________________


Q13. How do patients reach a covering physician (if available) after normal office hours?
? Physician is paged by exchange service and calls patient back
? Answering system has option for connection to physician
? Answering system has option for connection to a nurse advice line
? Answering system has option for patient to leave a message and the call is promptly returned by a physician or nurse
? No option to reach a physician is currently available
? Other: ________________________________________________________________________________


Q14. If you use a professional exchange service or triage nurse, how are they instructed to determine when a patient should be referred to the emergency room vs. a nurse advice line vs. a covering physician? (check all that apply)
? Written guidelines are provided by your office
? Referral is at the discretion of the exchange service/nurse
? The physician is always paged
? The physician is paged if the patient requests it
? Other: ________________________________________________________________________________





Office Demographics

Q15. What languages are spoken by the physician, staff, and patients? (check all that apply).
Physician Office Staff Patients
English ? ? ?
Armenian ? ? ?
Chinese ? ? ?
Farsi ? ? ?
Khmer ? ? ?
Korean ? ? ?
Russian ? ? ?
Spanish ? ? ?
Tagalog ? ? ?
Vietnamese ? ? ?
Other: _____________________ ? ? ?
Other: _____________________ ? ? ?

Q16. Are you aware that L.A. Care Member Services can coordinate interpretation services for your office when needed? ? Yes ? No
Q17. Have you ever used L.A. Care to coordinate interpretation services for your office? ? Yes ? No
Q18. Has anyone from your office received Cultural and Linguistic training from your contracted HMOs? ? Yes ? No
Q19. What is your relationship to the physician listed on the front page of this survey?
? Self ? Different physician ? Nurse/NA ? PA
? MA ? Office Manager ? Office staff ? Other: ______________
.

 

[MajP]

You can do what you want. Fill out a word form and then without opening the DB then have a procedure in the form that you can select to add a record to a database. Or do it the other way where you are in the DB and click on a form to import. What is preferred? If you want a demo pick one because the coding is different.

The question is how good is your vba. We can provide you the general code and a demo to do the following
1)connect the form to the database through ADO
2)Show how to read data from fields and insert records into a table

But the specifics of putting all the correct data in the correct field will have to be up to you. It would require a detail understanding of your database structure to do anything more.

A bit of caution, because survey data always makes me nervous. Although it often looks like a simple survey, survey database design can be extremely difficult to normalize the table structures. Survey db's can have very complicated relationships and most people get it wrong.

many people to many questions
many questions to many answers
many tests to many questions
etc.

Just qestion 15 could be very difficult to design. You could get a very complicated many to many to many to many relationship.

So I would not yet worry on pushing the data from a form into the DB. That will not be overly complicated if you can get your tables correct. Making the connection and insert a record will not be that complicated. Having the correct table design into which to insert it will be complicated. Once you have your tables set up, then you will probably tweak your question design and answers to better support your data structure. Do not be a slave to the form, but design the questions and form to support data entry.

So the question is, if a general demo is enough to get you started? If not you will need to finish your database and see if you can manually add records into your db. Then if it makes sense, you will have to post your db and the proposed form.

 

[osimini1]

Thank you very much. I decided to stick to access form rather than word