| |  | |
FORESTERS'
TIPS, TECHNIQUES,
AND
TRICKS OF THE TRADE | | |
 P-8-ABASE
When advisers or consultants are starting work on a new project and/or country, they need to quickly
put together
information from a wide variety of sources. One adviser has solved this problem by creating a
very simple database which
can be used for eight (or more) classes of information - places, people, practices, products, publications,
homepages, and
miscellaneous such as phrases, words etc.
(hence the name) The database uses a spreadsheet (ideally EXCEL) format. One line is one record. Each
record has 9
fields (columns A-I). Each field/column is used for differing information depending on the class of
information. See the table
at the end of these samples for an explanation:
The records can be sorted according to class of information, and searched and filtered as required.
Codes can be
used to search on specific expertise or subject. Use the first 4 or 5 letters of the word (e.g. AGROF
for agroforestry). It is
easy to transfer parts of the records to a word processor and presented in tabular form.
|
