The Environmental Policy Group Is Collecting Data on Weather Conditions

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