(a) Create a; (i) database and save as WASSCE in the folder on the desktop. (i) table with headings as shown in Table 2 (11 rows). Define the fields appropr...

Question 1 Report


(a) Create a;

(i) database and save as WASSCE in the folder on the desktop.
(i) table with headings as shown in Table 2 (11 rows).
   

    Define the fields appropriately. Save the table as the customers.

    Set CustomlD as primary key

Custom ID first name  last name  telephone address
         
         

 

[iii] form from the customers and save as REFORM

 [b] Enter ten records of your choice using the
Form created in (a)(ii).
(c) Write a query to retrieve the First Name and Telephone.
(d) Design a report using (c).
(e) Insert a footer and type in your full name