Types of Library Databases
All library databases are relational databases. As opposed to flat file databases, relational databases employ a much more logical structure in the way it stores data. Relational database use multiple tables to represent objects. For example a table called book could contain columns attributed to title, author, ISBN etc. Most library databases in schools can be categorized under three headings: INDEXING or BIBLIOGRAPHIC databases, FULLTEXT databases and COMBINATION databases.
Creating a Database using MS Access 2003- Indexing Databases - these databases (also called bibliographic databases) provide citations (and sometimes abstract) that describe titles, authors, subjects and other information about written works however it does not provide access to full-text of those work. This library catalogue is a good example of bibliographic database since it only lists the books, periodicals, videotapes, DVD's etc the library has in its collection. There is no mention of any full-text article, for instance. To read the book the user needs to physically locate the item on the shelf.
- Fulltext databases - these databases provide access to the entire text of magazine, periodical or encyclopedia articles, pdfs, e-books and CD-ROMS.
- Combination databases - these databases contain a mixture of citations and full text articles i.e it contains bibiliographic records for some items and both the record and the full-text of other items.
It should be noted here school/ university library databases may be organized differently based on the nature of the information they contain. For instance the University of Illinois Library database is organized into general interest, discipline-specific and subject-specific databases.
Apart from the poster given below these websites also provide good materials for learning and using Microsoft Access to develop and use databases in schools.
Tips and Tricks on Searching Online Databases
Since all databases basically work in the same way, important tips are explored in the following video where ProQuest is used as an example. In addition to the video these websites also provide useful tricks on researching online databases.