Quelpr
2 marksGenerating Reports

CSEC Information Technology · January 2014 · Paper 2 · Question 8(e)

A report is generated from the database table. State TWO fields which could be used to group the data.

This question uses a figure or table from the paper — you'll see it when you practise.

The mark scheme is shown once you've answered.

Practise this question

Other parts of this question

  1. 8(a)State the name of the table used to store data in the database.[1 mark]
  2. 8(b)Which field in the table can be used as the primary key?[1 mark]
  3. 8(c)If the records in the table are sorted from the newest to the oldest member, what will be the Membership_No. of the member who would be at the TOP of the…[1 mark]
  4. 8(d)(i)How many fields will be displayed when the query shown in the grid is executed?[1 mark]
  5. 8(d)(ii)How many records will be displayed when the query shown in the grid is executed?[1 mark]

More practice: the rest of this paper · more Generating Reports questions · all CSEC Information Technology past papers