...
Anchor connect connect
B. Connecting to the Technical Services Statistics Database
| connect | |
| connect |
Note: if If you need help with the following set-up, please send a message to desktop support CUL Desktop Support at cul-dshelp-l@cornell.edu.
...
4. Choose the macro for the report you wish to run; click on the macro to start the query. DO NOT try to run the report from the "Reports" dropdowndrop-down. You will get an error message. The macro walks you through all the variables you need to enter in, i.e. the net ID of the staff member and the date range.
5. Individual Reports and Staff/Bib ID Reports will ask for the net ID of the staff member whose activity you wish to view. (See below.) Only one net ID can be entered for these reports at a time.
6. All macros will ask you for a date range of activity to be reported out. (See below) You may query as far back as July 2012 in this system, if you wish.
7. The first time you run a report in a each session of Access, you will be asked for a database user and password. Both are "dbread," just as with our other Voyager Access databases.
8. You will get a message box asking you if it is ok to delete the existing table. The answer is "yes," otherwise you will be getting data from the last query run in the system, instead of for the query you just requestrequested.
9. The query will no now run and will generate a report for the data you requested. How long it takes will depend upon the length of the date range, and whether the query is harvesting data for a whole unit, the whole department, or just one staff member.
...
a. To print without saving the document: While the report is open, click the "File" button in the upper left corner, then click "Print" in the dropdowndrop-down.
b. To print AND save AND print:
i. Click File/Print, then click "Print Preview," as seen below.
...
v. Give the file a useful name (, such as the net ID of the staff person and the date range of the data you harvested.
...
vii. The program has saved your report as a .pdf file in your chosen folder and has opened it in Adobe Acrobat for you to review. If you wish to print it at this time, click the "print" button on the toolbar. Now that you have save saved the report as a .pdf, you may retrieve and print it at any time.
...