Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 come 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: 1. A text box to input the name of a pers attending the convention. 2. 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).3. A spin button ranging from 0 to 50 for the years of exper default is 0-4. A button entitied "Classity". 5. 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 dalaset). The progam 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 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 columin o sheet as illustrated in Figure 1. The input in the cell must have the format . For example, Erik Neud (reg. no.1191), Charies Bo (reg. no.6591), and Daniel Mok (reg. no.2947) have 10 years of experience each, they should be placed in column
K
of the sheet, corresponding to people with 10 years of experience. If a person has 20 or more years of experience, he/she should be placed in the last column (column. U). Notice that the columns may have diftere number of entries, so that you need to keep separate counters for each column.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

2. Identify the employees who are included in the plan.

Answered: 1 week ago

Question

7. Discuss the implications of a skill-based pay plan for training.

Answered: 1 week ago