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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  6. A.

    @

    B.

    <

    C.

    &

    D.

    All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  8. A.

    2025

    B.

    2031

    C.

    2037

    D.

    2048

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  12. A.

    126

    B.

    129

    C.

    234

    D.

    255

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  16. A.

    Encode

    B.

    Database

    C.

    Decode

    D.

    None

    View Answer

    Workspace

    Discuss Discuss in Forum


  17.  MDE file is a?

  18. A.

    Memory Database Encrypt

    B.

    Memory Database Encode

    C.

    Microsoft Database Encrypt

    D.

    Microsoft Access Database

    View Answer

    Workspace

    Discuss Discuss in Forum


  19.  MDE file does not contain?

  20. A.

    Macros

    B.

    Tables

    C.

    Queries

    D.

    Source code

    View Answer

    Workspace

    Discuss Discuss in Forum