Question: Problem 1 . At the registration area of the 2 0 2 3 BCT Meeting, a large convention of building contractors, organizers ask convention participants

Problem 1. At the registration area of the 2023 BCT Meeting, a large convention of building contractors, organizers ask convention participants about their name and years of experience in the industry. The convention manager would like to have a computer program to classify people according to their experience. You are required to design a friendly user form with the following features:
A text box to input the name of a person attending the convention.
A text box to input the registration number of the person (a numeric code with at least four digits, but no more than 12 digits).
A spin button ranging from 0 to 50 for the years of experience, default is 0.
A button entitled "Classify".
Place a button on the sheet containing the data to open the application (remember not to place this button so that it will obstruct the view of the dataset).
The program must check that the registration number is correct, that is, it has at least four numeric digits, but no more than 12 numeric digits), if the code is incorrect, then the program must display an error message on a message box (Hint: use the IsNumeric function). When the user presses the "Classify" button, and if the code is correct, the program will classify the person by placing the name and registration number in the corresponding column of the sheet as illustrated in Figure 1. The input in the cell must have the format Kof the sheet, corresponding to people with 10 years of experience. If a person has 20or more years of experience, heshe should be placed in the last column (columnU). Notice that the columns may have different number of entries, so that you need to keep separate counters for each column.
 Problem 1. At the registration area of the 2023 BCT Meeting,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!