CGS 1541 & CGV 0250-Access
Class Guidelines-Fall Term 2000
Instructor: Ray Merry, www.raymerry.com
, Email: email@example.com
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: firstname.lastname@example.org
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
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
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.
the assignments and best of luck!