In MS Access, a 'query' object is used to: MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, a 'query' object is used to:

A. Automate repetitive tasks

B. Store data

C. Retrieve, filter, and perform calculations on data from tables

D. Print formatted output

Answer: Option C

Solution (By JKSSB Mock Tests)

Queries manipulate 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

In MS Access, which data type is used to store binary data such as sound or video?

A. Attachment

B. OLE Object

C. Hyperlink

D. Both A and B

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Both can store multimedia, but Attachment is preferred.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Access, what is the purpose of a 'Query'?

A. To create user interface forms

B. To retrieve and manipulate data from tables

C. To store data

D. To print reports

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Queries are used to retrieve, update, delete, or analyze data from tables based on specified criteria. They do not store data permanently (except make-table queries).

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Excel, which function returns the number of characters in a text string?

A. LENGTH

B. CHAR

C. TEXT

D. LEN

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The LEN function returns the number of characters in a text string. LENGTH is not a function, CHAR returns a character based on code, TEXT formats a value.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs