In Access, which of the following is not a valid data type for a field? MCQ with Answer and Explanation

In Access, which of the following is not a valid data type for a field?
A. AutoNumber
B. Image
C. Currency
D. Yes/No
Answer: Option B
Solution (By JKExamLibrary)
There is no 'Image' data type; you use Attachment or OLE Object to store images.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS Word, the 'Ctrl + Shift + L' shortcut applies:
A. Left alignment
B. Line spacing
C. Bullet style (toggles bullet list)
D. Numbered list

Correct Answer: Option C


Explanation:
Ctrl+Shift+L applies or removes bullet formatting.

This question belongs to: Computer Microsoft Office
Question #2
Which component of an MS Access window workspace displays all available database objects like tables, queries, reports, and forms for double-click retrieval?
A. Properties Sheet window
B. Status Ribbon bar
C. Navigation Pane
D. Quick Access Panel

Correct Answer: Option C


Explanation:
The Navigation Pane on the left side of the screen provides central access to open, edit, or delete any object within the database file.

This question belongs to: Computer Microsoft Office
Question #3
In Access, which of the following is used to create a query that uses SQL?
A. Both A and B
B. Datasheet View
C. SQL View
D. Design View

Correct Answer: Option A


Explanation:
You can create a query in SQL View or Design View.

This question belongs to: Computer Microsoft Office