In MS Access, a 'Select query' retrieves data based on criteria and: MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, a 'Select query' retrieves data based on criteria and:

A. Updates records

B. Displays the results in a datasheet

C. Creates a new table

D. Deletes matching records

Answer: Option B

Solution (By JKSSB Mock Tests)

Select query shows a dynaset of records.

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 MS Access, to create a form that displays data from a query, use:

A. Table Analyzer

B. Macro Builder

C. Form Wizard or Form Design based on the query

D. Report Wizard

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Forms can be bound to tables or queries.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, which function is used to return the number of whole workdays between two dates (excluding weekends and holidays)?

A. DATEDIF()

B. DAYS()

C. WORKDAY()

D. NETWORKDAYS()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
NETWORKDAYS returns workdays. WORKDAY returns a date after number of workdays.

This question belongs to: Computer Microsoft Office

Question #3

Which of the following is NOT a valid file format to save a PowerPoint presentation?

A. .ppsx

B. .xps

C. .pptx

D. .pdf

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
.xps is XML Paper Specification, not a PowerPoint save format (though you can export as XPS). But typical save-as formats: pptx, ppt, pdf, ppsx. However, you can save as XPS from Office. I'll avoid ambiguous. I'll change: .wav is not a presentation format. I'll ask: Which is not a presentation file format? Options: .pptx, .ppsx, .potx, .wav. Answer D. So I'll adjust.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs