In MS Access, which object is used to extract specific data from one or more tables based on criteria? MCQ with Answer and Explanation

In MS Access, which object is used to extract specific data from one or more tables based on criteria?
A. Report
B. Macro
C. Query
D. Form
Answer: Option C
Solution (By JKExamLibrary)
A query retrieves and filters data. Forms are for data entry, reports for formatted output, macros automate tasks.

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 remainder after division?
A. MOD()
B. QUOTIENT()
C. INT()
D. ROUND()

Correct Answer: Option A


Explanation:
MOD(number, divisor) returns remainder. QUOTIENT returns integer portion of division, INT rounds down, ROUND rounds to digits.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In MS Word, which of the following is used to create a cross-reference to a numbered item?
A. Hyperlink
B. Footnote
C. Cross-reference
D. Bookmark

Correct Answer: Option C


Explanation:
Cross-reference can refer to numbered items, headings, figures, etc. Hyperlink is for web links, Bookmark marks a location, Footnote adds a note.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In Excel, what does the 'PMT' function calculate?
A. The future value of an annuity
B. The present value of an investment
C. The interest rate of a loan
D. The payment for a loan based on constant payments and interest rate

Correct Answer: Option D


Explanation:
PMT computes the periodic payment for a loan or annuity with constant payments and a fixed interest rate. PV calculates present value, FV future value, RATE calculates interest rate.

This question belongs to: Computer Microsoft Office