COMP 0985: Database Management 12
Effective date
January 2017
Department
College & Career Access
Description
This course is designed to show students the concepts of database management using Microsoft Access. Students will learn how to create relational database tables, backup and repair the database, view data through queries, perform data editing with screen forms and generate formal output in a variety of report formats. On completion of this course students will be able to create a functional database system. Students will explore ethical and social issues of database use.
Completion of 2 of the following courses is required for completion of ABE Provincial Level Computer Studies: COMP 0982, COMP 0984, COMP 0985.
COMP 0982, 0984 and 0985 may be taken in any order.
Year of study
Grade 12 Equivalency
Prerequisites
Grade 10 English or equivalent.
Course Learning Outcomes
Upon successful completion of this course, students will be able to:
- Students will meet the learning outcomes for ABE Provincial Level Computer Studies (Database Management) as stated in the most current ABE Articulation Handbook.
Prior Learning Assessment & Recognition (PLAR)
None
Hours
Clinical, Lab, Rehearsal, Shop, Kitchen, Simulation, Studio: 96
Practicum, Self-Paced, Individual Learning: 96
Total Hours: 96
Instructional Strategies
Self-paced - one-to-one individualized instruction
Grading System
Letter Grade (A-F)
Evaluation Plan
Type
|
Percentage
|
Assessment activity
|
Assignments
|
20
|
Database files will be created and edited.
|
Project
|
20
|
Database with basic tables, queries, forms, reports.
|
Midterm Exam
|
30
|
Database with basic tables, queries, forms, reports.
|
Exam
|
30
|
Database with advanced tables, queries, forms, reports.
|
Course topics
- Introduction to Database Concepts
Building a Database
Working with Data
Developing Queries
Developing Forms
Developing Reports
Social and Ethical Issues
Notes:
- Course contents and descriptions, offerings and schedules are subject to change without notice.
- Students are required to follow all College policies including ones that govern their educational experience at VCC. Policies are available on the VCC website at:
https://www.vcc.ca/about/governance--policies/policies/.
- To find out if there are existing transfer agreements for this course, visit the BC Transfer Guide at https://www.bctransferguide.ca.