Navigation:
Navigation:
The following texts and web sites provide relevant reading for this course. All of the books listed below are available from the LLRC.
Bessant A (2000) The European Computer Driving Licence. Heinemann
Byrne J (1997) Easy Microsoft Access 97. Que
Coles S and Rowley J (1997) Access 2, 2nd Ed. Letts
Coles S and Rowley J (2000) Access 97 Basic Skills. Letts
Coles S and Rowley J (2000) Access 97 Further Skills. Letts
Date CJ (1986) An Introduction to Database Systems Vol 1, 4th Ed.
Addison-Wesley
Habraiken J (1997) The Complete Idiot’s Guide To Microsoft Access
97. Que
Heathcote PM (2000) A Level Computing 4th Ed. Payne-Gallway Pub.
Ltd.
Holding H (2000) Mastering Database Design. Macmillan
Howe DR (1989) Data Analysis for Database Design 2nd Ed. Edward Arnold
McFadden FR and Hoffer JA (1991) Modern Database Management 4th Ed. The Bejamin/Ciummings
Publishing Co. Inc.
Kaufeld J (1996) Access 97 for Dummies. IDG Books
Ritchie C (1989) Relational Database Principles. Continuum
(1997) A Quick Course in Microsoft Access 97. Microsoft Press
The following sites can be access via The Northern College’s “Web Links” database at http://www.northern.ac.uk/weblinks/weblinks.asp
http://www.sqlteam.com/item.asp?ItemID=122
An excellent overview of the fundamentals of relational database design. The article has links to many other relevant topics such as Data Modelling, Entity Modelling and Normalisation.
This Microsoft WebCast is an excellent visual and audio presentation about database normalisation and what constitutes a relational database. The WebCast emphasises the differences between a flat file databse and a relational database.
http://www.geekgirls.com/menu_databases.htm
Written by Rose Vines (1998) this site provides an excellent tutorial guide to basic database design. Tutorial data can be downloaded in Access 2000, FileMaker and Approach formats. Topics covered include Table Creation, Forms, Data Validation, Lookup Tables, Quries and Simple Relational Design. A nice touch is that the user can select the background colour for the site.
This site gives a wealth of useful information on the effect of relevant legislation on the HE and FE communities. Topics include, amongst others, Data Protection and Freedom of Information.
http://www.jmu.edu/computing/tutorials/microsoft/access/
Hosted by James Madison University (Virginia, USA), this site hosts a number of worthwhile tutorials that give a good practical introduction to Microsoft Access 2000..
http://www.utexas.edu/its/windows/database/datamodeling/rm/overview.html
Hosted by the University of Texas, this is a succint and very useful overview of the relational database model. The site covers relational data structures and normalisation.