Using MS Access for Usage Statistics
Callahan, Patricia, Treadwell Library 29 Jun 2005 17:28 UTC
Hello,
We were wondering if the replies to the question below are still available. We
also would be interested in using our MS Access database to track usage
statistics. We would also like to refine the tracking to show usage of full
text, and not just hits to the electronic title. Any information anyone has on
this would be helpful and appreciated.
Thank you,
Pat Callahan
Library Assistant
Massachusetts General Hospital
Treadwell Library BHX-1
55 Fruit Street
Boston, MA 02114
617-724-0710
pcallahan@partners.org
-----Original Message-----
From: SERIALST: Serials in Libraries Discussion Forum
[mailto:SERIALST@LIST.UVM.EDU]On Behalf Of Mark Ferguson
Sent: Tuesday, June 22, 2004 3:12 PM
To: SERIALST@LIST.UVM.EDU
Subject: [SERIALST] Usiing MS Access for usage statistics
Greetings Serial librarians:
I am plannning on using our MS Access database I have been developing to
track usage of our journal collection. That way I can then combine usage
statistics with other data I already have stored on the database (such as
subjects established for each journal) to provide more useful information.
I would therefore like to be able to program Access to act as a counter (so
that the column contains a number that increases by one every time I click
on it) for the columns I am using to track usage. Has anyone tried this
before? Is it possible to get Access to act as a counter, and if so how?
Perhaps there is even some usage study software that can be attached to an
Access database that would provide this kind of functionality.
Is there anyone out there who has had any experience doing this kind of
thing? I would be very interested in any solutions you may have come up
with.
Mark