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

Computer Fundamentals :: MS Access

  1.  In a datasheet, what does each row represent ?

  2. A.

    Field

    B.

    Database

    C.

    Record

    D.

    All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  3.  What do you call a primary key field included in another table ?

  4. A.

    Child key

    B.

    Composite key

    C.

    Parent key

    D.

     Foreign key

    View Answer

    Workspace

    Discuss Discuss in Forum


  5.  What is the full form of SQL ?

  6. A.

    Structured Query Language

    B.

    Structured Question List

    C.

    Sophisticated Question List

    D.

    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  7.  Which data type is better to use for storing the price of an item ?

  8. A.

    Number

    B.

    Text

    C.

    Currency

    D.

    Hyperlink

    View Answer

    Workspace

    Discuss Discuss in Forum


  9.  The basic elements of a form or a report are called:

  10. A.

    Windows

    B.

    Controls

    C.

    Objects

    D.

    Table

    View Answer

    Workspace

    Discuss Discuss in Forum


  11.  Which of the following data type is used to store logical value in MS Access ?

  12. A.

    Yes/No

    B.

    On/Off

    C.

    True/False

    D.

    All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  13.  In MS Access “Lookup Wizard” is used to

  14. A.

    to select value from another table

    B.

     to select values from Excel Sheet

    C.

    to select from previous values

    D.

    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  15.  Which of the following is use to get data from user ?

  16. A.

    Query

    B.

    Form

    C.

    Report

    D.

    Table

    View Answer

    Workspace

    Discuss Discuss in Forum


  17.  Validation Rule in a field will

  18. A.

    Defines the appearance for the text

    B.

    Displays the value in specified format when user leaves the field

    C.

    Checks the value entered when user leaves the field

    D.

    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  19.  Query can be use to select data from

  20. A.

    Single Table

    B.

    Multiple Tables

    C.

    Both Single & Multiple Tables

    D.

    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum