Question 6
(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 to 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”.
The table below shows selected fields and DataTypes in MS Access. Use it to answer questions 6 (b) (i)and 6 (b) (ii).
Field |
DataTypes |
FulName |
Text |
Mat.No |
Text |
Date of Birth |
* |
Fees |
* |
Address |
Memo |
(i) What is the appropriate data type for:
I. Date of Birth Field;
II.Fees Field?
(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 FullName Field to a maximum of 50 characters.
Observation
The expected answers were:
(a) (i) To Create a folder on the desktop
-Right-click on the desktop and select “New”
-Select “Folder”
(ii) Naming the folder
-Click on the default name of the new folder
-Type-in the name, Press enter or click elsewhere on the desktop
OR
Right-click on the folder icon and select “Rename”
-Type-in the New Name
OR
Select the folder, Click on the Default Name/New Folder,
Type New Name, Press Enter.
(iii) Sending a file to the new folder
-Double-click on “My Documents” folder icon
-Right-click on the desired file icon and select “copy”
-Open the folder created
-Paste the copied file
OR
Select the file in My Documents Folder,
Drag it to the created Folder on the Desktop,
Drop/Release the Mouse button
OR
Open the File in My Document,
Click on File, Save As,
Select Desktop, Select Target Folder,
Click on Save.
(iv) Renaming the folder
-Right-click on the folder icon and select “Rename”
-Type-in the new name “RESULTS”
OR
Select the folder, Click on the Default Name/New Folder,
Type “RESULTS” as the New Name, Press Enter.
(b) (i) (I) Date of Birth---Date/Time
(II) Fees-------------Currency
(ii) (I) –create a blank database and give it a name
-click on the “create” tab on the menu bar and select “table design/design
view”
-Type the field names and set the data types as required. Save the file
(II) –select the Mat.No field
-Right-click on the field and select primary key
OR
-Select the Mat.No field
-click on the primary key icon on the menu bar
(III) -click on the FullName field
-set the field size to 50
OR
Click on the FullName Field, Go to the Field Properties,
Change the Field Size from 255 to 50
Candidates’ responses showed fair knowledge in file management but there was lack of practical skills in database.