In MS Access, a 'Query' can be used to: MCQ with Answer and Explanation

Question

Share Report Error

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

A. Create relationships

B. Generate reports

C. Create forms

D. Add, delete, or update data in tables

Answer: Option D

Solution (By JKSSB Mock Tests)

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

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 error '#N/A' mean?

A. Division by zero

B. A value is not available to a function or formula

C. Name not recognized

D. Invalid cell reference

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
#N/A indicates no value available, common in lookup functions.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, to import data from another Access database, use:

A. External Data -> Access

B. Database Tools -> Import

C. File -> Open

D. Create -> Import Table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
External Data tab has import from Access.

This question belongs to: Computer Microsoft Office

Question #3

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

A. WORKDAY()

B. NETWORKDAYS()

C. DATEDIF()

D. DAYS()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

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

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs