(a) Define information transmission
(bi) Differentiate between internet and intranet
(ii) Differentiate between LAN and WAN
(c) List four devices used in a LAN environment

(ai) A medium-scale enterprise intends to create a database to manage its staff records with the following fields: staff ID, Name, Address, Photograph and Department.
what is database?
(aii) A medium-scale enterprise intends to create a database to manage its staff records with the following fields: staff ID, Name, Address, Photograph and Department.List three DBMS the firm can use to achieve the stated objectives
(bi) A medium-scale enterprise intends to create a database to manage its staff records with the following fields: staff ID, Name, Address, Photograph and Department
Mention two tasks that can be performed on staff photographs using graphic packages
(bii) A medium-scale enterprise intends to create a database to manage its staff records with the following fields: staff ID, Name, Address, Photograph and Department.
Give three examples of graphic packages that can be used for the tasks above

(ai) What is a presentation package?
(aii) Give two examples of presentation package
(aiii) State three features of a presentation package
(b) Highlight the steps followed to find and replace data in MS Excel

(a) A professional photographer uses analogue cameras and a computer system for his business. The computer is used to prepare documents and keep records of clients' account. Copies of these documents are stored in CD-ROMs and Floppy disks. The photographer now plans to innovate by using digital cameras and the computer for taking, editing and printing photographs.

State two hardware changes required on the photographer's computer to achieve the planned innovation

(bi) A professional photographer uses analogue cameras and a computer system for his business. The computer is used to prepare documents and keep records of clients' account. Copies of these documents are stored in CD-ROMs and Floppy disks. The photographer now plans to innovate by using digital cameras and the computer for taking, editing and printing photographs.

Give one reason:
for each of the changes above

(bii) A professional photographer uses analogue cameras and a computer system for his business. The computer is used to prepare documents and keep records of clients' account. Copies of these documents are stored in CD-ROMs and Floppy disks. The photographer now plans to innovate by using digital cameras and the computer for taking, editing and printing photographs.

why the photographer should use an external hard disk instead of a floppy disk to store data

(c) State two advantages of switching from analogue to digital camera

(a) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five colunms/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address

Highlight the procedures the captain will follow to create the database

(b) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five colunms/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address

List the steps the captain would take to create the table in Design View

(c) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five colunms/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address

Give the data type suitable for each column/field provided

(d) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five colunms/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address

Which field can be used as the primary key?

(e) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five colunms/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address

Mention one importance of primary keys

(f) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five columns/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address

List three SQL command statements the class captain can perform on the database

(g) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five colunms/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address

Give the SQL query the captain will use to display all the columns in table Students