Case-Based Critical Thinking Questions
Case 11-2 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

Case-Based Critical Thinking Questions
Case 11-2 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 trigger actions after data in a field has been changed and saved, making it suitable for changing the case of city names after they are entered or modified.