...
- Go to \\files.cornell.edu\LIB\ds-deptshares\tsstats and open the .mdb file called “3_BATCHstats.mdb.”
- At the right side of the screen, double-click on the macro called “1 – Batch BIB Summary Report.” (see below)
The following window will appear (below). Enter the starting and ending dates for the time period for which you wish to collect data.
If you haven’t already been in an Access database for Voyager during your computing session, Access will ask you for the VGR7 username and password. (see below)
The script will start to run a series of queries. When it is done, it will open the report containing the data for the date range you entered. (See next page for screenshot.) NOTE: If you want to save a copy of your report, you’ll need to right click on it and Export it as a PDF. If you or someone else runs the query before you’ve done that, your report will be overwritten and you will have to run it again (and export it immediately) in order to save the information it generated. Here's a sample report (below). Please see #6 to see an annotated version of it.
| Anchor |
|---|
...
|
...
|
These statistics must be gathered from various Access reports, from multiple databases. Some statistics are required for the department-wide spreadsheet that is shared with Library Administration; some are for inter-departmental use.
...