Course Overview
This instructor lead, hands-on course is aimed at those with no prior database experience and covers the use of the latest Microsoft Access database program. Students acquire the skills needed to create and manage functional Access databases. They will learn how to design database systems, generate basic forms and reports, and manipulate and query data through a combination of lectures and assignments. By the end of this course, successful participants will understand the Access approach to relational database management, and will be able to apply their skills to create, manage and maintain a database management system. COMP 1370 is not currently being offered.
- Not offered this term
- This course is not offered this term. Notify me to receive email notifications when the course opens for registration next term.
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Explain the purpose of MS Access.
- Understand the principals of normalization to create a functional database.
- Create multiple tables and establish relationships between tables.
- Add, modify and edit records in tables.
- Create data entry forms using wizards and customize forms.
- Create queries using the Query by Example (QBE) window.
- Effectively use the report generator.
Effective as of Spring/Summer 2019
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.