Instructor: Sue
Isermann
Office:
C-312
Office Phone: 224-2720 Ext 408
e-mail:
sue_isermann@ivcc.edu
Office Hours: 8am-4:30pm – (Monday – Friday ) By Appointment
Course Description
An
introduction to database processing using Microsoft Access.
This course will introduce creating and maintaining Access tables,
querying, form design, and report creation.
This course features self-paced, self-taught individualized
instruction.
A tutorial text is used.
The instructor is available to answer questions during office hours by
appointment or you may e-mail questions to the instructor (may take up to 24
hrs for response).
Required Materials
TEXT: BRIEF -- New
Perspectives - Microsoft Access 2003 by Adamski & Finnegan
Disks: Data disks will be supplied by instructor
IF YOU NEED THE DATA ON CD-ROM, CONTACT THE INSTRUCTOR AND I CAN SEND IT TO
YOU IN THAT FORMAT.
Attendance
There are no attendance requirements except to take final exam. If you wish to
drop this course, you must contact the instructor.
If you do not withdraw and do not take the final exam, you will receive
a Failing grade.
Requirements
1.
Complete all of the Tutorials, Review Assignments, and Case Problems as listed
on the schedule below.
2.
Turn
in all print outs from the Review Assignments and the Case Problems. Turn these in when you come to take the final exam.
3.
Take a
written test over the Microsoft Access material upon completion of the
assigned Tutorials.
For your reference, answers to
the "Quick Check" questions in the Tutorials are at the END of each
Tutorial.
ABSOLUTE LAST DATE TO TAKE THE FINAL EXAM IS:
Tuesday, December 12
YOU MUST CALL THE ASSESSMENT CENTER (224-0542) AT LEAST ONE WEEK IN ADVANCE TO SCHEDULE THE DATE AND TIME FOR TAKING YOUR FINAL EXAM!
Grading
Scale
90 - 100% = A 80
- 89% = B 70 - 79% = C
60 - 69% = D
TEST = 90% of grade
REVIEW & CASE PROBLEMS = 10% of grade
CSD
1200 - Microsoft Access 2003 Schedule
COMPLETE ALL YELLOW SHADED EXERCISES ON A COMPUTER USING MS EXCEL.
Using Common Features of Microsoft Office 2003
USE DATA DISK: Common Features of Office
Tutorial 1
- Intro. to Microsoft Access 2003
Review Assignments on pages AC 29-30 – All Steps
Case Problem # 1 – on page AC 30 – All Steps
Tutorial 2
– Creating and Maintaining a Database
Review Assignments on page AC 72-74 -
All Steps
Case Problem 1 - on pages AC 74-75 - All
Steps
Tutorial 3
– Querying a Database
Review Assignments on pages AC 122-123 – All Steps
Case Problem 1 on page AC 123 - All Steps
Tutorial 4
– Creating Forms and Reports
Tutorial Assignments on pages AC 161-162 - All Steps
Case Problem 1 on page AC 163 - All Steps
Access
2003 is one of the components of Microsoft Office 2003 Professional Suite.
If you do not have the software package at home or at work, you can use
a computer on campus to complete your assignments.
1. Each student enrolled in a class at Illinois Valley Comm. College has been assigned a login i.d. for our computer network. The i.d. consists of the first three letters of your last name and the last four digits of your social security number. For example, my i.d. would be ise9234.
2.
Your initial password
for the system is your entire social security number without any spaces or
hyphens.
3.
You must change your
password immediately and then again each month to use the network.
The password should be something that you can easily remember and that
is unique. A pamphlet is
available in the lab outlining the procedures to change your password.
4.
CRC-D is an open lab
that will not have any classes scheduled in it.
There will also be a lab assistant to instruction or student lab
assistants in this lab to assist you in your computing endeavors.
5. Information about the IVCC Computer Resource Center can be found at:
http://www.ivcc.edu/its/students/comp_open_labs.html AND http://www.ivcc.edu/its/students/comp_labs.html