UBC Home Page -
UBC Home Page UBC Home Page UBC Home Page -
School of Library, Archival and Information Studies School of Library, Archival and Information Studies

- News Events Directories Search UBC

UBC Library
Student ServicesFaculty of Graduate StudiesFaculty of Arts

- -
LIBR 500 HOME
SYLLABUS
ASSIGNMENTS
ASSIGNMENT 1
ASSIGNMENT 4
TECHNICAL SKILLS MODULES
TECHNICAL SKILLS MODULE 1
TECHNICAL SKILLS MODULE 2
TECHNICAL SKILLS MODULE 3
TECHNICAL SKILLS MODULE 4
TECHNICAL SKILLS MODULE 5
SUSIE'S IT LIBRARY
SLAIS HOME

LIBR 500: Foundations of Information Technology

Winter 2003 - 2004, Term 2

School of Library, Archival and Information Studies


The University of British Columbia


RESOURCES FOR TECHNICAL SKILL MODULE #4

 

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://www.db.erau.edu/campus/departments/administrative/hr/techtraining/Pubs/UNC/
Access2000/Database_Concepts.pdf


Database Design For Mere Mortals, by Michael J. Hernandez -- Lecture Notes [from KAPI`OLANI Community College]
http://mongoose.kcc.hawaii.edu/its113/dbmortals/Default.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

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


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

Using Access 2003

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

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/3ckbe

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

Quick Reference Card: Introduction to Databases [from Microsoft]
http://office.microsoft.com/training/Training.aspx?AssetID=RP061781451033&CTT=6&Origin=RC061181381033

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

Reports I: Show off your Data [self-paced online tutorial from Microsoft - requires speakers or headphones]
http://office.microsoft.com/training/training.aspx?AssetID=RC010780631033&CTT=4&Origin=CR061829401033

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

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

Table that Data [self-paced online tutorial from Microsoft - requires speakers or headphones]
http://office.microsoft.com/training/training.aspx?AssetID=RC061183261033&CTT=4&Origin=CR061829401033

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

 

Using Access 2002/XP

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

Access XP -- Immaculata University
http://www.immaculata.edu/OTS/IDRC/access.htm

Analyzing Data Using Access 2002 [from Microsoft]
http://www.microsoft.com/education/?ID=AnalyzeDataAccess2002

Avoid Multiple Fields that Contain Similar Data in Access
http://office.microsoft.com/assistance/preview.aspx?
AssetID=HA010345741033&CTT=4&Origin=CH010713951033


Database Normalization Basics [Webcast from Microsoft]
http://support.microsoft.com/
default.aspx?scid=%2fservicedesks%2fwebcasts%2fwc060600%2fwc060600.asp%3ffr%3d1


Examples of Forms in Access 2002 [from Microsoft]
http://office.microsoft.com/assistance/2002/articles/
acAccessExamplesOfForms.aspx


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

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://office.microsoft.com/assistance/preview.aspx?AssetID
=HA010565061033&CTT=4&Origin=CH010713951033


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?scid=%2fservicedesks%2fwebcasts%2fwc081601%2fwcblurb081601.asp

Synchronize a Form and a Report in Access
http://office.microsoft.com/assistance/preview.aspx?AssetID
=HA010565581033&CTT=4&Origin=CH010713921033

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

Working with Postal Codes in Access
http://office.microsoft.com/assistance/preview.aspx?AssetID
=HA010345441033&CTT=4&Origin=CH010714101033

 

 

 

 

 

-