In MS Access, which query type can be executed to add brand new rows of records from an external source or table directly into an existing table? MCQ with Answer and Explanation

In MS Access, which query type can be executed to add brand new rows of records from an external source or table directly into an existing table?
A. Make-Table Query
B. Append Query
C. Update Query
D. Delete Query
Answer: Option B
Solution (By JKSSB Mock Tests)
An Append Query selects records from one or more data sources and adds them to the end of an existing target table.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
Which of the following is the shortcut to insert a new slide in PowerPoint?
A. Ctrl + M
B. Ctrl + I
C. Ctrl + N
D. Ctrl + D

Correct Answer: Option A


Explanation:
Ctrl+M new slide.

This question belongs to: Computer Microsoft Office
Question #2
In PowerPoint, to add a sound that plays across multiple slides, use:
A. Audio Tools Playback -> Play Across Slides
B. Animations -> Sound
C. Insert -> Audio -> Play Across
D. Transitions -> Sound

Correct Answer: Option A


Explanation:
Play Across Slides under Playback tab.

This question belongs to: Computer Microsoft Office
Question #3
In MS Word, which of the following is not a valid file format to save a document?
A. .xlsx
B. .docx
C. .txt
D. .pdf

Correct Answer: Option A


Explanation:
.xlsx is Excel format; Word cannot save as .xlsx directly.

This question belongs to: Computer Microsoft Office