Using Microsoft Access 2007's “Lending Library” Template to Create a Circulation Module for Microform Materials

Abstract

The Microsoft Office 2007 version of Access includes a number of templates, including one titled ‘Lending Library.’ This template has been modified for use at the Libraries Service Center as a stand-alone circulation module for microform materials. Using this database has allowed for individual reels from a series to be checked out separately, whereas previous practice had required users to check out an entire title or series if they wanted to use any part of it. This allowed for a less cumbersome solution that did not block access for other patrons to request other reels within the same series. The Access database also allows for better tracking of circulating items.

KEYWORDS:

• Microsoft Access
• microform
• circulation

Notes

The author wishes to thank all the employees of the Libraries Service Center in testing this database.