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

Pcmp 003: Computer Applications Ii (Ms- Access, Ms Publisher) Question Paper

Pcmp 003: Computer Applications Ii (Ms- Access, Ms Publisher)

Course:Certificate In Computer Literacy

Institution: Chuka University question papers

Exam Year:2013

CHUKA

UNIVERSITY

UNIVERSITY EXAMINATIONS

EXAMINATION FOR THE AWARD OF CERTIFICATE IN COMPUTER LITERACY

PCMP 003: COMPUTER APPLICATIONS II (Ms- Access, Ms Publisher)

STREAM: CERT (COMP LITERACY) TIME: 2 HOURS

DAY/DATE: FRIDAY 2/8/2013 8.30 A.M – 10.30 A.M

INSTRUCTIONS:

Answer ALL questions

1. Define the term database. (2mks)

a. State three example of database management software. (3mks)

b. Good database design mean better storage, security and little maintenance effort. List four factors to consider in designing a good database. (4mks)

c. Write down the criteria you would use to display employees details from a payroll database who earn between 90,000 and 240,000. (2mks)
2.
a. Explain the procedure of starting Microsoft Access. (4mks)

b. Explain three features of database management software. (6mks)

3. Explain the following field properties: (8mks)

a. Field size
b. Default value
c. Validation rule
d. Validation text

4. Explain four data types allowed in Ms Access. (8mks)

5. State four weaknesses of the traditional data and information management that have been overcome by the electronic databases. (4mks)

6. Explain three database models (6mks)
7. Give any three examples of desktop publishing software available in the market today (3mks)
8. Identify four different types of publications that can be produced using desktop publishing software. (4mks)

9. State four advantage of DTPs over word processor (4mks)

10. Explain the procedure of creating a table structure. (5mks)

11. Mr.Njoroge owns a big groceries shop in Embu town. He wishes to develop a small database to manage his stock.

a. 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.

AdNo SurName FirstName Date of birth Tutor initials
200 JOHN KAMAU 19/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? (1 mk)

ii) How many fields does each record have? (1 mk)

iii) In all computer database systems there is a unique field. Which is the unique field in
this section of this file? (1 mk)

iv) Why is it important to have a unique field? (1 mk)
_____________________________________________________________________________

Pcmp 003: Computer Applications Ii (Ms- Access, Ms Publisher) Question Paper

More Question Papers

Popular Exams