TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
Subject:Re: Creating Catalogs on Excel From:Max Wyss <prodok -at- PRODOK -dot- CH> Date:Thu, 21 Jan 1999 21:56:40 +0100
Alecia,
I think that this could be done in Excel, but may I suggest to seriously
look at a database tool for what you intend to do. Even a simple tool like
Filemaker would do it way better ... and for searching text, Filemaker is
_very_ fast.
A database tool can be set up to make it easier to enter the data, as you
can set it up to display the entry screen for _one single_ article. This
causes less distraction by other items.
Hope, this can help.
Max Wyss
PRODOK Engineering
Technical documentation and translations, Electronic Publishing
CH-8906 Bonstetten, Switzerland
>I'm creating a library/index for the marketing magazines at my company.
>The magazines are used for marketing research. I was wondering if any of
>you have any experience creating something like this in Excel 97. What
>we need is a database that includes a list of the title, issue, and a
>brief summary of the significant articles of each magazine.
>
>What is the best way to approach this kind of indexing as well as make
>it easy to access for the employees when they want to find a magazine
>article, using Excel 97?
>
>Thank you,
>Alecia Lee