Page 1002 - SUBSEC October 2017_Neat

SECTION 6: DATABASE MANAGEMENT (cont’d)

SPECIFIC OBJECTIVES CONTENT

Students should be able to:

(c) Reports:

(i) use of report wizard;
(ii) use of sorting, grouping, statistical and
summary features, for example, count,
sum, and average;
(iii) report generated to screen, printer
and file; and,
(iv) renaming of report title.

Suggested Teaching and Learning Activities

To facilitate students’ attainment of the objectives of this Section, teachers/facilitators are encouraged
to engage students in the teaching and learning activities below.

1. Highlight various paper-based databases of which students may be aware and discuss
advantages of digitising these paper-based records. From the discussion, have students
generate definitions of a database and terminologies associated with a database.

2. Engage students in exercises where they create database tables and practise changing the
general properties of database tables.

3. Engage students in activities where they practise manipulating table-editing features such as
sorting, inserting and deleting records and fields.

4. Engage students in activities where they use given criteria to create simple queries that will
pull specific records from a table or tables.

5. Engage students in activities where they create presentable reports based on tables and/or
queries that can be distributed. Students should also practise generating additional report
details such as summary options.

CXC 30/G/SYLL 17 25