...
A. Introduction
Library Technical Services tracks and compiles production statistics at the department, unit, and individual levels. This information is important for individual employee performance evaluation and management, and for short and long term planning at both the unit and department levels. Information from 948 fields is harvested and processed to determine what type of work was done to a record, on what day, and by whom. An Access database was built to query this data and create reports for individuals, units, and the entire department.
Managers may retrieve statistics for each member of their staff, and may also retrieve statistics for their units, for any desired date range. They may run these queries at any time they desire. Monthly retrieval of statistics for the entire department is executed by the LTS Administrative Support Specialist, who compiles this information into a spreadsheet for each fiscal year. This spreadsheet is distributed throughout LTS management and shared with Library Administration.
Additional specialized reports have been written in a separate database to gather information regarding batch processing production in LTS. These statistics are compiled by the Batch Processing Supervisor for each fiscal year.
B. Connecting to the Technical Services Statistics Database
...