Data Processing 2016 Waec Past Questions and Answers

Question 46 :

• WAEC 2016

(a) Folders are used for storing files in the computer. List the steps for carrying out the following operations; (i) creating a folder on the desktop (ii) giving name on the folder (iii) sending a file from "My Documents" folder into the folder created in 6 (a)(i), (iv) Changing the name of the folder in 6(a)(ii) to "RESULTS".
(b) The table below shows selected fields and Data Types in MS Access. Use it to answer questions 6(b)(i) and 6(b)(ii)

Field	Data Types
Full Name	Text
Mat No.	Text
Date of Birth	*
Fees	*
Address	Memo

(i) What is the appropriate data type for; (I) Date of Birth (II) Fees Fields
(ii) If MS Access is running, describe the procedure to; I. Create a table with the fields as given above using design view II. Set the Mat. No. Field as the primary key. III. Set the Full Name Fieldto a maximum of 50 characters.