Internet Explorer 7, 8, and 9 are no longer supported. Please use a newer browser.
Concourse works best with JavaScript enabled.
North Idaho College logo

Coeur d'Alene · Business & Professional Programs · Computer Applications & Office Technology

Database/Access 3

  • Fall 2012
  • Section 10
  • 1 Credits
  • 08/27/2012 to 12/13/2012
  • Modified 08/05/2012

Contact Information

This course is team-taught by the following Flexible Learning Center instructors:

  • Kathie O'Brien
  • Amy Bancroft
  • Rebecca Zanetti
  • Sue Shibley
  • Bonnie Barber
  • Angie Blair

Use your myitlab email or Blackboard messages to contact your instructors or come into the Flexible Learning Center in McLain 104 during regular class hours (see for class hours).

Meeting Times

This is a student-directed, Flexible Learning Center (FLC) class.  Students are expected to set their own schedule and spend the necessary time in the FLC to complete the course by the established deadline.  Face-to-face, individualized instruction is available in McLain 104 during our classroom hours (see  Instruction is not available online.


CAOT-142 is a continuation of CAOT-141. This hands-on class includes advanced skills in database management software including advanced reports, managing database objectives, macros, modules, and maintaining a database. This course is based on hardware and software that uses the Windows operating system. This course fulfills the third credit of the database requirement for Computer Applications and Office Technology programs. Prerequisite: Complete CAOT-141 with a minimum grade of C-. Students may enroll and complete these courses during the same semester


Textbook Bundle

Required book:  GO! Access 2010 Comprehensive by Gaskin bundled with myitlab 2010 Student Access Code.  1st edition.  Publisher:  Pearson/Prentice Hall.

ISBN for bundle at NIC bookstore:  1256451762 (this ISBN will NOT work if you are purchasing at a location other than the NIC bookstore.

Individual ISBNs (for use at locations other than the NIC bookstore)

■GO! Access 2010 Comprehensive—ISBN:  ISBN-13:  9780138007713

■myitlab 2010 Student Access Code—ISBN:  ISBN-13: 9780135107300

NOTE:  Student access codes for myitlab good for a 12-month period beginning with activation.  The same access code can be used for CAOT 120, 121, 122, 130, 130, 131, 140, 141, 142, 150. Each student myitlab access code can only be used by ONE student—once used, they cannot be sold for re-use.


  1. Import and export data and use other applications with MS Access
  2. Apply MS Access advanced tools to revise, edit, update and maintain a database
  3. Perform advanced queries on tables
  4. Generate and print reports


Using myitlab--the highest grade is posted to the gradebook.

  • Trainings:  May be completed as many times as you wish.  Attempts are unlimited.
  • Objective Questions:  May be completed twice. 
  • Grader Project Practices:  May be completed up to three times.
  • Chapter Exams:  Only ONE attempt allowed.
    • Must be scheduled at least 24 hours in advance.  Must be taken in the Flexible Learning Center (McLain 104) or at an approved outreach center (Sandpoint, Bonners Ferry, Silver Valley).
  • Grader Project Exams:  Only ONE attempt allowed.
    • Must be scheduled at least 24 hours in advance.  Must be taken in the Flexible Learning Center (McLain 104) or at an approved outreach center (Sandpoint, Bonners Ferry, Silver Valley).
  • End of Course Assessment:  Only ONE attempt allowed.
    • Must be scheduled at least 24 hours in advance.  Must be taken in the Flexible Learning Center (McLain 104) or at an approved outreach center (Sandpoint, Bonners Ferry, Silver Valley).


  • Training, Objective Questions, and Practice Exams (25%)
  • Chapter Exams (50%)
  • Comprehensive Exam (25%)

Course Policies

At least two activities should be completed in myitlab and submitted each week. Please be aware that ALL assignments must be completed by the due date and that attendance is based on SUBMITTING assignments in myitlab.


All assignments are provided in myitlab.  All assignments listed in myitlab are required and all assignments (including exams) must be completed no later than 6:20 p.m. on Thursday, December 13, 2012.

Additional Items

Be sure to read all information provided in myitlab.  This information will be important to your success in this class.

Be sure you run the Home Computer Setup ( to make sure myitlab will run properly on your home computer. 

If you have technical issues, contact myitlab tech support (  Your instructor cannot troubleshoot your home computer.

IMPORTANT:  The myitlab software has the ability to determine if files are shared when completing Grader Project Practices and Grader Project Exams.  If you share files, the system will indicate an issue.  ALL instances of file sharing will be viewed as Academic Dishonesty and result in appropriate penalties.

Division Policies

Student Responsibility

As outlined in the Student Code of Conduct, all North Idaho College students have both rights and responsibilities: Please access www.nic.ferpa.StudentCode/index.htm for complete information that pertains to this subject. For a complete explanation of the North Idaho College Statement on Academic Honesty & Academic Integrity please refer to Policy 5.06 & Procedure 5.06.01: 

Academic Integrity 

Disruptive behavior in the class is not tolerated. To quote from the NIC "Student Code of Conduct," Article II, (found in the Student Handbook):

In order to carry out North Idaho College's Mission and to create a community of learners, the students, faculty, staff, and administrators must share common principles or values.  These values - which include honesty, trust, fairness, respect, and responsibility - make up academic integrity.

II.  Academic Dishonesty.

Violations of academic integrity involve using or attempting to use any method that enables an individual to misrepresent the quality or integrity of his or her work at North Idaho College.  These violations include the following:

Cheating:  using or attempting to use unauthorized materials, information, or study in any academic exercise.

Fabrication:  falsifying or inventing any information or citation in an academic exercise.

Plagiarism:  knowingly representing the words, ideas or work  of another as one's own in an academic exercise.

Violation of Intellectual Property:  stealing, altering, or destroying the academic work of other members of the community or the educational resources, materials, or official documents of the college.

Facilitating Academic Dishonesty:  knowingly helping another to attempt to violate any provisions of this policy. 

Our department strongly endorses the above code, believing that no learning can take place if a strong commitment to academic integrity is compromised. Any unethical behavior, including any violation of academic integrity or instance of plagiarism, may result in a grade of zero for an assignment in question or failure of the course.

Institutional Policies

Student Responsibilities

As students undertake to fulfill the obligations and duties outlined in this document, the college community of which they are a part undertakes to respect the basic freedoms of students. In recognition of students’ rights and dignity as members of the college, North Idaho College is committed to the principles found in the NIC Student Handbook.

Center for Educational Access/Disability Support Services

In compliance with the Americans with Disabilities Act of 1990 and Section 504/508 of the Rehabilitation Act of 1973, North Idaho College provides accommodations to eligible students who experience barriers in the educational setting due to learning, emotional / mental, physical, visual, or hearing disabilities.  Instructors will provide accommodations to students only after having received a Letter of Accommodation from the Center for Educational Access. 

If a student would like to request accommodations, he or she must contact the Center for Educational Access so that a Letter of Accommodation may be sent to the instructor.  Students requesting accommodations must contact the Center for Educational Access at the beginning of each semester.


By registering at North Idaho College, you agree to provide payment by the due dates. You also understand that collection costs and legal fees will be added if the services of a collection agency are utilized.

If you are registered for a class and do not attend, you will still be liable for the tuition unless you drop the class.


Last day for students to withdraw from semester-length classes:

Instructor-Initiated Withdrawal: Instructors have the right to withdraw students for academic reasons up until the same date; in doing so, instructors must notify students through NIC e-mail within 48 hours of submitting documentation to the Registrar's office, and students have the right to appeal the instructor's decision. For more information, see the NIC Procedure:

Financial Aid Satisfactory Progress Policy: All withdrawals, whether for individual classes, total withdrawal from school, or instructor-initiated are not considered to be satisfactory progress for financial aid.  See the Financial Aid Satisfactory Progress Policy:

Additional withdrawal information:


An incomplete is assigned only if the student has been in attendance and has done satisfactory work to within three weeks of the end of the semester (or proportional length of time for a course of less than a semester in length).  Incompletes are issued only in cases of extenuating circumstances, such as severe illness or injury.  Incompletes are not issued in cases in which the student is simply unable to complete his/her work within the specified semester or session.  If a final grade of "I" is recorded, the instructor will indicate in writing to the Registrar what the student must do to make up the deficiency.  The instructor will indicate in the written statement what permanent grade should be entered if the Incomplete is not removed by the deadline.

All incomplete grades must be removed within six weeks after the first class day of the following term, excluding the summer session.  If the Incomplete is not removed by that date, the grade reverts to the grade indicated by the instructor's written statement authorizing the incomplete.

Discrimination and Harassment

North Idaho College has a zero tolerance policy for any acts of discrimination or harassment of any kind.  For more information, please see the NIC Student Handbook, Code of Conduct Article III and Article VIII. Compliance efforts with respect to these laws and regulations are the responsibility of each member of the campus community and are under the direction of the Dean of Students Office for Student Issues (2nd floor, Edminster Student Union Building, (208) 676-7156) and the Human Resources Office (Sherman Administration Building, (208) 769-3304) for employee issues.

Institutional Statement

DROP FOR NON-PAYMENT:  By registering at North Idaho College, you agree to provide payment by the due dates. You will be dropped from classes if payment is not received by  5 p.m. Pacific Time on the third day of the semester. Students on the waitlist will be given the option to register for classes after students are dropped for non-payment.

REMOVAL FROM CLASS FOR NON-ATTENDANCE:  Attendance is based on your participation in this class. Failure to attend may result in your being removed from this class and may result in your financial aid award being reduced. You are responsible for confirming the accuracy of your attendance record.