BSYS 2061 - Business Data Management with MS Access 2016
Business Systems Part-time Studies Course
School of Business
Course Details
In an information-based society, understanding data management is vital. The backbone of the Internet, Cloud Computing, Business Intelligence, and relational database management systems provide the key to utilizing business information to create a competitive advantage. This course provides an introduction to relational database management systems, data modeling, and the use of computer software to meet reporting and decision support needs within an organization. The student will use a relational database management system to create data tables, build table relationships, develop and modify custom forms, generate reports, and perform queries, while taking measures to ensure data validity, efficiency, and integrity. Subject to time available, additional topics will be included.
Prerequisite(s)
BSYS 1000 or BSYS 1001 or BSYS 1005
Credits
3.0
Cost
$604.90 - $612.04 See individual course offerings below for actual costs.
Winter 2019
Below are four offerings of this course for the Winter 2019 term.
CRN 77394
Duration
Mon Jan 07 - Mon Mar 25 12 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Jan 07 - Mar 25 | Online |
Instructor
Masoud Jalili
Course Outline
Cost
$612.04
Notes
- Internet delivery format.
- 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.
Status
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
Duration
Mon Jan 07 - Mon Apr 01 12 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Jan 07 - Apr 01 | Mon | 17:30 - 20:30 | DTC Rm. 310 |
Instructor
Anurag Pandey
Course Outline
Cost
$604.90
Notes
- No class on February 18th
Status
This course offering is in progress and full. Please check this page for other currently available offerings or subscribe to receive email updates.
In Progress and Full
CRN 77742
Duration
Thu Jan 10 - Thu Mar 28 12 Weeks
Instructor
Masoud Jalili
Course Outline
Cost
$612.04
Status
This course offering is in progress and full. Please check this page for other currently available offerings or subscribe to receive email updates.
In Progress and Full
CRN 78411
Duration
Fri Jan 11 - Fri Mar 29 12 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Jan 11 - Mar 29 | Online | ||
| Jan 18 | Fri | 18:30 - 21:30 | BBY SW03 Rm. 2695 |
| Feb 01 | Fri | 18:30 - 21:30 | BBY SW03 Rm. 2695 |
| Feb 15 | Fri | 18:30 - 21:30 | BBY SW03 Rm. 2695 |
| Mar 01 | Fri | 18:30 - 21:30 | BBY SW03 Rm. 2695 |
| Mar 15 | Fri | 18:30 - 21:30 | BBY SW03 Rm. 2695 |
| Mar 29 | Fri | 18:30 - 21:30 | BBY SW03 Rm. 2695 |
Instructor
Masoud Jalili
Course Outline
Cost
$612.04
Notes
- This is a hybrid course with 6 classes conducted with internet delivery format and 6 classes on the BCIT Burnaby campus in a computer lab classroom. Classroom lab sessions are used to present the course topics and help the students with their hands-on activities. Internet online Q&A discussion forums are used to review and comprehend class topics. Midterm and Final exams will be held during lab sessions. Students are expected to be familiar with basic computer skills as covered in BSYS 1001 or an equivalent course. Students must submit an e-mail address when registering for the course. Jan 11 – Online, Jan 18 in class, Jan 25 online, Feb 1 in class, Feb 8 online, Feb 15 Midterm exam in class, Feb 22 online, Mar 1 in class, Mar 8 online, Mar 15 in class, Mar 22 online, Mar 29 Final exam in class.
Status
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 2019
Below are four offerings of this course for the Spring/Summer 2019 term.
CRN 58571
Duration
Mon Apr 08 - Mon Jun 24 12 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Apr 08 - Jun 24 | Online |
Instructor
Masoud Jalili
Course Outline
Cost
$612.04
Notes
- Internet delivery format.
- 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.
Status
CRN 60450
Duration
Tue May 07 - Tue Jul 23 12 Weeks
Instructor
Dave Lazenby
Course Outline
TBD – see Learning Outcomes in the interim
Cost
$612.04
Notes
- Departmental approval needed
- This section of the course requires DEPARTMENTAL APPROVAL to enter, because it is run concurrently with the Business Fundamentals (BFUN) Program. Priority is given to students who have joined the program: https://www.bcit.ca/study/programs/7985acert, but we anticipate some seats will be released for general enrolment If the program is not showing “full”, then there are seats available for general registration. If you wish to enter this course, please fill out the form at this link https://www.surveymonkey.com/r/MNGVL6S Please do not contact the Program Assistant or Program Head to get approval as we will be basing decisions off the survey only. We will contact you within a few working days to let you know our decision.
Status
CRN 57740
Duration
Tue Apr 09 - Tue Jun 25 12 Weeks
Instructor
Masoud Jalili
Course Outline
Cost
$612.04
Status
This course offering is full. Please check this page for other currently available offerings or subscribe to receive email updates.
Full
CRN 59675
Duration
Tue Jul 02 - Thu Aug 08 6 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Jul 02 - Aug 08 | Tue/Thu | 18:30 - 21:30 | BBY SE06 Rm. 230 |
Instructor
Anurag Pandey
Course Outline
TBD – see Learning Outcomes in the interim
Cost
$612.04
Status
This course offering is full. Please check this page for other currently available offerings or subscribe to receive email updates.
Full
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.
- Create custom forms and reports.
- Utilize form and report tools and wizards.
- Outline the process of database project management.
- Describe the Systems Development Life Cycle (SDLC).
Effective as of Fall 2012
Related Programs
BSYS 2061 is offered as a part of the following programs:
School of Business
- Accounting
Part-time Diploma - Advanced Business Management
Part-time/Distance & Online Learning Certificate - Advanced Human Resource Management
Part-time Certificate - Business Administration (General Option)
Part-time Diploma - Business Administration (Human Resources Option)
Part-time Diploma - Business Administration (Management Option)
Part-time Diploma - Business Management
Part-time Certificate - Finance
Part-time Diploma - Financial Management (Finance Option)
Part-time Certificate - Financial Management (Professional Accounting Option)
Part-time Certificate - Financial Planning
Part-time Diploma - Operations Management (Facilities Management Option)
Part-time Certificate - 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 2019
Books for Winter 2019 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
| Np Ms Office 365 & Access 2016: Comp 1St Ed | |
|---|---|
| Author | Shellman |
| Copyright | 2017 |
| Binding | Paperback |
| ISBN | 978-1-30588-013-9 |
| Price | $125.95 |
| Required | |
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
| Np Ms Office 365 & Access 2016: Comp 1St Ed | |
|---|---|
| Author | Shellman |
| Copyright | 2017 |
| Binding | Paperback |
| ISBN | 978-1-30588-013-9 |
| Price | $125.95 |
| Required | |
BCIT Burnaby Bookstore
If you are taking this course, but are not taking it through either Distance Education or Online Learning, nor at the BCIT Downtown Campus (DTC), please purchase books for this course at the BCIT Burnaby Bookstore.
| Np Ms Office 365 & Access 2016: Comp 1St Ed | |
|---|---|
| Author | Shellman |
| Copyright | 2017 |
| Binding | Paperback |
| ISBN | 978-1-30588-013-9 |
| Price | $125.95 |
| Required | |
Spring/Summer 2019
No information on books is currently available for Spring/Summer 2019 offerings of this course.
Subscribe
Interested in being notified about future offerings of BSYS 2061 - Business Data Management with MS Access 2016? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.