In MS Access, which data type can store up to 65,536 characters?
A. Hyperlink
B. OLE Object
C. Memo (Long Text)
D. Text
Answer: Option C
Solution (By JKExamLibrary)
Long Text (formerly Memo) can store up to 65,536 characters. Short Text stores up to 255. Hyperlink is a type of Short Text, OLE Object stores binary data.
Explanation:
The #N/A (Not Available) error occurs when a formula or function cannot locate the target data requested, such as an exact match lookup missing from a reference table.
No comments yet. Be the first to start the discussion!