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.
-Louisa wants to be sure that all city locations are recorded in proper case in the database.To do this,she needs to use the ____ event procedure which will automatically change the data entered in the City field to proper case any time a value is entered or changed in the field.For instance,if the user enters san antonio in the City field,the procedure will change the data to San Antonio and store it in the database.
A)OnChange
B)OnEnter
C)AfterUpdate
D)BeforeUpdate

Question

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.
-Louisa wants to be sure that all city locations are recorded in proper case in the database.To do this,she needs to use the ____ event procedure which will automatically change the data entered in the City field to proper case any time a value is entered or changed in the field.For instance,if the user enters san antonio in the City field,the procedure will change the data to San Antonio and store it in the database.
A)OnChange
B)OnEnter
C)AfterUpdate
D)BeforeUpdate

Quizplus · Accepted Answer

The AfterUpdate event procedure is used to update data in a field after the user has entered it. Louisa can write a code in this procedure to ensure that all data entered in the City field is recorded in proper case. This will automatically change the data every time a value is entered or updated in the City field. The other options, OnChange, OnEnter, and BeforeUpdate, are not suitable for this task. OnChange only triggers when a value in a field changes, but not necessarily when it is entered. OnEnter triggers when the user enters the field, but not when a value is changed. BeforeUpdate triggers before a change is made, so it cannot be used to change the value.

The Environmental Policy Group Is Collecting Data on Weather Conditions