Central Illinois Library Micro User’s Group Meeting
Randy at Parlin-Ingersoll Library in Canton, IL sent word that
their second meeting of this academic year will be held there on
Friday , Nov 15. There will be mini-course on Appleworks, PFS-File
and a day of software demonstrations. If you want more info,
drop them a note at 205 W.. Chestnut, Canton IL 61520. You’d better
hurry if you’re interested.
Tooks and Turborgs
The good folks at the Ministry of Education / Provincial
Educational Media Center (7351 Elmbridge Way, Richmond BC V6X 1B8)
sent a copy of their excellent Evaluations: Microwave.
They have switched to Mac output (looking good, hey!) and
evaluations include product info, descritpions, Strengths /
Weakness, and potential use. Nine issues per year with an annual
index for $50. Top notch evaluation tool.
“We hear Wordstar is hard to learn”
Comedy by Wire ($9/year: Billiam Coronel, 431 W.
45th St, NY NY 10036) reports that the government of
India purchase an Apple ][c mail ordered from a Computerland in
Barstow, CA to show the world they “are serious about technology”.
They purchased the machine mostly for national budgeting and word
processing. When asked why they chose PFS:Write for software the
response was “We hear Wordstar is hard to learn.” Constant humor,
and a real gas.
Be Youse Own Consultant (part Third)
We’ve covered word processing and spreadsheet to this point,
and now it’s time to get to the tool you’ll use most often – the
data base.
A data base is an electronic version of the steel file cabinet.
A drawer is a file in computer lingo; a folder turns into a record,
and each individual piece of information is a data base field. Each
field (in most data base software anyway) has a length which is
known as a “field length”. If you add these lengths up you know how
big the record is and if you multiply the number of records by their
length, you can get the file size. If you don’t know how big the
file is going to be, you will face problems later on .
I always recommend that folks start out with small files,
things like an AV equipment inventory, periodicals holdings, film
bookinsg or a software listing. Learn by playing around, the
software will show you it’s strength: sorting.
You use a data base to manage information that needs to be
viewed in several different ways. You want to know what
periodicals come due in October or what periodicals go to a
particular department or a higher level queery such as the cost of
the periodicals going to the Philosophy department (read branch
library) or perhaps the cost of your entire periodical collection.
Some of the information is used for library management – other
elements are used for providing users complete holdings information.
The data base gives you the power to display the same information in
a variety of ways.
In developing an application for the data base, consider
first what you want out of the file. Create fields that will
report that information, keeping in mind the operational
capabilities such as how many and what kind of sorts will the
program allow you to perform.
Here’s a simple example of a data base mailing list:
It’s a file of the producer contacts I use for the December
Buying guide. In this particular display there are fields for the
contact’s name, the company, their street adress, town, state, and
zip. The display shows only the information I use for mailing
labels, but also includes fields for their product names, the
hardware it runs on, the cost, and some notes. Because it is
flexible (Microsoft File for the Mac to be exact) I can do a
lot of things with it but you can do the same programs such as
Appleworks or DB Master on your ][ family
hardware and scores of others.
The trick is to get a multi-function data base. Remember the
Wired Librarian’s first rule of software – the more power a
program has the harder it is to learn - so expext some
difficulty in getting this one up and running. If you stick with it
you’ll find a lot of use.
By now I hope you have played with your word processor,
spreadsheet, and add the data base this month. We will move next to
library utility software – which believe it or not are usually
canned data bases.