As part of the requirements for LIS 569, Database Management Systems, I created this database in Microsoft Access. It is used by a fictional company, McKewan Inc., to track reference requests in the company library. A tool like this could be used to compile statistics about what services and resources are being used, how time is being spent, and other information. It could also be used as a marketing tool or a source of information for an annual report. The database utilizes forms, reports and queries, and the data tables follow the rules of normal forms.
mckewan.mdb (Size: 4.95 MB)
A description of each table, form, report and query.
As part of a Directed Study in using Microsoft Access Databases on the web, I converted the above database into a series of interactive web pages using ASP. These are not currently available on my website, but I would be happy to send you the files if you are interested in seeing my code.
I also used PHP on this website. The code for the tabbed links you see at the top is actually in a separate document. By using PHP, I made each page on the site include that the code for those tabs. When I want to add/remove links, I only change one file, and then that change is reflected in all pages on the site. I used the same technique on the WNY Mensa website, to create the links in the sidebar.
On the website for the Montante Family Library at D'Youville College, I created Interlibrary Loan Request forms that allow a student to fill out a form, send the request to the library via e-mail, and send the student an e-mail confirmation. They were originally created with PHP, then later rewritten in ASP to accomodate a move to a different server.