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.