Home / Computer Fundamentals / MS Access :: Section-1

Computer Fundamentals :: MS Access

  1.  Which of the following is not a valid relationship in MS-Access?

  2. A.

    One to one relationship

    B.

    One to many relationship

    C.

    One to two relationship

    D.

    Many to many relationship


  3.  _____ property is used to set the maximum size for data stored in a field?

  4. A.

    Data entry

    B.

    Field size

    C.

    Format

    D.

    Rows


  5.  Which of the following is valid text and memo format in MS-Access?

  6. A.

    @

    B.

    <

    C.

    &

    D.

    All of the above


  7.  Caption is a string that can contain up to _________ characters in MS-Access?

  8. A.

    2025

    B.

    2031

    C.

    2037

    D.

    2048


  9.  _____ property is used to specify requirements for data entered into a record, field or control?

  10. A.

    Validation text

    B.

    Validation rule

    C.

    Both a and b

    D.

    None of these


  11.  In MS-Access the maximum length of validation text is?

  12. A.

    126

    B.

    129

    C.

    234

    D.

    255


  13.  Which of the following the AutoCalc command on the toolbar provides in MS-Access?

  14. A.

    Sum

    B.

    Count

    C.

    Min

    D.

    All of the above


  15.  A database makes it unreadable in MS-Access is called?

  16. A.

    Encode

    B.

    Database

    C.

    Decode

    D.

    None


  17.  MDE file is a?

  18. A.

    Memory Database Encrypt

    B.

    Memory Database Encode

    C.

    Microsoft Database Encrypt

    D.

    Microsoft Access Database


  19.  MDE file does not contain?

  20. A.

    Macros

    B.

    Tables

    C.

    Queries

    D.

    Source code