You are to create a project for a census bureau to obtain and analyze household income survey data within the Cincinnati area (including Northern Ky).

Data Collected:

• Home identification code (4 alphanumeric characters) - required

o User can enter code by hand (must include input validation) *OR*

Use a random number generator to create each character in the code. Hint: use special number generator that will index into a character array to generate random letters.

• Date of the survey - required (try using the datetime picker control), must be a valid date

• County and State (1 input only) they reside in - required

o Hamilton, Oh

o Butler, Oh

o Clermont, Oh

o Warren, Oh

o Campbell, Ky

o Boone, Ky

o Kenton, Ky

• The household yearly income - required, must be numeric, must be greater than 0.

Events:

There should be 4 buttons on the screen:

1. Submit: This event will validate all data and save the data to the necessary arrays for processing.

2. Exit: This event will exit the application

3. Total Households Surveyed: This event will process the arrays and display the total households surveyed by state and then by county in a Message box (see below for example).

4. Average Household Income: This event will process the arrays and display the average household income by state and then by county in a Message box (see below for example).

Instructions:

1) Create a well designed modular program based on design techniques taught.

2) Use good naming conventions on all objects, variables, procedures, functions, etc.

3) Make sure all functions and procedures are called "down". Meaning a top-down modular approach.

4) Option Strict and Option Explicit must be on

5) All survey information must be saved to an array(s).

6) When the user clicks the button "Total Households Surveyed", do the necessary calculations and display in a Message box the Total Households Surveyed by county for all that were surveyed (see below for example).

7) When the user clicks the button "Average Household Income", do the necessary calculations and display in a Message box the Average Household Income by county for all that were surveyed (see below for example).

Average Household Income

Ohio: $30,000

Hamilton: $40,000

Butler: $20,000

Clermont: $30,000

Warren: $30,000

Kentucky: $35,000

Boone: $40,000

Campbell: $30,000

Kenton: $35,000

Total Households Surveyed

Ohio: 12

Hamilton: 4

Butler: 3

Clermont: 1

Warren: 4

Kentucky: 7

Boone: 2

Campbell: 3

Kenton: 2.