Skip to main content

Business Data Management with MS Access-Microsoft 365 for Windows BSYS 2061

Business Systems Course

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

Prerequisite(s)

Credits

3.0

Cost

$616.36 - $655.11 See individual course offerings below for actual costs.

Course offerings

Winter 2023

Below are three offerings of BSYS 2061 for the Winter 2023 term.

CRN 77743

Duration

Mon Jan 09 - Mon Apr 03 (12 weeks)

  • 12 weeks
  • CRN 77743
  • $642.25
Class meeting times
Dates Days Times Locations
Jan 09 - Apr 03 Mon 17:30 - 20:30 Downtown DTC Rm. 875
Instructor

Anurag Pandey

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$642.25

Important information
  1. No class on Feb 20 (Family Day)
Status

CRN 77742

Duration

Thu Jan 12 - Thu Mar 30 (12 weeks)

  • 12 weeks
  • CRN 77742
  • $655.11
Class meeting times
Dates Days Times Locations
Jan 12 - Mar 30 Thu 18:30 - 21:30 Burnaby SW03 Rm. 3655
Instructor

Masoud Jalili

Course outline

View

Cost

$655.11

Status

CRN 77394

Duration

Mon Jan 09 - Mon Mar 27 (12 weeks)

  • 12 weeks
  • CRN 77394
  • $616.36
Class meeting times
Dates Days Times Locations
Jan 09 - Mar 27 N/A N/A Online
Instructor

Masoud Jalili

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$616.36

Important information
  1. Internet delivery format.
  2. You have registered for an asynchronous course that will be held entirely online, but not requiring you to meet each and every week at a specific time. Please check the registration page for any specific dates and times that you will need to be available (i.e midterm and final exams). In this course, you will be using an online teaching tool called the Learning Hub, also known as D2L or Brightspace. The Learning Hub is where your instructor will share information, resources, assignments, deadlines and this is where you will submit your work, and communicate with both your instructor and classmates. Ensure that you are able to log in before your course starts. To log in, view your courses, set up notifications, and access the tools you need, please go directly to the Learning Hub at learn.bcit.ca/d2l/home. Your course will open either on or shortly before the start date.
Status

Full

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

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:

School of Business + Media

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

Subscribe

Interested in being notified about future offerings of Business Data Management with MS Access-Microsoft 365 for Windows (BSYS 2061)? 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 for 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.