Case-Based Critical Thinking Questions
Case 12-1
Sheng has been asked to provide data from the Inventory database of a regional auto parts store to the store's regional manager. He has been given specific requirements to narrow the data based on the information the manager needs. Sheng will apply filters to the tables in the Inventory database to provide his manager with the requested information.
-The first set of data Sheng needs to provide is the names of all floor mat manufacturers who provide floor mats that fit a specific car model. Which type of filter should Sheng apply to the FloorMatCapatibility field that will allow the display of context-sensitive values for this single field?
A)Advanced Filter/Sort
B)Filter by Form
C)Filter by Selection
D)AutoFilter

Question

Case-Based Critical Thinking Questions
Case 12-1
Sheng has been asked to provide data from the Inventory database of a regional auto parts store to the store's regional manager. He has been given specific requirements to narrow the data based on the information the manager needs. Sheng will apply filters to the tables in the Inventory database to provide his manager with the requested information.
-The first set of data Sheng needs to provide is the names of all floor mat manufacturers who provide floor mats that fit a specific car model.  Which type of filter should Sheng apply to the FloorMatCapatibility field that will allow the display of context-sensitive values for this single field?
A)Advanced Filter/Sort
B)Filter by Form
C)Filter by Selection
D)AutoFilter

Quizplus · Accepted Answer

AutoFilter allows for context-sensitive values to be displayed for a single field. Advanced Filter/Sort applies filters to multiple fields, Filter by Form and Filter by Selection do not allow for context-sensitive values.