How can you display sales grouped by country, region, and salesperson, all at the same time?
Answer: B) Use the Pivot table view command
In Microsoft Access, PivotTable View allows you to organize and summarize data by multiple fields simultaneously.
For example, sales data can be grouped by:
Country
Region
Salesperson
This makes it easier to compare sales performance across different geographical areas and salespeople.
Sort Descending only sorts data in descending order, while Find searches for specific values. Neither provides multi-level grouping.
Microsoft Access मा PivotTable View को प्रयोग गरेर Data लाई एकैपटक धेरै Fields का आधारमा Group तथा Summarize गर्न सकिन्छ।
उदाहरणका लागि, Sales Data लाई निम्न आधारमा एकैपटक Group गर्न सकिन्छ:
Country (देश)
Region (क्षेत्र)
Salesperson (बिक्री प्रतिनिधि)
यसले विभिन्न देश, क्षेत्र र बिक्री प्रतिनिधिअनुसार बिक्रीको विवरण तुलना गर्न सजिलो बनाउँछ।
Exam Tip: Multiple Fields मा Data Grouping = PivotTable View.
त्यसैले सही उत्तर B. Use the Pivot Table View command हो।