See 2023 Essay and Objectives answers

The database tool that allows the user to select and filter data from multiple tables is referred to as

  • A. Form
  • B. Table
  • C. Query
  • D. Report
Correct Answer: Option C

A query in a database is a request for information from a database management system (DBMS), which is the software program that maintains data. Users can make a query to retrieve data or change information in a database, such as adding or removing data.

2 . The following statements are steps used in creating a new workbook in a Microsoft Excel application.
I. Click on New
II. Click on the Microsoft Office button
III. Choose blank document Which of the following arrangements shows the correct order of operation from the steps above?

  • A. I, II and III
  • B. II, I and III
  • C. II, III and I
  • D. III, II and I
Correct Answer: Option B

The steps used in creating a new workbook in a Microsoft Excel application
– Click on the Microsoft Office button
– Click on New
– Choose blank document

Shared-memory is an architecture in

  • A. Parallel database
  • B. Trusted distributed database
  • C. Relational database
  • D. Distributed database
Correct Answer: Option A

Shared-memory is the architectural model adopted by recent servers based on symmetric multiprocessors (SMP). It has been used by several parallel database system prototypes and products as it makes DBMS porting easy, using both inter-query and intra-query parallelism.

One example of web design package is

  • A. MS frontpage
  • B. MS outlook
  • C. SPSS
  • D. Peachtree
Correct Answer: Option A

Other examples of web design package
– Adobe Dreamweaver.
– Google web designers.
– Microsoft SharePoint designer.
– Net Objects fusion.

Preventive maintenance measures in computer room do not include

  • A. The use of tiles
  • B. The use of rugs
  • C. Good ventilation
  • D. Proper illumination
Correct Answer: Option B

Use of rugs is not a preventive maintenance measures

Corrective maintenance of software refers to

  • A. Enhancement aimed at making the product faster
  • B. Deploying the software to a different hardware platform
  • C. Modifications initiated due to defects in software
  • D. Making the software easier to understand
Correct Answer: Option C

Corrective maintenance is concerned with fixing errors that are observed when the software is in use

Information Transmission can be referred to as the process of sending out processed data from one person or place to another in a meaningful form through a communication medium.

The Internet is a globally-connected network of computers that enables people to share information and communicate with each other. While an intranet, is a local or restricted network that enables people to store, organize, and share information within an organization.

A LAN, abbreviated from Local Area Network, is a network that covers a small geographical area such as homes, offices, and groups of buildings. While a WAN, abbreviated from Wide Area Network, is a network that covers larger geographical areas that can span the globe.

(i) Hub
(ii) Switch
(iii) Router
(iv) Bridge

A database refers to a collection of logically related information organized so that it can be easily accessible, managed, and updated.


(i) MySQL
(ii) PostgreSQLO
(iii) Microsoft SQL Server
(iv) Oracle

(i) Painting
(ii) Drawing

(i) MS Paint
(ii) PC Paintbrush
(iii) Adobe Photoshop
(iv) CorelDraw

A presentation package is a software program that contains a text editor and the ability to add charts and graphic images, such as photographs, clip art, or other objects so as to make a slide show for the purpose of communicating visually to an audience.


(i) Microsoft PowerPoint.
(ii) Macromedia flash.
(iii) Windows movie maker
(iv) Open office


(i) Presentation packages contain slides.
(ii) Presentation packages allow users to insert pictures and objects into their presentation from external sources.
(iii) Presentation packages allow users to insert video and audio into their presentation from external sources.
(iv) Creation of Graphics
(v) Creating organizational and other types of chart

– Click the Find & Select button on the Home tab.
– Select Replace. Press Ctrl + H
– Type the text you want to replace in the Find what box.
– Type the replacement text in the Replace with box.
– Click the Find Next button. The first instance is selected.
– Click Close when you’re finished

No 5 (a)

(i) Click the Microsoft office button

(ii) Click on Microsoft Access

(iii) Click new

(iv) Click the new blank database icon

(v) Type in the name “student_ Record”

(vi) Click create


(i) Click the table design button from the create tab

(ii) A blank table appears. Enter each Field

(iii) Enter the name for each field eg  ID Number, Full name, Data of Birth, Age and Home address

(v) Enter the field properties using the button panel of each field

(vi) Click save


ID_Number ==> Number data type

Full Name ==> Short text data type

Date of Birth ==> Data/Time data type

Home Address ==> Long text data type


ID_Number Field


It serves as a unique identifier for a row of data in a database table.


(i)Open a blank word document

(ii) On the top, click on insert

(iii) Click the table button

(iv) Click on “insert table”

(v) Go to number of columns band enter 4

(vi) Go to number of rows and enter 6

(vii) Click ok


(i) Select the text you want to use as a hyperlink

(ii) Click the insert tab

(iii) Click on hyperlink

Join Discussion on Telegram