Sheng Has Been Asked to Provide Data from the Inventory

question 55

Multiple Choice

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

---

Definitions:

CPI

Consumer Price Index, a measure that examines the weighted average of prices of a basket of consumer goods and services.

Market Basket

A fixed list of items used to track the progress of inflation in an economy.

CPI

A gauge for inflation, the Consumer Price Index analyzes the weighted average price of a collection of consumer products and services.

GDP Deflator

An index that measures the prices of all new, domestically manufactured, final goods and services in a country's economy.