microsoft access 97 tutorial by lestercaldwell

VIEWS: 83 PAGES: 2

									CSD 1200 -- Microsoft Access 2003 (from MS Office 2003 Suite)
Instructor:        Lynn Smith
Office:            C-312
Office Phone:      708-917-6569
e-mail:            itsme@mchsi.com
Office Hours:      By Appointment Only
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 48 hrs for response).
Required Materials
      TEXT:        BRIEF -- New Perspectives - Microsoft Access 2003 by Adamski & Finnegan
      Disks:       Data Diskettes will be supplied by instructor or the student can download the files from
                   www.course.com
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 attached schedule.
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. The test
   is administered by the Assessment Center. Please Phone 224-0542 to schedule your testing day & time.

For your reference, answers to the "Quick Check" questions in the Tutorials are at the END of each Tutorial.


                ABSOLUTE LAST DATE TO TAKE FINAL EXAM IS:
                            Wednesday, August 2
  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




MS ACESS Info                                                                            Page 1 of 2
CSD 1200 - Microsoft Access 2003 Schedule

Using Common Features of Microsoft Office 2003 – COMPLETE ALL YELLOW SHADED
EXERCISES ON A COMPUTER USING MS ACCESS.
USE DATA DISK: Common Features of Office

Tutorial 1 - Introduction to Microsoft Access 2003 – COMPLETE ALL YELLOW SHADED EXERCISES
ON A COMPUTER USING MS ACCESS.
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 – COMPLETE ALL YELLOW SHADED EXERCISES
ON A COMPUTER USING MS ACCESS.
Review Assignments on page AC 72 – 74 - All Steps
Case Problem 1 - on pages AC 74-75 - All Steps

Tutorial 3 – Querying a Database – COMPLETE ALL YELLOW SHADED EXERCISES ON A
COMPUTER USING MS ACCESS.
Review Assignments on pages AC 122 - 123 – All Steps
Case Problem 1 on page AC 123 - All Steps

Tutorial 4 – Creating Forms and Reports – COMPLETE ALL YELLOW SHADED EXERCISES ON A
COMPUTER USING MS ACCESS.
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.

General Information about the IVCC Computer Resource Center – CRC - Building D
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 - Building 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




MS ACESS Info                                                                          Page 2 of 2

								
To top