ITSK 1701 Database Applications

1
ITSK 1701Database Applications

• Jeff Chastine
• jeffchastine_at_clayton.edu

2
Course Overview

• Lecture 1 January 10, 2006

3
Basic Course Info

• ITSK 1701 Database Applications
• Time MW 500pm 550pm
• Instructor Jeff Chastine
• Office U305
• Office Hours T R 3-5
• Course Websitehttp//cims.clayton.edu/itsk1701

4
Text Books

• Access Comprehensive
• Database Management
• Book Rule
• Make sure to read the posted readings by the time
  that class starts so that you do not fall behind.
• Everything that I say is not in the book. The
  books are sometime incorrect or leave things out.
  I will strive to correct them if necessary

5
Course Description

• ITSK 1701 - Database Applications (1-2-1)An
  intermediate level skills course in Microsoft
  Access. Topics include reports, forms, OLE
  fields, sub forms, macros, VBA and the
  switchboard manager. An introduction to
  relational database theory and database design is
  included.In addition to class meetings, e-mail
  and the web will be primary modes of
  communicating course materials, special notices
  and for distributing and collecting assignments.

6
Course Objectives

• 1. Be able to describe the advantages and
  disadvantages of Database Systems2. Describe the
  major components of a Database Management
  System3. Develop Tables, Queries, Forms,
  Reports, Switchboards4. Describe the major
  components of a Relational Database5. Understand
  the purpose and benefits of the Relational
  Model6. Understand how to use Structured Query
  Language7. Understand the basics of Macros and
  VBA8. Develop a fully functional Access Database

7
Course Requirements

• This course is designed around lectures and
  problem solving questions. Much of the material
  covered is not always in the textbook. I
  recommend you attend class. QuizzesWith the
  exception of the first quiz they will be
  unannounced.
• There are NO makeups for quizzes.
• Exam PolicyYou get to drop a quiz.

8
Course Requirements

• CSU Policy
• Every student must have ready access to a laptop
  computer that meets the minimum specifications
  set forth by the university and/or program
• For more info http//itpchoice.clayton.edu
• MY 2 CENTS Make sure that you have a computer,
  you will need it.

9
Syllabus

• It is on the web

Calendar

• It is on the web
• It will change
• Check it weekly (at least) and make sure to
  complete assigned readings BEFORE class

10
Philosophies and Rules

• I Believe that everyone can make an A
• Show up to class
• Read the material
• Do the work
• Ask questions
• Study for the tests
• If you fail to do any of the above, the numbers
  show you will not do well in this course.

11
Rules

• With homework or quizzes
• DO NOT come to me the day that it is due and tell
  me that you did not
• Understand it
• Have time
• Need Help
• DO NOT expect an immediate response from me on
  email, I will respond ASAP to most emails.
• DO NOT E-mail me your assignments unless told to
  do so. I DO NOT ACCEPT ASSIGNMENTS BY EMAIL.
• Put ITSK 1701 in the subject line of email

12
Almost done

• If you need help, do not understand something,
  ASK!!!!!!!
• If you are confused, ASK!!!!!!!!
• If you are going to miss class, contact me in
  advance.

13
That is it for Now

• For Next Time Read Concepts Chapter 1
• Make sure your Email is set up
• Visit the HUB and have Access 2003 installed if
  you have not already done so.