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:

Variable Overhead Rate Variance

The difference between the actual variable overhead incurred and the expected (or budgeted) variable overhead based on a standard rate.

Labor Efficiency Variance

measures the difference between the actual labor hours used and the standard labor hours expected for the production achieved, indicating labor efficiency.

Labor Efficiency Variance

A measure of the difference between the actual number of labor hours used and the standard number of labor hours expected to produce a certain level of output.

Materials Quantity Variance

The financial difference between the actual quantity of materials used in production and the standard expected quantity.