vcc.ca
OADM 1207: Access
Effective date
May 2020
Department
Admin Professional 1 & 2
School
Hospitality, Food Studies and Applied Business
Description
This course provides students with an understanding of how to manage information using MS Access, a relational database management system. Through hands-on training, students focus on how to add, update and delete information in tables, create basic forms for data entry, generate queries for extracting data, and produce reports for distribution.
Credits
1.5
Year of study
1st Year Post-secondary
Prerequisites
None
Corequisites
None
Course Learning Outcomes
Upon successful completion of this course, students will be able to:
- Demonstrate an understanding of the concept of a relational database
- Add, edit, and delete records in tables
- Add, edit, and delete records in forms
- Create queries with basic criteria to search for and extract data
- Generate and format basic reports
Prior Learning Assessment & Recognition (PLAR)
None
Hours
Lecture, Online, Seminar, Tutorial: 16
Clinical, Lab, Rehearsal, Shop, Kitchen, Simulation, Studio: 14
Total Hours: 30
Clinical, Lab, Rehearsal, Shop, Kitchen, Simulation, Studio: 14
Total Hours: 30
Instructional Strategies
This course uses lectures and demonstrations to help students achieve the learning outcomes in an interactive manner. In addition, the instructor will use assignments to help students apply the course material and identify strengths and weaknesses of their knowledge gained in the course.
Grading System
Letter Grade (A-F)
Passing grade
D
Evaluation Plan
|
Type |
Percentage |
Assessment activity |
|
Assignments |
15% |
Tables assignment |
|
Assignments |
15% |
Forms assignment |
|
Assignments |
15% |
Queries assignment |
|
Assignments |
15% |
Reports assignment |
|
Quizzes/Tests |
30% |
|
|
Participation |
10% |
|
Course topics
- Relational database and database design
- Creating and entering data in tables
- Creating and entering data in forms
- Creating select queries with criteria
- Generating and formatting reports
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.