Computer Studies Paper 2, WASSCE (SC), 2021

Question 1

 

(a)  What are reports in a database system?
       (b)  List four ways in which report can be viewed in data base management system.
       (c)  Outline the step to print a report in MS Access.

 

 

Observation

The question tested candidates’ knowledge on database.


The expected answer is:


Question One

(a) A report is a database object that is used to present information in database for the purpose of displaying or distributing a summary of data.

OR
Reports offer a way to extract and present a specific subset of the information from a large database.
OR
Reports allow the user to organize and present your data in a reader-friendly, visually appealing format.
OR
Reports present data from tables and also from queries.
OR
A database report is the formatted result of database queries and contains useful data for decision-making and analysis.                

                         

(b)Reports can be viewed through

      • Design view
      • Report view
      • Layout view
      • Print preview                                                                                                  

 

(c)Steps to print a Report

      • right-click on the report name on the navigation pane
      • click Print Preview
      • click Print/ CTRL +P
      • click Ok                                                                                                                     

OR

      • Select the report on the navigation pane and click
      • click Print Preview
      • click Print/ CTRL +P
      • click Ok

 

The Chief Examiner reported that most of the candidates who attempted the question showed poor knowledge of the area tested.