How do I create a form using excel that uses large text fields and will allow the info to be easily searched?

Question

In our company we create a text file using Word that stores a customer's information when they call, such as technical support. This method of an individual file per customer takes up too much space and does not allow easy search-ability or even organization.

I have already created a form in Adobe Pro but the method for gathering and then changing the same information was too complex. We need something that is easily searched immediately and can be changed and saved without hassle. A standard table in excel would be adequate except that we use large text fields for specific transaction information and it would make the table too large, cause constant scrolling, and it wouldn't be easy to read. Any help is appreciated!

Thanks!

Answer 1

from what you are describing...it sounds like you want to look into Microsoft Access or some other database.  openoffice has a free data base(i have it, but i havent ever seriously used it).

Excel (and Calc) would have the same search problems as Word. the only benefit that excel would have over word is that you might be able to make a pivot table out of your customer support call categories (but thats not much of a benefit for what you are doing)

hope this helps