Aleph Reports Combining SQL and Excel

Thomas, Steve (2009) Aleph Reports Combining SQL and Excel. In: ELUNA 2009, 6-8 May 2009, Richmond, Va..

	PDF (All Scripts) - Supplemental Material Restricted to Registered users only 67kB
	PDF (Using Excel to Prepare a Report of Duplicate Books) - Supplemental Material Restricted to Registered users only 202kB
	PDF (General Excel Tips) - Supplemental Material Restricted to Registered users only 1MB
	PDF (Using Excel to Prepare a Loan Report) - Supplemental Material Restricted to Registered users only 571kB
	PDF (Using Excel with Data from the Serial/Periodicals Script) - Supplemental Material Restricted to Registered users only 907kB
	PDF (Using Excel with Output from Permissions Script) - Supplemental Material Restricted to Registered users only 455kB
	PDF (Using Excel to Prepare a “Related Items” Report) - Supplemental Material Restricted to Registered users only 224kB

Abstract

Steve Thomas, Local Systems Development Coordinator, University of Tennessee.

This presentation will show how a few simple SQL scripts, when combined with the sort and compare features of Excel, may be used to prepare some powerful reports. For example, in answer to a request for a report of duplicate holdings, the presenter was able to reduce the initial output file of over 69,000 book items into a report of less than 12,000 duplicate items by comparing call number and description data.

Item Type:	Conference or Workshop Item (Speech)
Event Title:	ELUNA 2009
Subjects:	Aleph
Divisions:	ELUNA Conference Proceedings
ID Code:	227
Deposited By:	INVALID USER
Deposited On:	30 Dec 2009 14:33
Last Modified:	27 May 2016 21:03

Repository Staff Only: item control page