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
OLRN1030 Access - Expert

Description: Learn to use the advanced features of Microsoft Access for Windows. Upon completion, you will enhance tables by creating lookups, create various types of advanced queries, create advanced forms, create relationships between tables to ensure data accuracy, work with form controls, understand macro concepts, create, run, & test Access macros, create & use switchboard forms, set Access defaults, and apply Start-up options.
Hours: 30
Credits: 2
Pre-Requisites:
CoRequisites:

Details
OLRN1980 Access - Specialist

Description: Learn to use Microsoft Access for Windows. You will learn by using its pull-down menus, toolbars, and dialogue boxes. Access is a computerized database that allows you to manipulate, link, chart, query, and report your data to customize the information you need. Access creates a system of relational database management in a user-friendly environment.
Hours: 30
Credits: 2
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.
You'll start by learning how to create your new database by importing information from Excel spreadsheets into tables. Using action queries, you'll add and update key fields that allow you to build relationships among the tables. Then you'll master the steps for building complex yet easy-to-use forms to manage table data.
The course offers you tips and techniques for optimizing your database, 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 you queries more effective.
Once you've built your database, you'll examine how to build reports using conditional formatting to highlight key data points, and explore Visual Basic, a powerful programming language that allows you to automate simple and complex tasks. 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, this course will show you how to harness the full power of Microsoft Access 2010.
In these practical and project-oriented lessons, you'll learn how to use this award-winning MS Office software to create and customize tables. You'll build relationships between your tables to eliminate redundancies and slash data entry time. And you'll discover how to achieve huge reductions in data entry errors by setting default values, creating validation rules, and building input masks.
In addition, you'll find out how to make your database more user-friendly with custom data entry forms, smart lists, and other sophisticated controls. You'll learn how to retrieve exactly what you need from your database with powerful queries and reports, and you'll even start automating routine tasks with labor-saving macros.
By the time you've finished this course, you'll know how to create 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