In MS Access, the expression to calculate current date plus 30 days in a query is: MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, the expression to calculate current date plus 30 days in a query is:

A. Today() + 30

B. Date() + 30

C. CurrentDate() + 30

D. Now() + 30

Answer: Option B

Solution (By JKSSB Mock Tests)

Date() returns current date. Adding 30 gives date 30 days ahead.

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

What is the shortcut key to add a border to selected text in MS Word?

A. Ctrl + B

B. There is no direct shortcut

C. Alt + B

D. Ctrl + Shift + B

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
There is no single shortcut to add a border; you must use the Borders button on the Home tab.

This question belongs to: Computer Microsoft Office

Question #2

What will be the result of the MS Excel formula =COUNTA(A1:A4) if cell A1=10, A2="Text", A3=EMPTY, and A4=0?

A. 3

B. 1

C. 2

D. 4

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The COUNTA function counts any non-empty cells within a range. Out of four cells, three are occupied (10, "Text", 0) and one is blank, yielding 3.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, what does the function =ROW() return in cell C5?

A. Error

B. 3

C. 5

D. C5

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
ROW() without argument returns the row number of the cell containing the formula.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs