I do the same thing: copied an Access database created at Delta State
and I love it. I need lists of departmental subscriptions, for standing
orders as well as journals, and I just can't pull it out of Sirsi
without having to do a lot of tweaking. I also use it for our Serials
Solutions list; our systems librarian added a button that I click if
it's to be included; I can also have the dates in the format SerSol
wants them.  And we added all kinds of things, like whether they're put
on display, renewed direct, standing order, etc. and I'm able to pull up
all these various lists without having to maintain separate typed lists.

The beauty of a separate database is that it's so easy to create exactly
what you want/need.

Allison P. Mays
Acquisitions Librarian
Millsaps College
1701 N. State Street
Jackson, MS 39210
601-974-1083
maysap@millsaps.edu

-----Original Message-----
From: Bill Osment [mailto:BillOsment@KCLIBRARY.ORG]
Sent: Thursday, October 09, 2003 10:20 AM
To: SERIALST@LIST.UVM.EDU
Subject: Re: Periodical Holdings List

Sorry to be so slow in responding but I maintain an ACCESS DB created by
my predecessor, (Buddy Pennington, who is a member of this listserv)
that lists our serials and newspapers.  It also contains titles that
have been sent to us but do not subscribe too.  It is very detailed
oriented and covers all departments as well as our branch libraries.
Vendor info, holdings, status changes, etc etc.  At times it can be time
consuming to update it.  You can generate a report that will list all
the titles and the summary holdings, etc and print it out for desk
reference.  Buddy did an excellent job in creating it.

Bill Osment
Periodicals Librarian
Kansas City Public Library.

-----Original Message-----
From: Washkevich, Peter [mailto:Peter.Washkevich@ERAU.EDU]
Sent: Monday, October 06, 2003 9:51 AM
To: SERIALST@LIST.UVM.EDU
Subject: Periodical Holdings List

I am interested in finding out if other libraries are still maintaining
a print list of titles and holdings for their periodicals collection,
which is used at the reference desk and other service points in the
library.  If so, how often do you update it?

Also, is there an electronic version of your list?  In Access? etc.

Thanks in advance for letting our library know what others are doing!

Peter Washkevich
Embry-Riddle Aeronautical University
Daytona Beach, FL