In MS Access, which object stores data in a structured format of rows and columns? MCQ with Answer and Explanation

Question Report Error

In MS Access, which object stores data in a structured format of rows and columns?

A. Form

B. Report

C. Query

D. Table

Answer: Option D

Solution (By JKExamLibrary)

Tables hold the raw data. Queries extract data, forms display it, reports present it.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error

In Excel, which function returns the serial number of a specific date given year, month, day?

A. DATEVALUE()

B. TODAY()

C. NOW()

D. DATE()

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
DATE(year, month, day) constructs a date.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

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

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

B. Deletes records based on criteria

C. Prompts for input

D. Creates a new table

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
Crosstab query cross-tabulates data.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In MS Excel, what occurs if you double-click on the boundary line dividing two column header letters?

A. A new empty column gets inserted between them

B. The column is automatically hidden from view

C. The column auto-fits its width to match its longest data entry string

D. The columns are combined together

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Double-clicking a column boundary line triggers the AutoFit feature, adjusting the column width to fit its longest content entry perfectly.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs