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

BUS2301 or DAT5758

Required Software

MS Project 2016 and MS Access 2016 (included through VPN connection to Algonquin's MyDesktop).

SUMMER 2024
Online Learning
SectionDate(s)ModeDomestic FeesRegistration
800 May 14 - Aug 20Online$369.20Register Online
842 Jul 2 - Oct 8Online$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.