Data Processing Past Questions and Answers

(a) Outline the steps involved in creating the Query By Example (QBE) in figure 1 assuming the table customer exist already.

Figure 1
(b) Write the steps to generate the SQL statement for the action in 4 (a).

(a) Itoro was tasked with the responsibility of producing the report of hi group project He is to submit both the soft and hard copies of the report to his form teacher. The soft copy must be submitted to the email; form teacher@school.edu.ng
(i) List two;
I. Applications required to carry out the task
II. Hardware required to carry out the task
(ii) Identify two conditions to be satisfied by Itoro to submit the electronic copy of the report.
(iii) On the first attemot to send the soft copy of the report, Itoro observed a "spinning wait cursor"/"spinning disc pointer" on the screen for a long time.
Identify three possible reasons for this observation.
(iv) State one output device that can be used to produce the hard copy report.
Figure 2 is an interface of an application software. Use the figure to answer question 5(b)

Figure 2
(b)(i) Name the type of application software represented in figure 2.
(ii) List three examples of the application in 5(b)(i)
(iii) Given that the application in figure 2 is running on a computer that has internet access, outline the steps to follow in creating an email address/account.

(a) Figure 3 is created using a Word processor. Use the figure to answer question 6(a)

Figure 3
(a)(i) What is the name given to the feature on the first character in the document in figure 3?
(ii) Highlight the step to;
I. Achieve the feature on the first character in 6(a)(i)
II. Obtain the two columns as shown in figure 3.
(b) Give two objects that can be placed on a document using the "insert menu" on MS Word application.
(c) Outline the steps to perform the following actions in CorelDraw application;
(i) inserting a circular shape
(ii) adding the caption "Happy Birthday"
(iiI) changing the colour of the caption to Red
(iv) fitting the caption around the circular object.

The MS PowerPoint feature which can be used to change the appearance of the entire presentation is the ____________

One example of web design package is ____________