Conestoga College Logo - Home Page

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 Length (Hours) Distance 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:

36 Yes 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:

36 Yes 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:

30 Yes 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:

30 Yes Details
INFO1970 Database Development Applications

Description: This course will explore how databases can support business needs through the identification of important Key Performance Indicators (KPIs) and how these KPIs support or influence business decisions. Specifically students will be engaged in exploring how data can be; gathered, manipulated, formatted, and presented as valuable information to specified end users through forms, reports and application designs.
Hours: 45
Credits: 3
Pre-Requisites:
CoRequisites:

45   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:

24 Yes 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:

24 Yes 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:

24 Yes Details
PROG1102 MySQL Databases

Description: Focus is on creation, modification, implementation, and maintenance of MySQL and MSSQL databases, as well as how these databases interface with internet applications and database servers. In addition to Access – Specialist, it is recommended that students have HTML – Introduction.
Hours: 42
Credits: 3
Pre-Requisites:
CoRequisites:

42 Yes Details
COMP1000 SQL Server Installation and Maintenance

Description: Recommended: Database Concepts PROG1870.
This course provides the student with experience in installing, configuring and maintaining SQL Server. The student will become familiar with the capabilities of the database system, know how to configure the various services available, implement security, perform backup and restore operations and optimize performance.
Hours: 36
Credits: 3
Pre-Requisites:
CoRequisites:

36   Details

Contacts for Databases.

SEARCH PART-TIME (PT)
Back To Top