Course Overview
This course builds on the database concepts from the Business Information Systems course. It continues the development of key database management concepts needed by business professionals including database design, advanced queries, forms and reports. Students will become familiar with macros, Visual Basic for Applications (VBA), and data access pages. Students will integrate their knowledge of databases in a final project focused on current business practices.
Prerequisite(s)
- No prerequisites are required for this course.
Credits
2.0
- Retired
- This course has been retired and is no longer offered. Find other Flexible Learning courses that may interest you.
Learning Outcomes
Upon successful completion, the student will be able to:
- Design a structured Relational Database Management System (RDBMS) life cycle.
- Create database objects to satisfy business rules.
- Apply searching and summarizing techniques to make business decisions.
- Discuss the key features of SQL and Microsoft SQL Server relevant to business professionals.
- Design simple data access pages to support business decisions.
- Incorporate macros and VBA to enhance database design.
- Analyze current issues in business data management.
Effective as of Fall 2014
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.