The Environmental Policy Group Is Collecting Data on Weather Conditions

question 6

Multiple Choice

The Environmental Policy Group is collecting data on weather conditions throughout the southeast U.S.The database used for data collection is being used by field technicians throughout the region.  Louisa has been asked to update the database to reduce data entry mistakes.  Louisa will create some new procedures and update others in the database.
-Which code best represents the procedure Louisa has written to convert the City field values to proper case in the database?

• A)
• Private Sub EventProcedure_VB Constant
• ‘Convert City to proper case
• [Field] = VBA Function([Field], Event Procedure
• End Sub
• B)
• Private Sub Field_EventProcedure
• ‘Convert City to proper case
• [Field] = VBA Function([Field], VB Constant
• End Sub
• C)
• Private Sub Field_EventProcedure
• ‘Convert City to proper case
• [VB Constant] = VBA Function([Field], Field
• End Sub
• D)
• Private Sub VB Function_EventProcedure
• ‘Convert City to proper case
• [VBAFunction] = ([Field], VB Constant
• End Sub

---

Definitions:

Whistle-blowing

The act of exposing any kind of information or activity within an organization that is deemed illegal, unethical, or not correct by an employee or former employee.

Disclosing Wrongdoing

The act of revealing unethical, illegal, or harmful practices, often carried out within an organization, to someone in a position to take action.

Due Process

A legal principle ensuring fair treatment through the normal judicial system, especially as a citizen's entitlement.

Downsizing

The reduction of a company’s workforce to improve efficiency, cut costs, or align with organizational restructuring.