CGS 1544
For syllabus click here.
Faculty who teach this class are: (click on their name to view their
homepage)
Jerry Williams
CGS1544
DATA BASE MANAGEMENT USING MICROSOFT ACCESS
COURSE SYLLABUS
College
Web Site:
http://www.gc.cc.fl.us
Pre-Requisite:
CGS 1570 Microcomputer Applications
Textbook:
Exploring Microsoft Access 2000, 1999 VBA Edition, Grauer,
Prentice-Hall
Catalog
Description:
Introduction to relational database design, construction and implementation.
Students are
provided with a working knowledge of how to design forms, reports, queries, and
menus
in Microsoft Access. Students will build several database management systems
ranging
from a simple address book to fully functional business systems.
Course
Objective:
1. The
Concepts of Database Management
2.
How to Navigate within Microsoft Access
3.
How to Build Tables, Queries, Forms, and Reports
4.
Understanding of Relational Database Concepts and Advanced Queries
5.
How to use Access Controls in Forms and Reports
6.
How to Build Customized Forms and Reports
7.
How to Incorporate Pictures, Images, and Graphs in Access
8.
How to Write Access Macros
9.
How to Build a Relational Database Application Using Access
10. How to
Connect Access with Other Types of Data files
Method
of Instruction:
Lectures and interactive participation by the student in the resolution of
problems and
exercises.
Grading:
Lectures and interactive participation by the student in the resolution
of problems and
exercises. Major
tests: Two unit exams will be administered. The exam will be based upon class
lectures, class discussions, and the textbook. (Each exam is worth up to 100
Points for a possible total of 200 points.)
Final
exam: The final exam will be course comprehensive. The final will be based upon
lectures, class discussions, and the textbook. There will be no exemptions from
the final exam. (Possible points = 200).
Project
requirements: There are Three (3) required projects assignments in this course.
Your instructor will provide you with guidelines for each project at the
appropriate time within the course. These assignments count for a total of one
third of your course grade. (Project #1 & #2
= 100 points each, Final Project = 200 points.) (Possible points = 400).
Grading
Scale: "A" = 90 - 100% (752 - 800 points), "B" = 80 - 89%
(688 - 751 points), "C" = 70 - 79% (600 - 687 points), "D" =
60 - 69% (520 - 599 points), "F" = 0 - 59% (0 - 519 points).
Policy
on Make-up Exams:
As a general rule, I do not give make-up exams. Only in the case of unusual
mitigating
circumstances, agreed to by the instructor prior to the exam period, will other
arrangements be made.
Course
Requirements:
1. Assignments
must be turn in all assignments, there will be no incomplete (“I”) grades
given, you simply get zero points for that assignment. Only under unusual
circumstances, as determined by and negotiated with your instructor, will the
assignment of an “I” grade be contemplated
2. Summaries
and systems analysis projects turned in after their due date will be
accepted, but a 10% penalty will be imposed before the assignment is graded.
College
Attendance Policy:
Students who are absent from class more than one eighth of a course without the
instructor=s permission shall be withdrawn. Please consult
with class instructors for
specific class attendance and grading policies.
In order to have an absence excused, the student must take the initiative of
contacting
the instructor with a justifiable excuse immediately following the absence.
Failure to
contact the instructor may result in withdrawal from the course after the
allotted number
of classes has been missed.
Tardiness is considered disruptive behavior and are highly discouraged. If a
student is
not present for roll call, the student will be considered absent. These absences
will be
counted along with other unexcused absences in determining whether the student
should
be withdrawn from class. If a student is late for class and has a justifiable
excuse, the
student must take the initiative to contact the instructor at the conclusion of
that class
period. Failure to have the tardy excused will result in an unexcused absence
for that
day.
Leaving class prior to the end of the class period is considered disruptive
behavior. If
there is a serious need to leave class early, the student is expected to receive
the
permission of the instructor prior to the beginning of class. In an emergency,
the student
should contact the instructor after class. Failure to receive permission from
the
instructor upon leaving class early, will result in an unexcused absence.
These policies are consistent with general college policy regarding absences and
tardies. The policies are not intended to regiment class procedure or to
penalize the
average student that is punctual and regular in class attendance. The policies
are
intended to minimize class disruptions and maintain an orderly class procedure.
Notes:
ASK QUESTIONS! There is no
such thing as a “stupid question.”
