If you are creating a cross tab query, what must table you are querying contain?
Tap an option to check yourself.
Answer: C) At least one field
A Crosstab Query in Microsoft Access summarizes data by grouping values from one or more fields and displaying the results in a spreadsheet-like format.
The source table must contain at least one field. It does not need to contain more than 100 records or confusing information.
Microsoft Access मा Crosstab Query ले Table मा रहेको Data लाई विभिन्न Fields का आधारमा Group गरेर Spreadsheet जस्तै Row र Column मा सारांशका रूपमा देखाउँछ।
यसका लागि Source Table मा कम्तीमा एउटा Field हुनुपर्छ। १०० भन्दा बढी Records हुनुपर्ने वा Confusing Information हुनुपर्ने कुनै अनिवार्यता छैन।
Exam Tip: Crosstab Query ले Data लाई Row र Column मा व्यवस्थित गरी Summary प्रस्तुत गर्छ।