Page 1017 - SUBSEC October 2017_Neat

DATABASE MANAGEMENT – 20 marks

Specific The effectiveness with which candidate(s) use(s) or Mark Maximum
Objective manipulate features to Allocation marks per
sub-section
S6: SO3 Create a database (5)
 Appropriate fieldnames 1
 Appropriate data types 1
 Populating table 1
 Create minimum of two database tables/files 1
 Selecting a suitable primary key 1

S6: SO3 Simultaneous use of two or more tables/files (2)
 Joining between pairs of database tables/files 1
 Evidence of relationship (1:1 or 1:M) 1

S6: SO4 Create queries (5)
 Simple query (1 criteria) 1
 Complex query: >1 criteria (1) using more than 2
one table (1)
 Correct use of and result from calculated field 2
in query

S6: SO4 Sort a database table/file/Report (1)
 Evidence of sort 1

S6: SO5 Generate reports
 Selection of appropriate fields for report 1 (5)
 Statistical and/or summary features (for 1
example, count, sum, average)
 Grouping required fields 1
 Correct specific report title (2) 2
– Generic report title only (1)

Add VBA control to a form (2)
 Addition of at least ONE VBA control 1
 Appropriate use of control 1

CXC 30/G/SYLL 17 40