Prospectus

CGS 1541 & CGV 0250-Access 2000

Class Guidelines-Fall Term 2000

  
Instructor:  Ray Merry, www.raymerry.com , Email: ray@raymerry.com  
  
Required Materials: 
Text: Microsoft Access 2000 Bible, IDG Books, Carey N. Prague & Michael R. Irwin 
Optional Books: see: http://www.non.com/books/Microsoft_Access_cc.html  
Online tutorial Reference: http://www.functionx.com/access/  
See my website: for assignments and special notices: www.raymerry.com  click on students, then Access 2000. 
You also need 5-3.5 inch Floppies, and a 3 ring binder for your diskettes, tests, and notes. 

Grading will be a combination of POP quizzes during class, plus lab work and Exams. 
Points toward final grade:  Mid-Term 100 points: Labs, Quizzes and Assignments 100 points; Final Exam 200 points (100 in class +100 take home). Students caught cheating will flunk the exam. Repeats will flunk the course. (Total Points approximate, Exact Points subject to change) 
Letter Grade Equivalents: >= 90 =A; 80-89=B; 70-79=C; 60-69=D; <=59=F 

Since I am an Adjunct (part time) Professor, I do not have an office on campus. You may contact me 15 minutes before my classes (5:00PM) Thursday Evening, by Email, or as arranged privately. Since labs and quizzes are given during class (some without notice), attendance of all classes is important. Unless you give advance notice of missing a class you may not be able to make up those grades.

To contact me outside of class please email at: ray@raymerry.com  at least 1 day in advance.   In an emergency call --------.  Please let me know if you have trouble getting books, or if you have any other difficulties. 

Course Content: Using Microsoft Access 2000
Principles of Databases: Data Types, Fields, Records, Tables, Why use databases
Flat File Databases, Relational Databases, Types of Data, Sorts vs Indexes, and Keys; Master Keys, Uniqueness of Keys.  Arranging Data, Tables vs Databases.
Access vs. SQL, Oracle, FoxPro, Client Server Databases, and other Data access options.  
Using Access, Understanding How to Start Access and Use Menus and Toolbars and Wizards to accomplish any of the above.
Creating a Database in Access, Creating Tables.  Creating Forms, Creating Reports,  Modifying a Database Structure, Creating Queries, Creating Multiple Table Queries, Developing Forms with Subforms, Creating Complex Reports, Sharing Access Information with Other Office Applications, Creating Advanced Queries, Creating Macros, Maintaining the Database.

Study the assignments and best of luck!

Ray Merry