[...] a combination of factors led me to reignite my dream of a Microsoft Access database of databases: * Mounting evidence that commercial ERMs were not living up to expectations-For example, in March 2008, I attended ER&L, and in one session with about 75 attendees, the audience was asked "How many of you have a commercial ERM?" and "How many of you are happy with your ERM?" While about half of those in the room worked at libraries with commercial ERM systems, no one was happy with his or her system. * Budget deficits were forcing cuts to acquisitions, including the purchase of a new, very expensive management system. * My extended absence from the office and the necessity for colleagues to be able to cover my responsibilities-They would need to be able to quickly and easily access a variety of data about our libraries' e-resources. At this ini- tial stage we did not discuss queries and reports.\n One can use Access' filter function to find and sort on any data elements, and there are also several reports currently available, including the following: * Payments Crosstab - An alphabetical list of databases in a table view listing payment information for each year * Payments - A list view by fiscal year of all databases and their costs * Year-to-Year Price ComparisonAsks for the 2 fiscal years you want to compare and provides cost information, as well as price increase and percentage increase for each database * Renewals for Date Range-A list of databases which will be coming due for the date range specified Of course, you can easily import data elements you might have in Excel and other products through Access' import functionality.
Reproduced with permission of the copyright owner. Further reproduction or distribution is prohibited without permission.