1.     Instructor Information:

a.     Name                                Mr. Charles Kwiatkowski


b.     E-mail address                  charles_kwiatkowski@ivcc.edu


c.      Office hours                       Monday           By Appointment Only

                                          Tuesday          4:00-7:00

                                          Wednesday     3:00-6:00

                                          Thursday         4:00-5:30

                                          Friday              By Appointment Only


d.     Contact information           Charles Kwiatkowski

                                          A Building, Room 330


                                          815 North Orlando Smith Road

                                          Oglesby, IL 61348

                                          +1 (815) 408 0876


Course description

This comprehensive course in Access teaches the student basic concepts and continues through advanced database topics. Students will use Access to create and maintain databases, queries, SQL's and database relationships will be covered. Students will also create mailing labels, input masks, validation rules, and work with forms.
 Prerequisite: None
 Credit Hours: 3


2.     Course Meeting Times

None. This is independent study.


3.     Expected learning outcomes

·        Student will be able to create and manipulate records and fields

·        Student will be able to create and link tables of related information together in a single database.

·        Student will understand what a query is, and how to form queries.

·        Student will be able to create neat, professional looking reports.

Students will be able to create neat, professional looking forms.

·        Student will understand simple SQL statements and how to write them.


4.     Disability statement :

a.     If you need support or assistance because of a disability, you may be eligible for academic assistance accommodations through the Disability Services office.  Stop by office B-204 or call Tina 815.224.0284 or Judy 815.224.0350.


5.     Attendance Policy

This is an independent study class. However, assignments must be completed by the designated due date.


6.     Assessment of student learning.

Students are assessed by homework, a midterm exam, and a final exam.


7.     Grading:  All work will be done with myITlab. The grading of the course will fall into 3 categories:



This is where you will develop and apply your knowledge relevant to the topic. There shall be 1 homework per chapter. Each homework will consist of a pre-test, training questions, and a post-test. I only care about your post-test grade. Training is adaptive so you only get training on the questions you get wrong on the pre-test. This saves you time. There shall be 12 Homeworks, each is worth 100 points.


Midterm exam

Based on the myITlab exercises in Chapters 1-6. You will need to complete the exam in the Assessment Center. The midterm exam is worth 200 points.


Final Exam

Based on the myITlab exercises in Chapters 1-6. You will need to complete the exam in the Assessment Center. The final exam is worth 200 points.


Final grade by percentage of possible points

90-100% A

80-89% B

70-79% C

60-69% D

< 60%   F

Note: Grades are not rounded up or down. Example: if you end up with an overall course grade of 89.99%, you have earned a B.


8.     Withdrawal policy

According to IVCC, you may withdraw from this course with instructor permission.

You may withdraw from this course for any reason you like. I shall not shame you nor chide you for dropping the course, but I may inquire why. The only exception for this rule shall be for people who have left their lab partner "hanging". This applies only to classes with labs. See your course specific info for more detail or ask me for clarification. 

Note: Just because you stop working on this class does not grant you a grade of I (incomplete) or W (withdrawn). You must promptly contact me in order to receive a grade of I or W.

For Spring 2010:

Tuesday, August 31 is the last day for refund.

Tuesday November 9 is the Last Day for Student Withdrawal

Personal advice: Education is not a race. There is no shame in strategic retreat. Drop the class in which you are performing the worst in, not the one you like the least. Always aim to keep your grade point average high as it will take you farther than how long it took you to complete your degree/certificate/program.


9.     Cell phone and text messaging policy.

Calculators, PDA's, Cell Phones, laptops, iPods, and other electronic devices are not allowed during exams and quizzes unless otherwise specified. failure to comply with these rules will result in ejection from the exam and a grade of F for the exam.


10.  Financial aid statement

Withdrawal from a course can affect financial aid.  Students who receive financial aid should see an advisor in the financial Aid Office before withdrawing from a course.


11.  Plagiarism statement/academic honesty

Policies regarding cheating may be found under the heading of “Academic Integrity” in the IVCC Student Handbook.  Students should become familiar with these policies and abide by them. 

Furthermore, don't even think about cheating. Cheating is not tolerated at all.  Although I encourage you to collaborate and discuss ideas and concepts from this class with others, you are responsible for your own work. A (all too) common example of cheating is to work together collectively in a group and each member turns in his/her copy of the same document. This is completely unacceptable.

When you cheat, you insult my intelligence.


12.  Any classroom rules

None. This is an independent study class.


Three strikes

If you have 3 unexcused absences of any combination class activity, (HW, quiz, lecture, etc.) your course grade becomes F. Just because you stop showing up for class does not grant you a grade of I (incomplete) or W (withdrawn). You must promptly contact me in order to receive a grade of I or W.



13.  Outline of assignments for the semester

            There shall be approximately 12 assignments, 1 per chapter.

            Each chapter's assignment shall contain:

·        a pre-test section, which gives you hands on problems. This must be completed, but does not count towards your grade as it is only practice.

·        a training section, which gives further instructions on questions you missed on the pre-test. This must be completed, but does not count towards your grade as it is only practice.

·        a post-test section, which is counted towards your grade.



14.  Any hints on how to be successful in the course

Most questions allow 3 attempts. If you get it wrong, pay close attention to WHAT STEP you get wrong. Often times, there is more than one way to accomplish a task BUT myITlab is looking for a specific way. DO NOT AUTOMATICALLY REPEAT THE SAME ACTIONS IF YOU GET A QUESTION WRONG. PAY CAREFUL ATTENTION TO THE MESSAGES FROM MYITLAB!




15.  Required text and materials


GO! with Access 2007 Comprehensive

Shelly Gaskin

ISBN-10: 0132327627
ISBN-13:  9780132327626


16.  Additional Resources


ISBN 013509383X     PRENTICE H MIL SACC GRADER 2010     01
This should be bundled with your textbook from the IVCC bookstore.


Headset (for listening to training)



17.  Topic Schedule

This schedule is tentative and subject to change.


Due Date

Assignment Topic(s)

Monday, August 30, 2010

Getting Started with myITlab

Monday, September 06, 2010

Chapter 1
Creating Database Tables

Monday, September 13, 2010

Chapter 2
 Sorting, Filtering, and Querying Databases

Monday, September 20, 2010

Creating Forms and Reports

Monday, September 27, 2010

Chapter 4
Enhancing Tables

Monday, October 04, 2010

Chapter 5
Enhancing Queries

Monday, October 11, 2010

Chapter 6
Customizing Forms and Reports

Monday, October 18, 2010

Midterm Exam

Monday, October 25, 2010

Chapter 7
Creating Advanced Forms and Reports

Monday, November 01, 2010

Chapter 8
Creating Macros, PivotTables, and PivotCharts

Monday, November 08, 2010

Chapter 9
Integrating Access with Other Applications

Monday, November 15, 2010

Chapter 10
Administering Databases

Monday, November 22, 2010

Chapter 11
Securing Databases and  Writing SQL Statements

Monday, November 29, 2010

Take Thanksgiving Week
(11/23-11/28) Off.
Nothing Due

Monday, December 06, 2010

Chapter 12
Customizing Access Using Visual Basic for Applications

Monday, December 13, 2010

Final Exam