LIBR 500: Foundations of Information Technology

Sources for Understanding Databases

Before You Buy A Database, by Mike Chapple
http://databases.about.com/library/weekly/aabyb111101.htm

Choosing a Database Product, by Mike Chapple
http://databases.about.com/library/weekly/
aa050601a.htm?once=true&PM=n10050901d

Concepts of Database Design and Management, by Jason Lotito
http://www.webmasterbase.com/article.php/378

Database Concepts
http://tinyurl.com/b7qz3

The Database Design Process
http://www.microsoft-accesssolutions.co.uk/table_design_tips.htm

Introduction to Data Modeling [from the University of Texas at Austin]
http://www.utexas.edu/its/windows/database/datamodeling/index.html

Introduction to Relational Database Design, by Fernando Lozano
http://www.edm2.com/0612/msql7.html

Managing Many-to-Many Relationships
http://www.microsoft-accesssolutions.co.uk/many_to_many.htm

Overview of the Relational Model  [from the University of Texas at Austin]
http://www.utexas.edu/its/windows/database/datamodeling/rm/overview.html

Understanding Relational Databases, by John Blank and others
http://www.miswebdesign.com/resources/
articles/wrox-beginning-php-4-chapter-3-1.html

When Should You Create a Database Driven Web Site?
http://webdesign.about.com/cs/databases1/a/aa120699.htm

Your First Database, by Jay Greenspan
http://hotwired.lycos.com/webmonkey/databases/tutorials/tutorial3.html

About Designing a Database [from Microsoft]
http://tinyurl.com/35akm

Access 2003 Introductory Tutorial [downloadable Word document]
http://www.officetutorials.com/Access%202003%20tut.DOC

Adding and Modifying Data [from Microsoft]
http://tinyurl.com/3a3jp

Changing the Appearance of a Datasheet [from Microsoft]
http://tinyurl.com/2xuuu

Creating and Using Data Entry Forms [sample chapter from Absolute Beginner's Guide to Microsoft Office Access 2003]
http://tinyurl.com/2sf96

Creating Dynamic Web Pages with Microsoft Access [from About.com]

Part 1: Selecting the Data
http://databases.about.com/images/aa011401a.htm

Part 2: Creating the Active Server Page
http://databases.about.com/library/weekly/aa011401b.htm

Part 3: Configuring the Data Source
http://databases.about.com/library/weekly/aa011401c.htm

Customizing Forms [sample chapter from Absolute Beginner's Guide to Microsoft Office Access 2003]
http://tinyurl.com/36dbr

Define Relationships Between Tables [from Microsoft]
http://office.microsoft.com/assistance/preview.aspx?AssetID=HP051875301033&CTT=98

Exploring the Access Database Window [sample chapter from Absolute Beginner's Guide to Microsoft Office Access 2003]
http://tinyurl.com/3avqm

Focusing on Fields in Access 2003 [adapted from Access 2003 For Dummies]
http://www.dummies.com/WileyCDA/DummiesArticle/id-283,subcat-DATABASES.html

Forms Follow Function [self-paced online tutorial from Microsoft - requires speakers or headphones]
http://tinyurl.com/5flds

Get ot Know Access [self-paced online tutorial from Microsoft - requires speakers or headphones]
http://tinyurl.com/63kg5

How to add a Background Image to a Form or Report [from Microsoft]
http://office.microsoft.com/en-us/assistance/HA011878561033.aspx

How to add a Static Image to a Form or Report [from Microsoft]
http://office.microsoft.com/en-us/assistance/HA011878571033.aspx

Hyperlinks in Access 2003 [from Microsoft]
http://tinyurl.com/2ws2s

Importing and Linking Data or Objects [from Microsoft]
http://tinyurl.com/2s9lx

Introducing Access 2003 [sample chapter from Access 2003 All-in-One Desk Reference For Dummies]
http://media.wiley.com/product_data/excerpt/84/07645398/0764539884.pdf

Introduction to Databases [self-paced online tutorial from Microsoft - requires speakers or headphones]
http://office.microsoft.com/training/training.aspx?AssetID=RC061181381033&CTT=98

Queries I: Get answers with queries [self-paced online tutorial from Microsoft - requires speakers or headphones]
http://tinyurl.com/6rarc

Queries III: Create parameter queries that prompt users for input [self-paced online tutorial from Microsoft - requires speakers or headphones]
http://tinyurl.com/53b6p

Quick Reference Card: Introduction to Databases [from Microsoft]
http://tinyurl.com/9xsbh

Relationships: Your Key to Data Integrity in Access 2003 [sample chapter from Alison Balter's Mastering Microsoft Office Access 2003]
http://tinyurl.com/3444d

ReportsI: Show off your Data [self-paced online tutorial from Microsoft - requires speakers or headphones]
http://tinyurl.com/6au6u

Sorting Data [from Microsoft]
http://tinyurl.com/3etzs

Store Images in a Database [from Microsoft]
http://office.microsoft.com/en-us/assistance/HP052802251033.aspx

Subdatasheets [from Microsoft]
http://tinyurl.com/24j9q

Table that Data [self-paced online tutorial from Microsoft - requires speakers or headphones]
http://tinyurl.com/4tghg

The 37-Minute Overview [excerpt from Access 2003 for Dummies]
http://media.wiley.com/product_data/excerpt/10/07645388/0764538810.pdf

Use images in your Access forms, reports, and controls [from Microsoft]
http://office.microsoft.com/en-us/assistance/HA011472041033.aspx

What to do When you see File Names Instead of Images in your Access Database [from Microsoft]
http://office.microsoft.com/en-us/assistance/HA011504111033.aspx

Access 2002 Tips [from Microsoft]
http://www.microsoft.com/office/using/tips/archives/accesstips.asp

Database Normalization Basics [Webcast from Microsoft]
http://tinyurl.com/3j66a

Getting Started with Access 2002 [sample chapter from Illustrated Access 2000
from Course Technology]
http://www.course.com/office/ilaccess2002.pdf

Handling Many - To - Many Relationships
http://www.microsoft-accesssolutions.co.uk/many_to_many_example.htm

Hyperlink Protocols Supported By Microsoft Access [from Microsoft]
http://office.microsoft.com/assistance/2002/articles/acHyperProtoInAccess.aspx

Keeping Your Information Accurate [sample chapter from
Microsoft Access Version 2002 Step by Step]
http://www.microsoft.com/mspress/books/sampchap/5054.asp#SampleChapter

Microsoft Access Tutorials [must have Quicktime installed to view free tutorials]
http://www.vtccanada.com/can/titles/access2002.html

Microsoft Access 2000 & 2002/XP Tutorials [links to free tutorials on a variety of topics]
http://training.beginners.co.uk/courselist/category/53

Modify a Date in Access by Clicking the Mouse
http://tinyurl.com/6uh2l

Overview of PivotTables and PivotCharts in Microsoft Access 2002 [Webcast -- can be viewed, read or watch a PowerPoint presentation]
http://support.microsoft.com/default.aspx?kbid=324695

Synchronize a Form and a Report in Access
http://tinyurl.com/66bmg

Understanding Relational Database Design [from Microsoft]
http://support.microsoft.com/default.aspx?scid=kb;en-us;283698

Working with Postal Codes in Access
http://tinyurl.com/47k9l