(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
Explanation
| REFORM | |
| CUSTOM ID | 1 |
| first name | Racheal |
| last name | Adeyemi |
| Telephone | 08065487942 |
| address | 1,iju road |
| CUSTOM ID | 2 |
| first name | joy |
| last name | oku |
| telephone | 08055565559 |
| address | 10,ajangbadi close |
| Custom ID | 3 |
| first name | chibuzor |
| last name | racheal |
| telephone | 07066669899 |
| address | 32,fatai alinco way |
| Custom ID | 4 |
| first name | samad |
| last name | malim |
| telephone | 08059888889 |
| address | victoria island |
| CUSTOM ID | 5 |
| first name | kate |
| last name | peace |
| telephone | 09055445668 |
| address | 5,magodo estate |
| CUSTOM ID | 6 |
| first name | halima |
| last name | abubakar |
| telephone | 08165663228 |
| address | 13,obawole street |
| CUSTOM ID | 7 |
| first name | philip |
| last name | peace |
| telephone | 08012223221 |
| address | 76,Ifako ijaiye |
| CUSTOM ID | 8 |
| first name | philip |
| last name | peace |
| telephone | 08012223221 |
| address | 76, agbado ijaiye |
| CUSTOM ID | 9 |
| first name | zainab |
| last name | effiong |
| telephone | 081444499999 |
| address | 23,alimosho |
| CUSTOM ID | 10 |
| first name | chisom |
| last name | emmanuel |
| telephone | 07055555595 |
| address | 24, ifako agege |
| first name | telephone |
| racheal | 08065487942 |
| joy | 08055565559 |
| chibuzor | 07066666689 |
| samad | 08059888889 |
| kate | 09055445668 |
| halima | 08165663228 |
| philip | 080122222321 |
| stephen | 081444999999 |
| zainab | 070987223333 |
| chisom | 070555555559 |
| custom id | first name | last name | telephone | address |
| 1 | racheal | adeyemi | 08065487942 | 1, iju road |
| 2 | joy | oku | 08055565559 | 10, ajangbadi close |
| 3 | chiibuzor | racheal | 07066666689 | 32,fatai alinco way |
| 4 | samad | malim | 08059888889 | victoria island |
| 5 | kate | peace | 09055445668 | 5, magodo estate |
| 6 | halima | abubakar | 08165663228 | 13,obawole street |
| 7 | philip | peace | 08012222232 | 76,agbado ijaye |
| 8 | stephen | effiong | 08144499999 | 23,alimosho |
| 9 | zainab | ajayi | 07098722333 | 26, aim saliu |
| 10 | chisom | emmanuel | 07055555555 | 24, ifako agege |