(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
Answer Details
This question is asking you to create a database with a table called "customers" and define the fields appropriately with the "Custom ID" as the primary key. Then, you need to create a form from the "customers" table and save it as "REFORM". After that, you will enter ten records of your choice using the form. Next, you will write a query to retrieve the "First Name" and "Telephone" fields from the "customers" table. You will then use the retrieved data to design a report. Finally, you will insert a footer into the report and type in your full name.
In summary, this question is testing your knowledge of database creation, table design, form creation, query writing, report designing, and footer insertion. It is important to pay attention to the details and follow the instructions carefully to successfully complete this task.
Download The App On Google Playstore
Everything you need to excel in your exams
