Which action query type in MS Access copies selected data rows from one or more existing source tables and creates a brand-new table with those records? MCQ with Answer and Explanation

Which action query type in MS Access copies selected data rows from one or more existing source tables and creates a brand-new table with those records?
A. Append Query
B. Crosstab Query
C. Make-Table Query
D. Update Query
Answer: Option C
Solution (By JKExamLibrary)
A Make-Table Query extracts specific records from existing source fields and uses them to create a brand-new table in the database file.

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
What is the shortcut key to paste special in MS Office?
A. Alt + E, S
B. Both A and C
C. Ctrl + Alt + V
D. Ctrl + Shift + V

Correct Answer: Option B


Explanation:
In many Office apps, Ctrl+Alt+V opens Paste Special, and Alt+E,S is the old menu shortcut. So both are valid.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In PowerPoint, what is a 'trigger' in animations?
A. A sound that plays on slide advance
B. An object that starts an animation when clicked
C. An automatic timer for transition
D. A hyperlink to another slide

Correct Answer: Option B


Explanation:
Trigger sets an animation to begin on the click of a specified object.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
Which of the following is NOT a valid file format to save a PowerPoint presentation?
A. .ppsx
B. .xps
C. .pptx
D. .pdf

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