In MS Access, the 'Report Wizard' allows you to: MCQ with Answer and Explanation

In MS Access, the 'Report Wizard' allows you to:
A. Create macros for reporting
B. Design a table
C. Write SQL for a report
D. Create a report quickly by selecting fields, grouping, and layout
Answer: Option D
Solution (By JKExamLibrary)
Report Wizard steps through report creation.

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
Which field data type property in MS Access is ideal for fields that store long descriptions or logs that exceed 255 characters?
A. Short Text
B. Long Text
C. OLE Object Data Type
D. Hyperlink text block

Correct Answer: Option B


Explanation:
In modern versions of MS Access, the 'Long Text' data type (previously known as Memo) stores up to 1 gigabyte of alphanumeric characters, whereas 'Short Text' is capped at 255 characters.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
What is the keyboard shortcut to cut selected content in MS Office?
A. Ctrl + X
B. Ctrl + C
C. Ctrl + V
D. Ctrl + Z

Correct Answer: Option A


Explanation:
Ctrl + X cuts (removes) the selection and places it on the clipboard. Ctrl + C copies, Ctrl + V pastes, Ctrl + Z undoes.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In MS Access, the 'Indexed' property set to 'Yes (No Duplicates)' creates:
A. A foreign key
B. An index allowing duplicates
C. A primary key
D. A unique index, preventing duplicate values

Correct Answer: Option D


Explanation:
No Duplicates enforces uniqueness.

This question belongs to: Computer Microsoft Office