Which action query type in MS Access allows a database administrator to permanently remove a specific group of records from an underlying table based on criteria filters? MCQ with Answer and Explanation

Which action query type in MS Access allows a database administrator to permanently remove a specific group of records from an underlying table based on criteria filters?
A. Make-Table Query
B. Update Query
C. Append Query
D. Delete Query
Answer: Option D
Solution (By JKExamLibrary)
A Delete Query targets records that match specified criteria filters and permanently deletes those rows from the database table.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error
In MS Word, which feature allows you to send personalized letters to many recipients using a template and a data source?
A. Track Changes
B. Mail Merge
C. Quick Parts
D. Macros

Correct Answer: Option B


Explanation:
Mail Merge combines a main document with a recipient list to create multiple custom documents. Macros automate tasks, Track Changes records edits.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In MS Excel, which shortcut key combination selects all cells extending from the active cursor position to the very last populated cell in that row?
A. Ctrl + Shift + Right Arrow
B. Alt + Shift + Right Arrow
C. Shift + Page Down
D. Ctrl + Shift + End

Correct Answer: Option A


Explanation:
Ctrl + Shift + Right Arrow extends the cell selection block up to the last non-blank cell in the current row direction.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
What will be the output of the MS Excel formula =CEILING.MATH(14.2, 5)?
A. 20
B. 10
C. 15
D. 14

Correct Answer: Option C


Explanation:
The CEILING.MATH function rounds a number up to the nearest specified multiple. The nearest multiple of 5 greater than or equal to 14.2 is 15.

This question belongs to: Computer Microsoft Office