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. You can view this final project here. (Microsoft Internet Explorer required.)
You can also see some of my PHP skills in action by taking a short quiz that I created myself, using PHP. Try entering a few wrong answers and a few right answers (answers must be capitalized to be correct).