Selected MCQ

Current Question
In MS Access, in which method do you not need to specify the field type and size when creating a new table?
  • A. Create a table in Design View
  • B. Create a table using the wizard
  • C. Create a table by entering data
  • D. All of these
Correct Answer: C
Explanation:
“Create Table by Entering data” (Datasheet View) lets Access automatically detect and assign field types.
Related Question 1
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 2
How many types of computers are there according to size?
  • A. 4
  • B. 3
  • C. 2
  • D. None of these
Correct Answer: A
Explanation:
Computers are commonly classified into 4 types by size: Super, Mainframe, Mini, and Micro.
Related Question 3
Form Wizard in MS Access can build forms that can display ____ fields from table(s).
  • A. One
  • B. Two
  • C. Three
  • D. Many
Correct Answer: D
Explanation:
The Form Wizard can pull fields from multiple related tables to create complex forms.
Related Question 4
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 5
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.