British Columbia Institute of Technologywww.bcit.ca/study/courses/bsys2061

Important Notice: COVID-19 Institute response

BCIT

BSYS 2061 - Business Data Management with MS Access 2019 for Windows

Business Systems Part-time Studies Course

School of Business + Media

To support you and your education, BCIT is adapting applied learning in formats appropriate to the unfolding global situation. All PTS classes are being delivered in an online format unless you are notified otherwise.

Course Details

​​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.

Prerequisite(s)

BSYS 1000 or BSYS 1001 or BSYS 1005

Credits

3.0

Cost

$592.47 - $627.60 See individual course offerings below for actual costs.

Winter 2021

Below are three offerings of this course for the Winter 2021 term.

CRN 77394

Mon Jan 04 - Mon Mar 22 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 04 - Mar 22 Online Delivery
See Notes below

Instructor

Masoud Jalili

Course Outline

Cost

$625.77

Notes

  1. Internet delivery format.
  2. Students must submit email address when registering. To be successful in our online courses, plan to spend 7-10 hours per course each week on your studies, starting Week 1. Our courses are paced and highly interactive with participation requirements weekly. Frequent contributions to asynchronous (not real time) online discussions is required to achieve a passing final grade. No class on Feb 15 Please note that the lecture component for this course is asynchronous, not requiring you to meet each and 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.
  3. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.

This course offering is in progress. Please check this page for other currently available offerings or subscribe to receive email updates.

In Progress

CRN 77743

Mon Jan 04 - Mon Mar 29 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 04 - Mar 29 Mon 17:30 - 20:30 Online Delivery
See Notes below

Instructor

Anurag Pandey

Course Outline

Cost

$617.60

Notes

  1. No class on February 15 This is not a self-paced course. You will be expected to be available and online on the posted days and times shown on your registration schedule. 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.
  2. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.

This course offering is in progress. Please check this page for other currently available offerings or subscribe to receive email updates.

In Progress

CRN 77742

Thu Jan 07 - Thu Mar 25 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 07 - Mar 25 Thu 18:30 - 21:30 Online Delivery
See Notes below

Instructor

Masoud Jalili

Course Outline

Cost

$627.60

Notes

  1. This is not a self-paced course. You will be expected to be available and online on the posted days and times shown on your registration schedule. 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.
  2. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.

This course offering is in progress. Please check this page for other currently available offerings or subscribe to receive email updates.

In Progress

Spring/Summer 2021

Below are four offerings of this course for the Spring/Summer 2021 term.

CRN 58571

Mon Apr 05 - Mon Jun 21 12 Weeks

Class Meeting Times

Dates Days Times Locations
Apr 05 - Jun 21 Online Delivery
See Notes below

Instructor

Masoud Jalili

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$592.47

Notes

  1. Internet delivery format.
  2. Students must submit email address when registering. To be successful in our online courses, plan to spend 7-10 hours per course each week on your studies, starting Week 1. Our courses are paced and highly interactive with participation requirements weekly. Frequent contributions to asynchronous (not real time) online discussions is required to achieve a passing final grade.
  3. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.

A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.

}

10 seats available as of Feb 26, 2021 1:20 pm (PST). Of these 10, 6 are currently reserved for domestic students only. Availability may change at any time.

CRN 57740

Tue Apr 06 - Tue Jun 22 12 Weeks

Class Meeting Times

Dates Days Times Locations
Apr 06 - Jun 22 Tue 18:45 - 21:45 Online Delivery
See Notes below

Instructor

Masoud Jalili

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$627.60

Notes

  1. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.

A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.

}

21 seats available as of Feb 26, 2021 1:20 pm (PST). Of these 21, 15 are currently reserved for domestic students only. Availability may change at any time.

CRN 60450

Tue May 04 - Tue Jul 20 12 Weeks

Class Meeting Times

Dates Days Times Locations
May 04 - Jul 20 Tue 09:30 - 12:20 Online Delivery
See Notes below

Instructor

Dave Lazenby

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$627.60

Notes

  1. Please direct any inquiries to the Program Assistant, Sarah Chanway, at schanway@bcit.ca.
  2. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.

A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.

}

1 seat remaining as of Feb 26, 2021 1:20 pm (PST). Availability may change at any time.

CRN 59675

Tue Jun 29 - Mon Aug 09 6 Weeks

Class Meeting Times

Dates Days Times Locations
Jun 29 - Aug 09 Tue/Thu 18:30 - 21:30 Online Delivery
See Notes below

Instructor

Anurag Pandey

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$627.60

Notes

  1. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.

A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.

}

21 seats available as of Feb 26, 2021 1:20 pm (PST). Of these 21, 14 are currently reserved for domestic students only. Availability may change at any time.

Learning Outcomes

Upon successful completion of this course, the student will be able to:

  • Explain when and why a database should be created.
  • Understand and Use database terminology.
  • Construct a database using a relational database management system.
  • Design and modify tables.
  • Explain and illustrate the data modeling process using normalization.
  • Build table relationships to meet business requirements.
  • Create single table and multiple-table based forms.
  • Search, modify, and analyze data using queries.
  • Create and customize reports to summarize and gain insights into data.
  • Export/Import data in various formats such as csv and xlsx.
  • Describe Machine Learning (ML) concepts and algorithms.
  • Conduct ML experiments using MS Azure cloud platform.
  • Describe the benefits of Artificial Intelligence (AI) and Machine Learning (ML).
  • Compare various prediction models such as regression and classification.
  • Carry out ML experiments using dataset preparation, training, and testing modules.

Effective as of Winter 2021

Related Programs

BSYS 2061 is offered as a part of the following programs:

School of Business + Media

  1. Accounting
    Part-time   Diploma
  2. Advanced Business Management
    Part-time/Distance & Online Learning   Certificate
  3. Advanced Human Resource Management
    Part-time   Certificate
  4. Business Administration (General Option)
    Part-time   Diploma
  5. Business Administration (Human Resources Option)
    Part-time   Diploma
  6. Business Administration (Management Option)
    Part-time   Diploma
  7. Finance
    Part-time   Diploma
  8. Financial Management (Finance Option)
    Part-time   Certificate
  9. Financial Management (Professional Accounting Option)
    Part-time   Certificate
  10. Financial Planning
    Part-time   Diploma
  11. Operations Management (Facilities Management Option)
    Part-time   Certificate
  12. Operations Management (Materials Management Option)
    Part-time   Certificate

Books & Supplies

The BCIT bookstore carries textbooks, general reference books, software, and stationery. Please visit bcit.ca/bookstore for more information.

Winter 2021

Books for Winter 2021 offerings of this course are available in the following BCIT online bookstores. Please choose the bookstore appropriate for the offering you are considering.

BCIT Downtown Campus Bookstore

If you are taking this course at the BCIT Downtown Campus (DTC), please purchase books for this course at the BCIT Downtown Campus Bookstore.

Image not available
Cei Digital: Np On Ms Office 365 & Access 2019, Comprehensive
Author Shellman
Copyright 2020
Binding Digital Version
ISBN 978-0-35739-272-0
Price $78.95
Choose One
Image not available
Np Ms Office 365 & Access 2019, Comprehensive
Author Shellman
Copyright 2020
Binding Paperback
ISBN 978-0-35702-575-8
Price $124.95
Choose One

BCIT Distance & Online Learning Bookstore

If you are taking this course through either Distance Education or Online Learning, please purchase books for this course at the BCIT Distance & Online Learning Bookstore.

Image not available
Cei Digital: Np On Ms Office 365 & Access 2019, Comprehensive
Author Shellman
Copyright 2020
Binding Digital Version
ISBN 978-0-35739-272-0
Price $78.95
Choose One
Image not available
Np Ms Office 365 & Access 2019, Comprehensive
Author Shellman
Copyright 2020
Binding Paperback
ISBN 978-0-35702-575-8
Price $124.95
Choose One

Spring/Summer 2021

No information on books is currently available for Spring/Summer 2021 offerings of this course.

Subscribe

Interested in being notified about future offerings of BSYS 2061 - Business Data Management with MS Access 2019 for Windows? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.

Privacy Notice: The information you provide will be used to respond your request related to BCIT course information and is collected under Section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA). For more information about BCIT’s privacy practices contact: Associate Director, Privacy, Information Access & Policy Management, British Columbia Institute of Technology, 3700 Willingdon Ave. Burnaby, BC V5A 3H2, email: privacy@bcit.ca.

Programs and courses are subject to change without notice.

Find Courses

School of Business + Media Waitlist

Need to waitlist for a School of Business + Media course?

Find out more

English Language Proficiency

BCIT's Part-time Studies English Language Proficiency Standard is English 12 (or equivalency). Students who do not meet this requirement should upgrade their English skills prior to any future registration.

Payment Changes At BCIT

We've changed the way we accept payments.

Find out more

Course Navigation, Related Links & Tools

Registration News

Registration is now open for the Spring/Summer 2021 term.

Classroom Locations

Classroom locations are subject to last minute changes. Please check the Part-time Studies Classroom Locations listing at www.bcit.ca/rooms on the first day of any course you are registered for.

Part-time Studies Financial Aid

Will you be studying at BCIT part-time? Do you need assistance funding your studies? Find out if you qualify for Part-time Studies financial aid.

© BCIT