Dan Is Manipulating Data in a Table Containing Records on Computer

question 38

Multiple Choice

Dan is manipulating data in a table containing records on computer equipment purchases for the past year. Each record in the table contains the date purchased, the type of computer equipment, the vendor’s name, the cost of the equipment, and the department in which the equipment is installed. The records were originally entered in order by month of purchase. Dan sends you an e-mail asking how he can rearrange the table’s records to see all the purchases from each vendor in date order within each department. He also wants to know a quick way to get the data back into its original order, whenever necessary.
-To rearrange the data,you suggest that Dan create a custom sort by setting the ____.

• A) purchase date field as the major sort key,the vendor field as the intermediate sort key,and the department field as the minor sort key
• B) vendor field as the major sort key,the department field as the intermediate sort key,and the purchase date field as the minor sort key
• C) purchase date field as the major sort key,the department field as the intermediate sort key,and the vendor as the minor sort key
• D) department field as the major sort key,the vendor field as the intermediate sort key,and the purchase date field as the minor sort key

---

Definitions:

Antitrust Suits

Legal actions taken against companies or entities to break up monopolies or to prevent anti-competitive practices, aiming to promote fair competition for the benefit of consumers.

Ivan Boesky

A former American stock trader who became infamous in the 1980s for his role in a major insider trading scandal.

Greed Is Good

A phrase popularized by the film "Wall Street" (1987) to encapsulate the idea that unbridled financial self-interest and the pursuit of personal wealth are positive forces in society.

Wall Street Trader

An individual who buys and sells stocks or other financial instruments on Wall Street, the heart of the financial district in New York City.