Selected MCQ

Current Question
Which of the following is not a valid data type in MS Access?
  • A. Text
  • B. Picture
  • C. Numeric
  • D. Time
Correct Answer: B
Explanation:
“Picture” is not a native data type in MS Access (use OLE Object or Attachment instead).
Related Question 1
In MS Access, which of the following data types allows alphanumeric characters and special symbols?
  • A. Text
  • B. Memo
  • C. Auto number
  • D. None of these
Correct Answer: A
Explanation:
The Text data type (Short Text) supports alphanumeric characters and special symbols up to 255 characters.
Related Question 2
In MS Access, what is the minimum number of data types that can be assigned to a field?
  • A. 02
  • B. 06
  • C. 10
  • D. None of these
Correct Answer: C
Explanation:
MS Access provides approximately 10 main data types that can be assigned to fields.
Related Question 3
In MS Access, which data type is appropriate to store large text and numbers?
  • A. Text
  • B. Memo
  • C. OLE
  • D. None of these
Correct Answer: B
Explanation:
The Memo data type (now Long Text) is designed for storing large amounts of text and numbers.
Related Question 4
The valid data type in Excel is ____.
  • A. Text
  • B. Boolean
  • C. Dictionary
  • D. None of these
Correct Answer: A
Explanation:
Text is a valid data type in Excel.
Related Question 5
A ____ is a collection of data organized in a manner that allows access, retrieval and use of that data.
  • A. File
  • B. Recordset
  • C. Database
  • D. document
Correct Answer: C
Explanation:
A database is an organized collection of data.