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. Both A and B

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

C. Use the Expression Builder in the Field row

D. Use the Append query

Answer: Option A

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

The shortcut to insert a trademark symbol (™) in MS Word is:

A. Alt + 0153

B. Ctrl + Shift + T

C. Ctrl + Alt + T

D. Both A and B

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+Alt+T inserts TM symbol. Alt code 0153 also works.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, a 'Query' can be used to:

A. Create forms

B. Create relationships

C. Add, delete, or update data in tables

D. Generate reports

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Queries can be action queries that add, delete, update, or append data. Forms are created separately, reports separately, and relationships are defined in the Relationships window.

This question belongs to: Computer Microsoft Office

Question #3

Which of the following database tools in MS Access provides a user-friendly layout or digital form explicitly designed to view, input, or navigate individual data records?

A. Report

B. Macro routine

C. Query matrix

D. Form

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Forms serve as user interface layouts that simplify data entry, record modification, and database navigation tasks for end-users.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs