Question 3
- Database and save as WASSCE in the folder on the desktop.
- Table with headings as shown in table 2 (11 rows). Define the fields appropriately. Save the table as tblcustomers. Set custom ID as primary key.
- Form from tblcustomers and save as RFORM.
(a) Create a:
Table2
CustomID |
FirstName |
LastName |
Telephone |
Address |
|
|
|
|
|
|
|
|
|
|
(b) Enter ten records of your choice using the First Name and Telephone.
(c) Write a query to retrieve the First Name and telephone
(d) Design a report using 3(c).
(e) Insert a footer and type in your full name and index number.
(f) Print the report and submit to the supervisor.
Observation
The expected answer is:
The question tested the ability of the candidates on the use of Microsoft Access application in creating database. The Chief Examiner reported that the candidates who attempted the question showed poor skill on the use of the application.