Access I

Modules >>
Access I

Students will need to use Microsoft Access software to complete this module. Other database software programs like Filemaker Pro, may be used after prior discussion with the coordinator. The Word I and Excel I modules should be completed before students begin to work on Access, so that a familiarity with text formatting and spreadsheets is obtained.

Introduction

A database is a collection of information related to a particular subject or purpose, such as recording student information, tracking customer orders, or maintaining a CD collection. They can organize and provide quick and easy access to information than what is possible with paper filing systems. In this module, students will learn how to create a database of student information, search for data, and view a report.

In this introductory module, Microsoft Access will be used to demonstrate the basic features in a database program. In addition to using the instructional material provided in this module, students are expected to take advantage of the linked resources provided at the bottom of this webpage. You are encouraged to post any questions to the listserv or email them to the coordinator.

Objectives

In this module, you will create an Access database that includes:

one table with at least 10 student records and seven fields
formatting using the design view
- define the fields of the table
- modified form fields (as described below)
one form for inputting and viewing data
modified form entry fields
- change length of an entry field
- change a the visible property for three entry fields (fill colour, font colour, and special effect)
- change the descriptive label of a field
a query
a report

Lesson

Review the following sections by clicking on the links. Please follow the instructions within each section. If you are using Access 2000, please go with the XP tutorial.

Creating a database in Access 97 or Access XP
Entering data & using a form in Access 97 or Access XP
Modifying a form in Access 97 or Access XP
Sorting and filtering records in Access 97 or Access XP
Creating a query in Access 97 or Access XP
Creating a report in Access 97 or Access XP

Click on these links to review each section

Assignment

Compose an email message addressed to compined@uvic.ca
Include your personal email address in the "Cc" field to send a copy of the message to yourself
The subject line of your email should be the initials of *your* name followed by a short abbreviation of the module name. For example, Valerie Margit Irvine would use the subject line: VMIdbase1
In the body of the email, identify the computer platform (Mac/Win) and name and version of the program you used to create your database (i.e., Access 97, 2000, etc.).
Attach your database file to the email. To check that you have met all of the requirements, please review the objectives at the top of this page.
Send the email

Congratulations on completing the sixth module of level one!

Resources

Microsoft Access

Analyzing Grades Using Access by Microsoft (Windows)
http://www.microsoft.com/education/?ID=AccessTutorial

Access 2000 Tutorial by Microsoft (Windows)
http://www.microsoft.com/education/tutorial/classroom/o2k/access.asp

Getting Started with Access by Microsoft (Windows)
http://support.microsoft.com/support/access/content/GettingStarted.asp

Access 2000 tutorial by Canterbury Christ Church University College (Windows)
http://computing-services.cant.ac.uk/title/onlinetutorials.htm
(select "Access" from the drop-down menu; requires Acrobat Reader to view)

Access Tutorial by the University of British Columbia
http://mis.commerce.ubc.ca/courses/comm391/tutorials/access1/access1.htm

Microsoft Access Database Sample by the University of Alberta
http://www.quasar.ualberta.ca/edit202/tutorial/database/access-basic/dbsamp-access.htm

Microsoft Access Relational Database Sample
http://www.quasar.ualberta.ca/edit202/tutorial/database/access-rel/access-rel.htm

Filemaker Pro

Download trial software of Filemaker Pro
- click on "downloads" and choose FileMaker Pro from "Trial Software"
http://www.filemaker.com/

Filemaker Pro Database Sample by the University of Alberta
http://www.quasar.ualberta.ca/edit202/tutorial/database/fmbasic/dbsamp-personnel.htm

Relational Database Tutorial by the University of Alberta
http://www.quasar.ualberta.ca/edit202/tutorial/database/reldb/reldb.htm

The Basics of FilemakerPro 3.0/4.0 by Boston College
http://www.quasar.ualberta.ca/edit202/tutorial/database/reldb/reldb.htm

Filemaker Pro Tutorial by the University of Glasgow (Macintosh)
http://130.209.34.12/Compserv/Doc/Mac/un610/un610.html

Apple/ClarisWorks

Appleworks Tips for Educators by Apple
http://www.apple.com/education/k12/products/appleworks/tips/index.html

ClarisWorks Tips by Mounds View Technology Training
http://district.moundsview.k12.mn.us/schools/dsc/tech/trainmanual.html

Microsoft Works

Using MS Works Tutorial by Memphis City Schools
http://www.memphis-schools.k12.tn.us/admin/tlapages/on-line_works.htm

To add another resource, please email your suggestion to compined@uvic.ca.