Conestoga College Logo - Home Page

Distance Learning - Part-time Courses - Databases

Click on the course code or title below for a full description of the course. If available for registration, clicking on "Details" in the Status column will open a new browser tab or window in the Student Portal.

Courses
Course # Courses Status
COMP1906 Access

Description: This course introduces students to Access, an application that manages data. Students will be exposed to database components, terminology, the creation and use of data-entry forms, queries, reports and switchboards.
Hours: 36
Credits: 3
Pre-Requisites:
CoRequisites:

Details
COMP1907 Access - Advanced

Description: This course is intended to further develop skills acquired in the Access course. Basic concepts will be reviewed and extended to teach you the techniques for setting up and maintaining database systems. With Visual Basic for Applications (VBA), students will develop a simple business application from the problem definition stage through to implementation.
Hours: 36
Credits: 3
Pre-Requisites:
CoRequisites:

Details
COMP1115 Intermediate Microsoft Access 2010

Description: Do you have experience building Microsoft Access 2010 databases, but want to take your skills to the next level? In this course, you'll build an entire database project from scratch. By the time you've completed the course, you'll have a fully functional database that tracks customer and order information.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1072 Intermediate Microsoft Access 2013

Description: Do you want to take your Microsoft Access 2013 skills to the next level? In this course, you'll learn how to use this program's advanced features to build a fully functional database from scratch.
You'll start by creating your new database as you import customer and order information from several Excel spreadsheets into tables. Using action queries, you'll add key fields to the tables and learn to build table relationships between the tables.
Next, you'll learn how to build complex yet easy-to-use forms to manage table data. You'll gain tips for adding the information you need without overcrowding your forms, including ways to build crosstab and summary queries so you can access information quickly and easily. You'll also learn about outer table joins that can make your queries more effective.
Once you've built your database, you'll discover how to create reports using conditional formatting to highlight key data points. You'll also explore Visual Basic and learn how to create a report dialog box so users can filter report data. Finally, you'll put the finishing touches on your database as you build a navigation form to make it easy for your users to find what they need.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1017 Introduction to Access 2010

Description: Take control over your data! Whether you're a novice or an experienced database user, these hands-on lessons will show you how to harness the full power of Microsoft Access 2010. You'll learn to build and customize tables, and you'll discover how to use forms to simplify data entry, create reports, and design queries. By the time you've finished this course, you'll know how to construct an effective database for any information you need to store, document, and manage—at home or on the job.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details

Program contacts for Databases.

Back To Top