ou are the newly appointed Records Manager of Transgenerational Thinkers International (GTI). After previewing the structure of the company you realized that it doesn’t have a proper database. Due to this hidden setback, the company always fails to meet its expected profit margin. Develop a comprehensive database to remedy this issue. The database should include; A. i) Customer table and ii) Customer registration form B. Fill the table with 30 records. C. The fields of the table should be the same as the forms. Footnotes: D. Your table should include the following fields as headings I) CustomerID ( eg. CID101, CID102, CID103…………….CID130) II) Surname III) OtherName IV) V) VI) VII) VIII) Gender ProductID (eg. P01, P02……………P30) ProductName Product Photo (just type in product image) Contact IX) Location X) Date of registration XI) Email XII) Customer photo ( just type in customer image) 3 E. Click on insert, select textbox to develop the form below, apply a fill colour for all the textboxes (eg. CustomerID) fill the form with a record. REGISTRATION FORM PERSONAL PROFILE Customer Photo CustomerID SurName Other names Gender PRODUCT DETAILS ADDRESS ProductID Contact ProductName Location Product Photo Date of registration Emai
You are the newly appointed Records Manager of Transgenerational Thinkers International (GTI).
After previewing the structure of the company you realized that it doesn’t have a proper database.
Due to this hidden setback, the company always fails to meet its expected profit margin.
Develop a comprehensive database to remedy this issue.
The database should include;
A. i) Customer table and
ii) Customer registration form
B. Fill the table with 30 records.
C. The fields of the table should be the same as the forms.
Footnotes:
D. Your table should include the following fields as headings
I) CustomerID ( eg. CID101, CID102, CID103…………….CID130)
| II) | Surname |
| III) | OtherName |
| IV) V) VI) VII) VIII) |
Gender ProductID (eg. P01, P02……………P30) ProductName Product Photo (just type in product image) Contact |
| IX) | Location |
| X) | Date of registration |
| XI) Email | |
| XII) | Customer photo ( just type in customer image) |
3
E. Click on insert, select textbox to develop the form below, apply a fill colour for all the textboxes (eg.
CustomerID) fill the form with a record.
REGISTRATION FORM
PERSONAL PROFILE Customer Photo
CustomerID
SurName
Other names
Gender
| PRODUCT DETAILS | ADDRESS |
| ProductID | Contact |
| ProductName | Location |
| Product Photo | Date of registration |
| Emai |
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images
