Scribd
Upload
4 views2 pages

f2 Computer Assignment

The document outlines a holiday assignment for Form 2 Computer Studies at Merishaw School, focusing on databases using MS Access and desktop publishing with MS Publisher. It includes various questions and tasks related to database definitions, features, advantages, and operations, as well as desktop publishing concepts and software. Students are required to demonstrate their understanding of database management systems and desktop publishing techniques through definitions, comparisons, and explanations.

Uploaded by

mylxxss
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views2 pages

f2 Computer Assignment

The document outlines a holiday assignment for Form 2 Computer Studies at Merishaw School, focusing on databases using MS Access and desktop publishing with MS Publisher. It includes various questions and tasks related to database definitions, features, advantages, and operations, as well as desktop publishing concepts and software. Students are required to demonstrate their understanding of database management systems and desktop publishing techniques through definitions, comparisons, and explanations.

Uploaded by

mylxxss
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

MERISHAW SCHOOL

NOVEMBER/DECEMBER HOLIDAY ASSIGNMENT


COMPUTER STUDIES
FORM 2

DATABASES – MS ACCESS

1. (a) Define a Database, and give two examples of database programs in use today. (2 marks)
(b) List any two database objects. (2 marks)
2. List five features found in an electronic database management system. (5 marks)
3. State three advantages of an electronic database over the traditional file management system.
(3 marks)
4. (a) Distinguish between the following terms in relation to a database: (6 marks)
i) Field type and field properties.
ii) Records and Fields.
iii) AND and OR operators.
(b). Explain three types of database models. (3 marks)
5. (a) Distinguish between Flat file and Relational databases. (2 marks)
(b) State three operations that can be performed on a relational database files. (3 marks)
6. Identify five functions of a Database management system. (5 marks)
7. Explain the importance of using Database management system in organizations. (2 marks)
8. State the components of a Database hierarchy in ascending order. (2 marks)
9. State the use of the following objects in Databases.
i) Tables (1 mark)
ii) Forms (1 mark)
iii) Query (1 mark)
iv) Macros (1 mark)
v) Reports (1 mark)
10. Name two different types of tools one can use to search for data in a database. (1 mark)
11. (a) Differentiate between: (14 marks)
i) Primary key and Relationship.
ii) Tabular and Columnar form layout.
iii) Database file and Database table.
iv) Primary key and Index.
v) Field name and Caption.
vi) Table and Query.
vii) Bound and unbound control.
(b) What is the importance of the Primary key? (1 mark)
(c) State three types of relationships that can be used to link tables in Databases.
(3 marks)
12. (a). Describe four major shortcomings of the conventional (paper) file structures that are
being addressed by the database approach. (4 marks)
(b). List any two methods used to secure data in a database. (2 marks)

23
13. A student’s database comprises of students’ details table and fees
received table as shown below:
Students’ details table Fees Received table
Surname
Middle Name Date
First Name Amount
Admission Number Receipt Number
Course

(i) State the primary key field for each table.(2 marks)
(ii) State the field which should serve as the linking field for the two
tables.(2 marks)

DESKTOP PUBLISHING (DTP) – MS PUBLISHER

1. (a) What is Desktop publishing? (2


marks)
(b) Give three examples of desktop publishing software available in the market
today.
(3 marks)
(c) State five features in desktop publishing. (5
marks)

2. Identify four common features in word processing and desktop publishing


software.
(4 marks)
3. List four areas of DTP application. (2 marks)
4. Differentiate between the following:
(a) Pasteboard and Printable page.(2 marks)
(b) Margins and Column guides.(2 marks)
(c) Change case and drop cap.(2 marks)
(d) Kerning and tracking.(2 marks)
(e) Fill and line stroke.(2 marks)
5. Explain the following as used in DTP: (3 marks)
(a) Master pages.
(b) Layering.
(c) Placeholders / selection handles.

You might also like