Course Outline / Syllabus

COURSE NUMBER: SA_Maj6
TITLE: HANDS-ON with DATABASE

DEPARTMENT / PROGRAM: BS SECRETARIAL ADMINISTRATION

SEMESTER AND SCHOOL YEAR: 2nd Semester, SY 2007-2008
INSTRUCTOR: MS. IRLYN JANETTE E. LOMBOY

COURSE DESCRIPTION

This course provides fundamental concepts, principles and hands-on experience on database and information system design using MS ACCESS 2003. It is designed as the first database course for Secretarial students who do not have database experiences

COURSE OBJECTIVES (DESIRABLE OBJECTIVES)

Towards the end of the course, students are expected to / able to:
Acquire an in-depth understanding of the fundamental concepts and theories on database and information systems
To understand the general process of database design and development using MS ACCESS 2003

COURSE OUTLINE AND TIMEFRAME

INTRODUCTION
MS Access Fundamentals
What's New in Access 2003

BASIC ELEMENTS of MS ACCESS 2003
Understanding the Access Program Screen
Using Menus
Using Toolbars
Filling Out Dialog Boxes

DATABASES & TABLES
Introduction to Databases
Starting Access and Opening a Database
Tour of a Table
Properties of the fields
Adding, Editing, and Deleting Records
Keystroke and Right Mouse Button Shortcuts
Opening and Modifying Database Objects
Relationships
Working with Multiple Windows

FORMS ,QUERIES & REPORTS
Tour of a Form
Tour of a Query
Tour of a Report
Previewing and Printing a Database Object
Selecting Data
Cutting, Copying, and Pasting Data

OTHER BUTTONS & SHORTCUTS
Using Undo
Checking Your Spelling
Getting Help
Changing the Office Assistant and Using the Button
Using the Zoom Box
Closing a Database and Exiting Access

REQUIRED READINGS

SUGGESTED READINGS

COURSE REQUIREMENTS
Assignments, Quizzes, Exams, Project, Blogs, Links,forums, Tree Planting

CONSULTATION HOURS

____________________