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

BCIT is planning for a substantial return to on-campus activity for the fall 2021 term as informed by BC Public Health Officer guidelines. Refer to each course listing for details.

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

$606.50 - $641.04 See individual course offerings below for actual costs.

Fall 2021

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

CRN 37323

Wed Sep 08 - Wed Nov 24 12 Weeks

Class Meeting Times

Dates Days Times Locations
Sep 08 - Nov 24 Wed 18:30 - 21:30 BBY

Instructor

TBD

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$641.04

Notes

  1. All BSYS computer courses/classes conducted on campus will be done in a regular classroom and students must bring their own device to class. See details at: https://www.bcit.ca/files/business/pdf/bcit-sobm-byod.pdf
  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 has been cancelled. Please check back next term or subscribe to receive email updates.

Cancelled

CRN 36381

Mon Sep 13 - Mon Dec 06 12 Weeks

Class Meeting Times

Dates Days Times Locations
Sep 13 - Dec 06 Online

Instructor

Masoud Jalili

Course Outline

Cost

$640.04

Notes

  1. Internet delivery format.
  2. Please provide your current e-mail address upon registration. This course is offered with the expectation that students have access to a computer with Microsoft Windows Operation System. No class on October 11. All BSYS computer courses/classes conducted on campus will be done in a regular classroom and students must bring their own device to class. See details at: https://www.bcit.ca/files/business/pdf/bcit-sobm-byod.pdf
  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 and full. Please check back next term or subscribe to receive email updates.

In Progress and Full

CRN 40272

Mon Sep 13 - Mon Dec 06 12 Weeks

Class Meeting Times

Dates Days Times Locations
Sep 13 - Dec 06 Mon 17:30 - 20:30 DTC DTC Rm. 375

Instructor

Anurag Pandey

Course Outline

Cost

$606.50

Notes

  1. No class on October 11. All BSYS computer courses/classes conducted on campus will be done in a regular classroom and students must bring their own device to class. See details at: https://www.bcit.ca/files/business/pdf/bcit-sobm-byod.pdf
  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 back next term or subscribe to receive email updates.

In Progress

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

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 Fall 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