Course Overview
In an information-based society, understanding data management is vital. The backbone of the Internet, Cloud Computing, and Business Intelligence are relational database management systems. The use and manipulation of data is the key to utilize business information to create a competitive advantage. This course introduces relational database management systems, data modeling, and artificial intelligence. Students will use Microsoft Access, a relational database management system, to create data models and build data applications. An introduction to Artificial Intelligence, Machine Learning, and Deep Learning tools and models will also be included in the course. Microsoft 365 is a suite of Microsoft software which includes Word, Excel, PowerPoint, and Outlook. Access is provided to all current BCIT students. BSYS courses and materials are designed to be delivered on a MS Windows environment.
Domestic fees
$681.31 - $710.35 See individual course offerings below for actual costs.
International fees are typically 3.4 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Explain when and why a database should be created.
- Create a database using a relational database management system.
- Build tables and define table relationships.
- Explain and illustrate the data modeling process using normalization.
- Prepare single-table and multiple-table queries using advanced criteria.
- Design input and output interfaces for your data application.
- Create custom forms and reports.
- Utilize form and report tools and wizards.
- Outline the process of managing a database application development project.
Effective as of Spring/Summer 2022
Related Programs
Business Data Management with MS Access-Microsoft 365 for Windows (BSYS 2061) is offered as a part of the following programs:
- Indicates programs accepting international students.
School of Business + Media
- Business Administration (General Option)
Diploma Part-time
- Business Administration (Human Resources Option)
Diploma Part-time
- Business Administration (Management Option)
Diploma Part-time
Course Offerings
Fall 2026
Below are two offerings of BSYS 2061 for the Fall 2026 term.
CRN 49501
Dates
Sep 07 - Dec 07 Loading
- CRN 49501
- $710.35 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Sep 07 - Dec 07 | Mon | 17:30 - 20:30 | Downtown DTC Rm. 374 |
Duration
12 weeks
Instructor
Anurag Pandey
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Important information
- No class on Monday, October 12
Confirmation
Required
To proceed with registration and add this course to the cart, please confirm:
Status
If you have any questions about this course, please contact us.
CRN 49513
Dates
Sep 07 - Nov 23 Loading
- CRN 49513
- $681.31 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Sep 07 - Nov 23 | N/A | N/A | Online |
Duration
12 weeks
Instructor
Masoud Jalili
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Important information
- This course is online and asynchronous, it does not require you to meet every week at a specific time, however, there will be specific timelines for assignments and exams. It is important you have a stable and consistent internet connection to access course content. Course content, type and quality of assignments, and general standards for this online course are the same as classroom courses. To be successful in this online course, plan to spend 7-10 hours per week on your studies, or more of it’s a condensed course, starting Week 1. Important course information will be sent to your myBCIT account prior to your course start date.
Confirmation
Required
To proceed with registration and add this course to the cart, please confirm:
Status
If you have any questions about this course, please contact us.
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.