Stefan Kramer: Creation of an online catalog of dissertations using Access & ASP
Creation of an online catalog of dissertations using Access & ASP
From Datatel to web
Stefan Kramer

Fielding Graduate Institute

SKramer@fielding.edu

2112 Santa Barbara St., Santa Barbara, CA 93105, USA

www.fielding.edu/library/

Keywords:
OPAC, Dissertations, Microsoft Access, Active Server Pages (ASP)

Abstract

The Fielding Graduate Institute is a small, private, non-profit graduate education institution that has not joined the NDLTD movement ... yet. To supplement the database (and availability) of its graduates' dissertations through ProQuest's Digital Dissertations product, Fielding has created a publicly accessible catalog (at http://www.fielding.edu/library/dissertations/) using readily available tools, namely Microsoft Access and Active Server Pages (ASP), extracting the relevant data from the institution's Datatel Colleague-based ERP system. This paper describes how the project was carried out, and plans to link from the catalog directly to 'Digital Dissertations' for each dissertation record.


Table of Contents

Front pageCreation of an online catalog of dissertations using Access & ASP
Preface Preface
1 Library Services and dissertation dissemination at Fielding Graduate Institute at present
1.1Fielding Library Services
1.2Dissertation Dissemination
2 Creation of web-based catalog of Fielding dissertations
3 Reasons for the creation of the web-based catalog of dissertations, and the selection of tools to create it
4 Future goal: integration of the Fielding-created web-based dissertations catalog with Current Research @ Fielding Graduate Institute
Appendix A Appendix

Table of Figures

Figure 1: Screen snapshot of Current Research @ Fielding Graduate Institute database
Figure 2: ProQuest Digital Dissertations with full text database
Figure 3: Sample record for a dissertation from Datatel (confidential data intentionally obscured).
Figure 4: Microsoft Access macro for generating database „behind“ web-based catalog of Fielding dissertations
Figure 5: Section of web-based dissertation catalog input screen, with sample search for „cohes“ in the dissertation title
Figure 6: Section of web-based dissertation catalog output screen, with results of sample search for „cohes“ in the dissertation title
Figure 7: Partial sample record from UMI‘s Current Research @ Fielding Graduate Institute database.


© This publication and its compilation in form and content is copyrighted. Every realization which is not explicitly allowed by copyright law requires a written agreement. Especially, this holds for reprography and processing / storing by electronic systems.

ETD Proceeding DTD
HTML - Version create: Wed May 21 10:03:01 2003