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


  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


  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


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

  8. A.

    Number

    B.

    Text

    C.

    Currency

    D.

    Hyperlink


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

  10. A.

    Windows

    B.

    Controls

    C.

    Objects

    D.

    Table


  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


  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


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

  16. A.

    Query

    B.

    Form

    C.

    Report

    D.

    Table


  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


  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