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.
-Sheng's regional manager may ask for the same information again at a later date so Sheng would like to save one of his filters for use later. What is the best option for saving the filter?
A)save the filter as a datasheet
B)save the filter with the form
C)save the filter as a query
D)save the filter as a separate file

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.
-Sheng's regional manager may ask for the same information again at a later date so Sheng would like to save one of his filters for use later.  What is the best option for saving the filter?
A)save the filter as a datasheet
B)save the filter with the form
C)save the filter as a query
D)save the filter as a separate file

Quizplus · Accepted Answer

Saving the filter as a query is the best option as it allows for easy retrieval and modification of the filter criteria in the future. Saving as a datasheet or with a form would not provide the same level of flexibility, and saving as a separate file could result in difficulties with organization and file management.