In MS Access, which query is used to find duplicate records in a table? MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, which query is used to find duplicate records in a table?

A. Both A and B

B. Find Duplicates Query Wizard

C. Select query with GROUP BY and HAVING COUNT(*)>1

D. Crosstab query

Answer: Option A

Solution (By JKSSB Mock Tests)

Both the wizard and a totals query can identify duplicates.

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, which function counts the number of blank cells in a range?

A. COUNTIF()

B. COUNTBLANK()

C. COUNTA()

D. ISBLANK()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
COUNTBLANK(range) returns count of empty cells.

This question belongs to: Computer Microsoft Office

Question #2

Which presentation view displays an adjustable multi-level textual list of slide contents for quick editing in MS PowerPoint?

A. Reading Layout Mode

B. Outline View

C. Notes Page Layout

D. Slide Sorter View

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Outline View isolates the text hierarchy from layout graphics, enabling rapid edits to presentation titles and bullet points.

This question belongs to: Computer Microsoft Office

Question #3

In Access, which of the following is not a valid data type for a field?

A. Image

B. AutoNumber

C. Yes/No

D. Currency

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
There is no 'Image' data type; you use Attachment or OLE Object to store images.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs