OAT 151 Access Level I
Section 450
Spring 2006

Credits: 3				ROOM: W280		TIME: 6:00 - 9:50, M

Instructor: Tommy Lu		        OFFICE: W271		TEL: (302) 573-5475

E-mail address: lu@dtcc.edu	        Home Page: http://www.dtcc.edu/~lu

TEXT: Microsoft Office Access 2003, A Professional Approach, by Jon Jvarez, John Carter, and Kathleen Stewart, McGraw-Hill

COURSE OBJECTIVES: This course will teach the fundamentals of Microsoft Access. Topics include table, query, form, and report design, table relationships, and wizards. Upon completion of this course, participants may take Access Level II in preparation for the Microsoft Office Specialist (MOUS) certification test.

PREREQUISITE: All pre-tech courses completed.
EVALUATIONS: based upon the following: tests , in class labs/works, homework assignments/projects, and learning attitude.

1. Tests:  There will be four written tests including final exam.  The highest three test scores will be used to calculate
           your final grade.

2. In class labs/works: Range from 10 to 100 points, depends on the difficulty.  All in class labs/works are due either at
                        end of the class or at beginning of next class.  So if you missed a class, please check with me as
                        soon as possible to find out whether there is a class lab due.

3. Homework assignments/projects:  100 points each.

4. Homework assignments/projects:	57%
	Tests:				40%
	Learning attitude:		 3%

	Learning attitude includes class attendance (tardiness), participation and other subjective observations.

Grade:	average 92 or above				---> A
	average 83 or above but less than 92		---> B
	average 75 or above but less than 83		---> C
	average less than 75 but still attending classes---> R
	average less than 75 but stop attending classes	---> U

Class attendance is very important. I will take attendance at the beginning of the class and you will be marked absent if you were not in the class when the roll is called. If you missed a class, for any reason, please contact me as soon as possible for any in-class exercise, homework assignment and material covered. No make-up test will be given and any missing test will be assigned zero. If you have a question, please feel free to ask. Please do not let it skip. Everything you learn is building block for the next topic. Should you find yourself behind the class, please discuss it with me after the class and make an arrangement to catch up. Please don't wait until the last minute for it would be very difficult for both of us to work out plans.

Plagiarism is prohibited. All class exercises, homework assignments, and tests are individual work. Do your best but don't copy someone else's. Anyone found cheating would receive zero on that exercise, homework, or test.

All late assignments will be accepted with penalty:
	Within 1 day --->  5 points
	Within 1 week --> 10 points
	Within 2 weeks -> 20 points
	Within 3 weeks -> 30 points

	No late assignments will be accepted after 3 weeks.

Please save all your graded tests, e-mail message about your assignment/project scores, homework assignments, and projects. Should there is any arguments about your final grade, this is your only proof.

All homework assignments/projects must be turned in at the beginning of the class. You are not allowed to do your homework/project during lecturing. You have to place your name, chapter number, and assignment number on the upper left-hand corner. This is a requirement.

Please refer to the campus Student Handbook for further information regarding grading policies, student policies, academic dishonesty policy, and student support services available.

					Course Syllabus
Week
(Monday)		Topics
-----------------------------------------------------------------------------------------
1	1/9		Getting Started With A Database
			Lesson 1
                        Assignment #1

2	1/16		holiday (school closed)

3	1/23		Lesson 2

4	1/30		Test 1
                        Lesson 2
                        Assignment #2

5	2/6		Lesson 2
                        Assignment #3

6	2/13		Lesson 3

7	2/20		Lesson 4
                        Assignment #4

8	2/27		Test 2
                        Lesson 5
                        Assignment #5
                        Term Project

9	3/6		Lesson 6
                        Assignment #6

10	3/13		Lesson 7
                        Assignment #7

11	3/20		Lesson 8
                        Assignment #8

12	3/27		Test 3
                        Lesson 9

13	4/3		Lesson 9
                        Assignment #9

14	4/10		Lesson 10
                        Assignment #10

15	4/17		Spring Break (no classes, school open)

16	4/24		Project Night

17	5/1		Term project presentation

18	5/8		Final Exam