Case-Based Critical Thinking Questions
Case 10-1
Elaina is the database administrator for a women's fitness franchise. She has been asked to automate several of the database functions to make it easier for the front desk employees to provide information to clients. Elaina will create macros to automate the functions.
-In a different macro, Elaina would like to locate the first or next record that meets a specific set of criteria. Which Access action can be added to the macro that will meet her demand?
A)SelectObject
B)GoToControl
C)OpenForm
D)FindRecord

Question

Case-Based Critical Thinking Questions
Case 10-1
Elaina is the database administrator for a women's fitness franchise. She has been asked to automate several of the database functions to make it easier for the front desk employees to provide information to clients.  Elaina will create macros to automate the functions.
-In a different macro, Elaina would like to locate the first or next record that meets a specific set of criteria.  Which Access action can be added to the macro that will meet her demand?
A)SelectObject
B)GoToControl
C)OpenForm
D)FindRecord

Quizplus · Accepted Answer

The action that will allow Elaina to locate the first or next record that meets a specific set of criteria is FindRecord. This action will search for the first or next record that meets the specified criteria, based on the current position of the recordset. The other actions, SelectObject, GoToControl, and OpenForm, do not perform the specific task of finding a record based on criteria.