Microsoft Word/working with forms

Advertisement


Question
QUESTION: hi Richard, how've you been?

I'm learning about forms. I'm trying to understand how I can use the Legacy Tools approach. My focus is on saving only the form data.
One book tells me that in the resulting text file, "the data is
comma-delimited with quotation marks around text entries". The book gives an example:
"Sheri Harris","10783 Westwood Place","Anderson","In","46282"

I've assumed that the benefit of using on-line forms to be filled in, is to amass a fairly large amount of such data as in the example above, not just a single piece of data.
I'm thinking that employment applicants would be asked to fill in such forms, or current employees would use these forms to ask for specific vacation time. These forms would then be forwarded to say, Human Resources, who would create a database using the entries made by the applicants (in the first case) or the employees (in the case of vacation time requests).

So what I want to know is how to take these comma-delimited data and put them in a database. If such procedure is to manually move or copy the data from each filled-in form to say, an Excel or Word database, it looks to me that using the form is a waste of time. The person filling out the form might as well fill out a paper form!
Have I got this business right, or am I missing something? the book does not go further to explain how the filled-in data is then processed.

I hope my question is clear.

thanks and Happy New Year.

Chris

ANSWER: Hello Chris

Just getting over a bad bout of flu, thanks for asking.  This link will give you an example of what you can do with the comma delimited data to an access database.

http://office.microsoft.com/en-us/access-help/import-or-link-to-data-in-a-text-f

It can also go to an Excel spreadsheet but database has many more options for gathering and sendind out data.

Richard

---------- FOLLOW-UP ----------

QUESTION: 'Hope you're feeling better, Richard!

Thanks for your reply.
Can you give me a reference, i.e., tutorial, or what you know, as to how to use Excel for this task. I don't have access to Access (ha-ha)?

Thanks again.

Chris

Answer
Chris

Here are a  few options depending on your operating system,

http://office.microsoft.com/en-us/excel-help/import-or-export-text-txt-or-csv-fi

http://office.microsoft.com/en-us/excel-help/import-or-export-text-txt-or-csv-fi

Once you have got the information into excel you can then play around with the database options in excel (again depending on your version of excel)

Richard
About Microsoft Word
This topic answers questions related to Microsoft Word stand-alone or Microsoft Office Word including Word 2003, Word 2007, Office 2000, and Office XP. You can get Word help on formatting text, tables, tabs, fonts, styles, general Word layouts, bullets, headings, and outlines, using templates, toolbar modifications, and using Track Changes. You may also find tips on linking Word and Excel embedded objects including charts. This site does not provide a general Word tutorial nor the basics of using a word processor. It provides specific answers to using Microsoft Word only. If you do not see your Word question answered in this area then please ask a Word question here

Microsoft Word

All Answers


Answers by Expert:


Ask Experts

Volunteer


Richard Stephens

Expertise

I have used word up to advanced, including Macros, very limited VBA. Basic to advanced questions are welcome. Currently using Word 2007 and 2010 but will try to recollect for earlier editions.

Experience

Teaching and business training for the last 15 years as well as running my own small business.

Education/Credentials
Adult Teacher and Retraining for Work Experience

©2016 About.com. All rights reserved.