In MS Access, what does a 'Crosstab query' do? MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, what does a 'Crosstab query' do?

A. Creates a new table

B. Prompts for input

C. Aggregates data and displays it with row and column headings (like a pivot)

D. Deletes records based on criteria

Answer: Option C

Solution (By JKSSB Mock Tests)

Crosstab query cross-tabulates data.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1

Share Report

What is the shortcut to open the 'Replace' dialog in MS Excel?

A. F5

B. Ctrl + H

C. Ctrl + F

D. Ctrl + R

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+H for Replace.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Access, the 'Report Wizard' allows you to:

A. Write SQL for a report

B. Design a table

C. Create a report quickly by selecting fields, grouping, and layout

D. Create macros for reporting

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Report Wizard steps through report creation.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Access, what is the function of the 'Lookup Wizard'?

A. Creates a field that provides a dropdown list of values

B. Searches for records

C. Imports data

D. Creates relationships

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Lookup Wizard creates a lookup field.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs