DATABASE & ADVANCED EXCEL CONCEPTS

Course: BUS2303


This course is part of the following part-time on campus and/or online program(s):

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

WINTER 2025
Online Learning
SectionDate(s)ModeDomestic FeesRegistration
800 Jan 14 - Apr 22Online$369.20Register Online
842 Mar 3 - Jun 9Online$369.20Register Online

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.