Help on creating a journal tracking dabatase? Dale LaBonte 13 May 2005 16:33 UTC

I am developing an Access database of our (fewer than 400) journals to
be able to identify and track them from year to year for
decision-making.  I want to incorporate academic department, use data,
pricing, and online availability.  My search of the Serialist archives
brought up a discussion in 1997 about which database software people
were using, but not how they are using it.  If there has been a more
recent discussion, maybe you could point it out to me.

A colleague who attended ACRL brought to my attention the poster session
from U. Wisconsin-Eau Claire:

Quick Cooperative Serial Cancellation: An Evidence Based Approach for
Gaining Faculty Support
Ronadin Carey, University of Wisconsin, Eau Claire; Steven Elfstrand,
University of Wisconsin, Eau Claire; Renee Hijleh, University of
Wisconsin, Eau Claire
Poster 15

I found Stephen Elfstrand's description of his database very helpful in
the powerpoint file he created, but the elements of his database aren't
exactly what I had in mind, which got me wondering what other librarians
are using for database fields and reports.

Do you have a database or spreadsheet that you are using to track your
periodicals?  Would you be willing to share the names of the fields you
use?  If you create reports for campus departments and/or
administrators, would you be willing to share an example?

If you are working in Access, could I call you to learn how your tables,
forms, reports, and queries relate?

Please respond to me directly at dlabonte@qcc.mass.edu

Thanks for your help

Dale

(Ms) Dale LaBonte
Reference/Serials Librarian
Alden Library
Quinsigamond Community College
670 W Boylston St
Worcester MA 01606

dlabonte@qcc.mass.edu
508-854-7472
Reference Desk 508-854-4366
Fax 508-854-4204