Introduction to Database

Curriculum Guideline

Effective Date:
Return to Course
Print Guideline
Course
OADM 1115
Discontinued
Yes
Course Code
OADM 1115
Descriptive
Introduction to Database
Department
Office Administration
Faculty
Commerce & Business Administration
Credits
2.00
Start Date
End Term
201730
PLAR
Yes
Semester Length
10 weeks X 5 hours/week = 50 hours/semester
Max Class Size
24
Contact Hours
5 hours per week 50 hours per semester
Method(s) Of Instruction
Online
Learning Activities

Communication between instructor and students will be conducted online using the WebCT email, discussion and chat utilities.  The instructor will guide the students through a series of learning objectives using motivation and online instruction.

Course Description
This is a BCCampus online provincial course. It introduces you to the Microsoft Access data management system. It will focus on planning, designing, and creating a database to meet the information management needs of today's workplace. You will learn terminology, database concepts and features of relational databases. You will use various commands and features to create tables, queries, forms and reports. You will enter data, work with calculations, extract information, generate and print reports. Each unit begins with an introduction and a set of learning objectives. The assigned readings, hands-on computer activities and follow-up reinforcement exercises are your principal learning activities. Additional materials and resources are available online.
Course Content
  • Unit 1     Introduction to Microsoft Access 2000
  • Unit 2     Maintaining a Database
  • Unit 3     Querying a Database
  • Unit 4     Creating Forms and Reports
  • Unit 5     Designing and Creating a Database
Learning Outcomes

Upon successful completion of this course you will be able to:

  • Identify and use database terminology
  • Design, create, modify and maintain a database
  • Sort and query to extract information from a database
  • Build and use a relational database
  • Create, modify and present forms, and reports for business related tasks
Means of Assessment
Assignments       40%
Quizzes  10%
Project I  20%
Project II  30%
Total 100%

 

 

Textbook Materials

Textbooks and Materials to be Purchased by Students

 

Text: New Perspectives on Microsoft Access 2002, Brief, by Joseph J. Adamski and Kathleen T. Finnegan. Course Technology, 2004. ISBN 0-619-02087-3
Software: Microsoft Access 2002 (XP), Internet Explorer or Netscape 4+, Windows 95/98/Me/2000/XP or NT

Prerequisites

OADM 1104 Online Learner Success