In MS Access, to add a calculated field in a query, you: MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, to add a calculated field in a query, you:

A. Use the Append query

B. Type an expression in a blank column of the query design grid

C. Use the Expression Builder in the Field row

D. Both A and B

Answer: Option D

Solution (By JKSSB Mock Tests)

You can type directly or use Expression Builder.

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

In Excel, what does the 'IF' function do?

A. Counts cells based on a condition

B. Tests a condition and returns one value if true, another if false

C. Sums cells based on a condition

D. Looks up a value in a table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The IF function evaluates a logical test and returns one value for true and another for false. COUNTIF, SUMIF are conditional counting/summing, VLOOKUP is lookup.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, to set a field as the primary key, use:

A. Create tab -> Primary Key

B. Table Design view -> select field -> Primary Key button

C. Database Tools -> Relationships

D. Datasheet view -> right-click -> Primary Key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Primary Key is set in Design view.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, which of the following is the correct syntax for SUMIF?

A. SUMIF(criteria, sum_range)

B. SUMIF(range, sum_range, criteria)

C. SUMIF(criteria, range, sum_range)

D. SUMIF(range, criteria, [sum_range])

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
SUMIF(range, criteria, [sum_range]) is correct.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs