In Access, which of the following is used to create a calculated field in a query? MCQ with Answer and Explanation

In Access, which of the following is used to create a calculated field in a query?
A. Both A and B
B. Field row with a calculated expression
C. Design View only
D. Expression Builder
Answer: Option A
Solution (By JKSSB Mock Tests)
You can create calculated fields by typing an expression in the Field row of the query design grid, or using the Expression Builder. Both are valid.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS PowerPoint, which tool allows an author to capture formatting configurations, borders, and effects from an image and apply those same properties to another image asset?
A. Design Master
B. Format Painter
C. Animation Painter
D. Theme Styles manager

Correct Answer: Option B


Explanation:
The Format Painter tool copies visual style formatting (such as borders, shadows, and fills) from a selected object and applies it to another asset with a single click.

This question belongs to: Computer Microsoft Office
Question #2
Which Access data type is used to store monetary values and prevents rounding errors?
A. Currency
B. AutoNumber
C. Decimal
D. Number

Correct Answer: Option A


Explanation:
Currency has fixed decimal places and avoids rounding errors. Number can also store money but may have rounding.

This question belongs to: Computer Microsoft Office
Question #3
In Excel, the function =COLUMN() in cell D5 returns:
A. Error
B. D
C. 4
D. 5

Correct Answer: Option C


Explanation:
Column D is 4th column.

This question belongs to: Computer Microsoft Office