Simplified guide of MCQs for Exams, Interviews

Sub Topic: MS Access

1 .  Which field type will you select if you need to enter long text in that field?

  • A. Text
  • B. Memo
  • C. Currency
  • D. Hyperlink

Correct Answer:

Memo


2 .  The expression builder is an access tool that controls an expression___ for entering an expression

  • A. Table
  • B. Box
  • C. Cell
  • D. Palette

Correct Answer:

Box


3 .  Which of the following is not a type of MS Access database object?

  • A. Table
  • B. Form
  • C. Worksheets
  • D. Modules

Correct Answer:

Worksheets


4 .  Microsoft Access is a _____

  • A. Network Database Model
  • B. RDBMS
  • C. ORDBMS
  • D. OODBMS

Correct Answer:

RDBMS


5 .  Which of the following is not a type of Microsoft access database object?

  • A. Macros
  • B. Modules
  • C. Worksheets
  • D. Table

Correct Answer:

Worksheets


6 .  A subset of characters within a data field is known as

  • A. Byte
  • B. File
  • C. Record
  • D. Data string

Correct Answer:

Data string


7 .  ____ is not a valid data type in MS Access.

  • A. Auto number
  • B. Currency
  • C. Memo
  • D. Picture

Correct Answer:

Picture


8 .  A _____ is an area reserved for a specific piece of data.

  • A. Report
  • B. Key
  • C. Record
  • D. Field

Correct Answer:

Field


9 .  What is the maximum length a text field can be?

  • A. 75
  • B. 120
  • C. 255
  • D. 265

Correct Answer:

255


10 .  In Access, ____ are used to store the data.

  • A. Report
  • B. Form
  • C. Table
  • D. Query

Correct Answer:

Table