INTRODUCTION
TO MS ACCESS
COURSE OUTLINE
Instructor:
Bob Fiske (robert_fiske@hotmail.com)
Class
Schedule Info:
- CRN 11304
- SCE,
Room 302
- Tuesdays from 6:00pm to 8:50pm, 9/15/09 to 12/1/09
Course
Objectives:
1. Learn the basic
components of an Access database
2. Learn how to create tables and forms
3. Know how to create and modify basic reports
4. Develop basic queries and use queries to answer questions
5. Make forms goof-proof
6. Become a skillful database creator
What
is a Skillful Database Creator
-
Focuses on understanding
users' data needs
-
Plans databases from the end
to the beginning
-
Understands that there is
more than one way to solve a database problem
-
Strives to provide/publish
data in an easily understood form
-
Uses built-in help and other
resource to be a creative learner
-
ALWAYS makes back-up files
Course
Topics:
-
Definition and types of
databases
-
Database objects
-
Editing, searching and filtering
tables
-
Creating basic reports
-
Toolbars and wizards
- Basic report customization