NASIG 2013

Are you a lone electronic resources librarian at a small institution? Are you unable to implement an electronic resource management (ERM) system due to lack of financial or technical resources? Is your administrative information for e-resource subscriptions still recorded in a variety of physical print-outs, Word documents, Excel spreadsheets, staff wiki pages, etc., and you would like to organize it in one central location? Then this is the session for you! This program will describe the presenter's step-by-step approach to creating a homegrown electronic resources management (ERM) system using Microsoft Access 2010. The topics covered will include use-case analysis, data analysis, card sorting for database design, tables and relationships in databases, and how to use forms in Access to make the ERM database user-friendly. The presenter will also refer to free, online Access 2010 documentation that was referenced in the creation of her local ERM system.