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:

Walsh-Healy Public Contracts Act

A law that requires minimum wage, overtime pay, and safety and health standards for workers on federal contracts.

Prevailing Local Wage Rates

The average wage paid to workers in a specific area or industry, often used as a benchmark for setting wages.

General Contractors

Companies or individuals tasked with the overall responsibility for the execution, supervision, and completion of construction projects, managing subcontractors and materials.

Fair Labor Standards Act

A federal law in the United States that establishes minimum wage, overtime pay eligibility, recordkeeping, and child labor standards for full-time and part-time workers.