CIS 155 - Introduction to Microsoft Access
Syllabus - Fall 2007
Horizontal Line of Flowers

Instructor:  Marge Hohly
Email address:  m.hohly@verizon.net
res02i0t@gte.net
mhohly@dslextreme.com

Hohly@cerritos.edu
Home page:  http://www.cerritos.edu/hohly
Location & Time:  5:00-10:00 pm BE-12
Ticket number:  #30971- Traditional
#32187 - Online
Phone number: 

Skype address:

(562) 860-2451 Ext. 2736 voice mail available 
(562) 467-5033 (BE-12) no voice mail
marge.hohly
Office hours:  6:00 - 7:00 p.m. Tuesday, in SS-25 or BE-12
4:00 - 5:00 p.m. Wednesday in SS-25 
4:00 - 5:00 p.m. Thursday, in SS-25 or BE-12 
Office: SS-25

 

Textbooks: 

New Perspectives on Microsoft Access 2007 - Comprehensive by Joseph Adamski & Kathleen Finnegan, Course Technology, 2007
ISBN 13: 978-1-4239-0589-9
ISBN  10: 1-4239-0589-X
Access 2007 cover graphic
Materials:  A USB drive (best choice) or writable CD's.

Horizontal line of flowers 
BASIS FOR DETERMINING COURSE GRADE

Lab Assignments 15 @ 20 points each

300

2 Exams  @ 75 pt each      150
Final Exam

100

Total Points

550

  A=495, B=440, C=357, D=275, Fail=274 and below

horizontal line of flowers
Tentative Schedule  

Week
day

Topics to be covered

Chapters
Lecture Text

Lab
Assignments

1
Aug. 16

  • Introduction to Microsoft Ofice Access 2007
1 Lab 1 - Tutorial 1

2
Aug. 23

  • Getting Started with Microsoft Office 2007I
  • Creating a Database  cont.
1  

3
Aug. 31

  • Building a Database and Defining Table Relationships
  • Labor day Holiday Monday 9/3 only
2 Lab 2
Lab 3

4
Sept. 6

  • Maintaining and Querying a Database
3 Lab 4
Lab 5

5
Sept. 13

  • Maintaining and Querying a Database (cont)
  • Creating Forms and Reports
3, 4  Lab 6
Labs 1-3 are due by 11 pm Thursday Sept. 13 PDT (9/14, 2 am EDT)

6
Sept. 20

  • Creating Forms and Reports
4 Lab 7

7
Sept. 27

  • Creating Advanced Queries and Enhancing Table Design
5
 
 Lab 8
Lab 9
Labs 4-5 are due by 11 pm Thursday Sept. 27 PDT (9/28, 2 am EDT)

8
Oct. 4

  • Creating Custom Forms
5 (cont.) 
6
 Labs 6-7 are due by 11 pm Thursday Oct. 4 PDT (10/5, 2 am EDT)

9
Oct. 11

  • Exam 1 - covers chapters 1-4, given in BE-12 on-campus (may be taken online also, but on-campus is preferred)
6 (cont) if time available Lab 10
Lab 11

10
Oct. 18

  • Creating Custom Reports
6(cont.)
7
Lab 12
Labs 8-9 are due by Thursday Oct. 18 at 11 p.m. PDT (10/19, 2 am EDT)

11
Oct. 25

  • Creating Custom Reports
7 Lab 13

12
Nov. 1

  • Using Action Queries and Advanced Table Relationships
9 Lab 14
Labs 10-11 are due by Thursday Nov. 1 at 11 p.m. PST (11/2, 2 am EST)
13
Nov. 8
  • Using Action Queries and Advanced Table Relationships
 
9 Lab 15
14
Nov. 15
  • Exam 2 (Chapters 5-7) given  in BE-12
    Labs 12-13 are due by Thursday Nov. 15 at 11 p.m. PST (11/16, 2 am EST)
15
Nov. 22
  • Thanksgiving Recess - campus closed Nov. 22-25
   10 Lab 16 - Bonus    
16
Nov 29
  • Lab day
  • Automating Tasks with Macros
  • Managing and Securing a Database
10,
12
Labs 14 are due by Thursday Nov. 28 at 11 p.m. PST (11/29, 2 am EST)
17
Dec. 6
  •  Last day to submit labs and lab corrections
  Labs 15-16 are due by Thursday Dec. 6 at 10 p.m. PST (12/7, 1 am EST)
18
Dec 13
  • Final
    Thursday,
    Dec. 13,
    6-8  p.m. in BE-12 for the traditional students.  Online students must complete the final exam by 8 pm PST (All  chapters)
    

Please Note: CIS labs are closed during final exams, 12/8-12/14.
Last day to drop with a grade of "W" is 11/16/07

The above schedule is subject to change. Changes will be announced in class and updated on this website.

NOTE:  The student will need access to Microsoft Office2007 to do the assignments for this course.  The Office suit needs to include  Access 2007.  If you do not have the software on your computer you may do the hands-on work on the campus computers. The campus labs have Office 2007 loaded.  Cerritos College does not supply students computer software for home computers.

The lab assignments and links to lecture and supporting materials are found on the class web pages.   Please refer to these pages for more information.  Make sure that you print out the separate sheets that contain the lab assignments.  When saving any component of the lab include your last name in the file name/title.

Revisions to schedule will be made to the syllabus and posted on the web sites for this class. Lab, lectures, and supporting materials for this class on the college websites.    It is the students responsibility to retrieve their assignments from the Web pages or in the classroom. All assignment must be submitted to your instructor with the required printouts and  the database(s) for the assignment uploaded into webct for each assignment.   

There are  two websites for the class.  One site is located on the Cerritos College website at http://www.cerritos.edu/hohly and the other is on Webct and can be reached at http://ct.webct.com.


Remember it is critical to keep in contact with your instructor.  If you have not been heard from  for 3 weeks or are not making academic progress you will be dropped from the class.

Academic honesty is expected.  You should reference the college academic honest policy in the catalogue and schedule of classes (pages 137-138)

 

horizontal line of flowers

(C155Fa2006syl.html)
 last update:  10/17/2007