DATABASE & ADVANCED EXCEL CONCEPTS
Course: BUS2303
This course is part of the following part-time on campus and/or online program(s):
- Business Administration - Accounting
- Business Administration - Accounting
- Business Administration - General Business
- Business Administration - General Business
- Business Administration - Human Resources
- Business Administration - Human Resources
- Business Administration (Core)
- Business Administration (Core)
Databases and data analysis are pervasive in today's work environments. Students study advanced Excel topics, including pivot tables, filters, tables, what-if analysis tools, data validation and error checking and preparing Excel data for use in databases. Students also learn how to design and use a database using Microsoft Access, and import data from Excel. Emphasis is on extracting information from Access databases by creating and using queries. A combination of lectures, practical demonstrations, in-class and out of class assignments and review simulations contribute to the students' learning experience. Mac students, please note that Microsoft Access will not run on a Mac without additional software.
Notes
Prerequisites
DAT5758 or BUS2301
Required Software
MS Project 2016 and MS Access 2016 (included through VPN connection to Algonquin's MyDesktop).
| FALL 2024 |
| Online Learning |
| Section | Date(s) | Mode | Domestic Fees | Registration |
|---|---|---|---|---|
| 800 | Sep 10 - Dec 17 | Online | $369.20 |  |
| 842 | Nov 1 - Feb 7 | Online | $369.20 | |
Please Note: Off-shore international students enrolling in online courses will be subject to an international premium fee per course registration.
Every attempt is made to ensure the accuracy of the information in this publication. The College reserves the right to modify or cancel any course, program, fee, timetable, or campus location at any time.