Get premium membership and access revision papers, questions with answers as well as video lessons.

Pcmp 003: Database And Desktop Publishing Question Paper

Pcmp 003: Database And Desktop Publishing

Course:Certificate In Computer Application

Institution: Chuka University question papers

Exam Year:2013

CHUKA

UNIVERSITY

UNIVERSITY EXAMINATIONS
EXAMINATIONS FOR THE AWARD OF CERTIFICATE IN COMPUTER APPLICATION
PCMP 003: DATABASE AND DESKTOP PUBLISHING
STREAMS: TIME: 2 HOURS
DAY/DATE: FRIDAY 12/4/2013 8.30 AM – 10.30 AM
INSTRUCTIONS:

1. (a) Define the term database. [2 Marks]

(b) State three examples of database management software. [3 Marks]

(c) Define the following terms as used in databases. [6 Marks]

(i) Tables
(ii) Records
(iii) Field.

2. (a) Explain the procedure of starting Microsoft Access. [4 Marks]

(b) Explain three features of database management software. [6 Marks]

3. (a) State four functions of a database management software. [4 Marks]

(b) Explain four data types allowed in Ms Access. [8 Marks]

4. State four weaknesses of the traditional data and information management that
have been overcome by the electronic databases. [4 Marks]

5. State two database models. [2 Marks]

6. (a) Define the term desktop publishing. [2 Marks]

(b) Give any three examples of desktop publishing software available in the market today. [3 Marks]

7. Identify four different types of publications that can be produced using desktop publishing software. [4 Marks]

8. State four advantages of DTPs over Word Processor. [4 Marks]

9. Explain the procedure of launching Ms Access. [4 Marks]

10. Computerized databases reduce redundancy. Explain this statement. [3 Marks]

11. Mr. Kamau owns a big groceries shop in Ndagani. He wishes to develop a small database to manage his stock. Suggest at least three tables for this database. [3 Marks]

12. A school keeps information on each of its pupils and part of the information
contained on the computer file is shown below.

ADM NO SURNAME FIRSTNAME DATE OF BIRTH TUTOR INITIALS
200 JOHN KAMAU 10/2/90 JK
201 KINYUA KAMAU 1/2/90 KK
202 MARTIN MWAURA 21/3/90 MM
203 MURITHI KAMAU 22/4/90 MK
204 MWAI TOM 24/4/99 MT

(i) How many records are shown? [2 Mark]

(ii) How many fields does each record have? [2 Marks]

(iii) In all computer database systems there is a unique field. Which is the unique field
in this section of this file? [2 Marks]

(iv) Why is it important to have unique field? [2 Marks]

---------------------------------------------------------------------------------------------------------------------

Pcmp 003: Database And Desktop Publishing Question Paper

More Question Papers

Popular Exams