Database Management 12 (COMP 0985)

This course is designed to show students the concepts of database management using Microsoft Access. Students will learn how to create relational database tables, backup and repair the database, view data through queries, perform data editing with screen forms and generate formal output in a variety of report formats. On completion of this course students will be able to create a functional database system. Students will explore ethical and social issues of database use. Completion of 2 of the following courses is required for completion of ABE Provincial Level Computer Studies: COMP 0982, COMP 0984, COMP 0985. COMP 0982, 0984 and 0985 may be taken in any order.

Course code: COMP 0985

Credits: 4.0

Tuition: $0^*

Length: 96 hours

Course outline: https://www.vcc.ca/cfm-files/course-outline.cfm?subject=COMP&number=0985

Campus: Broadway

Prerequisites

Grade 10 English or equivalent.

Schedule†

COMP 0985 schedule for programs:

HMFT
LNCT

Course dates and times may vary throughout the term. Select the CRN number below to see a full schedule.

CRN #	Instructor	Dates	Day/Time	Instructor
44567	Elliott, Brock	January 1, 2020 to April 30, 2020		Elliott, Brock
44611	Elliott, Brock	February 1, 2020 to May 31, 2020		Elliott, Brock
44653	Elliott, Brock	March 1, 2020 to June 30, 2020		Elliott, Brock
60770	Elliott, Brock	May 1, 2020 to October 31, 2020	Mon, Tue, Wed, Thu \| 3:30 p.m - 6:30 p.m	Elliott, Brock
60862	Elliott, Brock	June 1, 2020 to November 30, 2020	Mon, Tue, Wed, Thu \| 3:30 p.m - 6:30 p.m	Elliott, Brock
74073	Elliott, Brock	September 1, 2020 to December 23, 2020	Mon, Tue, Wed, Thu \| 3:30 p.m - 6:30 p.m	Elliott, Brock
74230	Elliott, Brock	October 1, 2020 to January 31, 2021	Mon, Tue, Wed, Thu \| 3:30 p.m - 6:30 p.m	Elliott, Brock
74336	Elliott, Brock	November 1, 2020 to February 28, 2021	Mon, Tue, Wed, Thu \| 3:30 p.m - 6:30 p.m	Elliott, Brock
74443	Elliott, Brock	December 1, 2020 to March 31, 2021	Mon, Tue, Wed, Thu \| 3:30 p.m - 6:30 p.m	Elliott, Brock

Schedule†

COMP 0985 schedule for programs:

COMP

Course dates and times may vary throughout the term. Select the CRN number below to see a full schedule.

CRN #	Instructor	Dates	Day/Time	Instructor
45786	Elliott, Brock	April 1, 2020 to September 30, 2020	Mon, Tue, Wed, Thu \| 3:30 p.m - 6:30 p.m	Elliott, Brock

query

RESULTSET

query
	BEGIN_TIME_ROUND	DAY_OF_WEEK	END_DATE	END_TIME_ROUND	SIRASGN_PIDM	SSBSECT_CRN	SSBSECT_SEATS_AVAIL	SSBSECT_TERM_CODE	SSBSECT_VOICE_AVAIL	SSBSECT_WAIT_COUNT	SSRBLCK_BLCK_CODE	SSRMEET_BEGIN_TIME	SSRMEET_BLDG_CODE	SSRMEET_END_DATE	SSRMEET_END_TIME	SSRMEET_ROOM_CODE	SSRMEET_SCHD_CODE	SSRMEET_START_DATE	START_DATE	STVSCHD_DESC
1	2020-03-01 15:30:00.0	[empty string]	30-Apr-2020	2020-03-01 18:30:00.0	50000564	44567	20	202040	N	0	[empty string]	1530	DTN	2020-04-30 00:00:00.0	1829	[empty string]	S	2020-01-01 00:00:00.0	01-Jan-2020	Self Paced
2	2020-03-01 15:30:00.0	[empty string]	31-May-2020	2020-03-01 18:30:00.0	50000564	44611	22	202040	N	0	[empty string]	1530	DTN	2020-05-31 00:00:00.0	1829	[empty string]	S	2020-02-01 00:00:00.0	01-Feb-2020	Self Paced
3	2020-03-01 15:30:00.0	[empty string]	30-Jun-2020	2020-03-01 18:30:00.0	50000564	44653	22	202040	N	0	[empty string]	1530	DTN	2020-06-30 00:00:00.0	1829	[empty string]	S	2020-03-01 00:00:00.0	01-Mar-2020	Self Paced
4	2020-03-01 15:30:00.0	Mon Tue Wed Thu	30-Jun-2020	2020-03-01 18:30:00.0	50000564	45786	22	202040	N	0	[empty string]	1530	DTN	2020-06-30 00:00:00.0	1829	[empty string]	S	2020-04-01 00:00:00.0	01-Apr-2020	Self Paced
5	2020-03-01 15:30:00.0	Mon Tue Wed Thu	30-Jun-2020	2020-03-01 18:30:00.0	50000564	60770	22	202060	N	0	[empty string]	1530	DTN	2020-06-30 00:00:00.0	1829	[empty string]	S	2020-05-01 00:00:00.0	01-May-2020	Self Paced
6	2020-03-01 15:30:00.0	Mon Tue Wed Thu	30-Jun-2020	2020-03-01 18:30:00.0	50000564	60862	22	202060	N	0	[empty string]	1530	DTN	2020-06-30 00:00:00.0	1829	[empty string]	S	2020-06-01 00:00:00.0	01-Jun-2020	Self Paced
7	2020-03-01 15:30:00.0	Mon Tue Wed Thu	30-Sep-2020	2020-03-01 18:30:00.0	50000564	45786	22	202040	N	0	[empty string]	1530	DTN	2020-09-30 00:00:00.0	1829	[empty string]	S	2020-09-01 00:00:00.0	01-Sep-2020	Self Paced
8	2020-03-01 15:30:00.0	Mon Tue Wed Thu	31-Oct-2020	2020-03-01 18:30:00.0	50000564	60770	22	202060	N	0	[empty string]	1530	DTN	2020-10-31 00:00:00.0	1829	[empty string]	S	2020-09-01 00:00:00.0	01-Sep-2020	Self Paced
9	2020-03-01 15:30:00.0	Mon Tue Wed Thu	30-Nov-2020	2020-03-01 18:30:00.0	50000564	60862	22	202060	N	0	[empty string]	1530	DTN	2020-11-30 00:00:00.0	1829	[empty string]	S	2020-09-01 00:00:00.0	01-Sep-2020	Self Paced
10	2020-03-01 15:30:00.0	Mon Tue Wed Thu	23-Dec-2020	2020-03-01 18:30:00.0	50000564	74073	22	202070	N	0	[empty string]	1530	DTN	2020-12-23 00:00:00.0	1829	[empty string]	S	2020-09-01 00:00:00.0	01-Sep-2020	Self Paced
11	2020-03-01 15:30:00.0	Mon Tue Wed Thu	31-Jan-2021	2020-03-01 18:30:00.0	50000564	74230	22	202070	N	0	[empty string]	1530	DTN	2021-01-31 00:00:00.0	1829	[empty string]	S	2020-10-01 00:00:00.0	01-Oct-2020	Self Paced
12	2020-03-01 15:30:00.0	Mon Tue Wed Thu	28-Feb-2021	2020-03-01 18:30:00.0	50000564	74336	22	202070	N	0	[empty string]	1530	DTN	2021-02-28 00:00:00.0	1829	[empty string]	S	2020-11-01 00:00:00.0	01-Nov-2020	Self Paced
13	2020-03-01 15:30:00.0	Mon Tue Wed Thu	31-Mar-2021	2020-03-01 18:30:00.0	50000564	74443	22	202070	N	0	[empty string]	1530	DTN	2021-03-31 00:00:00.0	1829	[empty string]	S	2020-12-01 00:00:00.0	01-Dec-2020	Self Paced

CACHED

false

EXECUTIONTIME

SQL

SELECT ssbsect_crn, ssbsect_term_code, ssrblck_blck_code, ssrmeet_start_date, ssrmeet_end_date, TO_CHAR(ssrmeet_start_date, 'DD-Mon-YYYY') AS start_date, TO_CHAR(ssrmeet_end_date, 'DD-Mon-YYYY') AS end_date, ssrmeet_begin_time, ssrmeet_end_time, TRUNC( TO_DATE(CONCAT(ssrmeet_begin_time,'00'),'HH24:MI:SS')) + ( ROUND( (TO_DATE(CONCAT(ssrmeet_begin_time,'00'),'HH24:MI:SS') - TRUNC(TO_DATE(CONCAT(ssrmeet_begin_time,'00'),'HH24:MI:SS')) ) * 96 ) / 96) as begin_time_round, TRUNC( TO_DATE(CONCAT(ssrmeet_end_time,'00'),'HH24:MI:SS')) + ( ROUND( (TO_DATE(CONCAT(ssrmeet_end_time,'00'),'HH24:MI:SS') - TRUNC(TO_DATE(CONCAT(ssrmeet_end_time,'00'),'HH24:MI:SS')) ) * 96 ) / 96) as end_time_round, DECODE(ssrmeet_sun_day, 'U', 'Sun ', '') || DECODE(ssrmeet_mon_day, 'M', 'Mon ', '') || DECODE(ssrmeet_tue_day, 'T', 'Tue ', '') || DECODE(ssrmeet_wed_day, 'W', 'Wed ', '') || DECODE(ssrmeet_thu_day, 'R', 'Thu ', '') || DECODE(ssrmeet_fri_day, 'F', 'Fri ', '') || DECODE(ssrmeet_sat_day, 'S', 'Sat ','') AS day_of_week, ssrmeet_bldg_code, ssrmeet_room_code, sirasgn_pidm, ssbsect_seats_avail, ssbsect_wait_count, ssbsect_voice_avail, ssrmeet_schd_code, stvschd_desc FROM ssbsect INNER JOIN stvschd ON ssbsect_schd_code = stvschd_code AND ssbsect_schd_code NOT IN ('PLA', 'CL', 'CB', 'CI', 'T') LEFT OUTER JOIN ssrblck ON ssrblck_term_code = ssbsect_term_code AND ssrblck_crn = ssbsect_crn LEFT OUTER JOIN ssrmeet ON ssrmeet_term_code = ssbsect_term_code AND ssrmeet_crn = ssbsect_crn LEFT OUTER JOIN sirasgn ON sirasgn_crn = ssbsect_crn AND sirasgn_term_code = ssbsect_term_code WHERE ssbsect.ssbsect_subj_code = 'COMP' AND ssbsect.ssbsect_crse_numb = '0985' AND ssbsect.ssbsect_term_code >= 202040 AND ssbsect.ssbsect_ssts_code = 'A' AND ssbsect.ssbsect_ptrm_end_date > sysdate-1 ORDER BY ssrmeet_start_date, ssrmeet_begin_time, ssbsect_crn

array

struct
1	44567
2	[empty string]

struct
1	44611
2	[empty string]

struct
1	44653
2	[empty string]

struct
1	45786
2	[empty string]

struct
1	60770
2	[empty string]

struct
1	60862
2	[empty string]

struct
1	45786
2	[empty string]

struct
1	60770
2	[empty string]

struct
1	60862
2	[empty string]

struct
1	74073
2	[empty string]

struct
1	74230
2	[empty string]

struct
1	74336
2	[empty string]

struct
1	74443
2	[empty string]

array

struct
1	HMFT LNCT
2	44567 44611 44653 60770 60862 74073 74230 74336 74443
3	[empty string]

struct
1	COMP COMP
2	45786
3	[empty string]

Contact us

Frequently asked questions

Ask a question

Book an appointment with an advisor

fill out an online form
Call 604.871.7000, option 2

INTERNATIONAL STUDENTS

Visit VCC International for contact information.

* Fees are approximate and subject to change. Students are required to pay any applicable fee increases. Fees listed are for domestic students. For international programs, visit VCC International.

† This information is intended as a guideline only. Program and course details are subject to change with the approval of VCC's Board of Governors.

Database Management 12 (COMP 0985)

Prerequisites

Schedule†

COMP 0985 schedule for programs:

Schedule†

COMP 0985 schedule for programs:

Additional Information

Contact us