Microsoft Access 2007- Review Exam For 3rd Year Mcs Students Part 2

45 Questions | Total Attempts: 177

SettingsSettingsSettings
Microsoft Access 2007- Review Exam For 3rd Year Mcs Students Part 2 - Quiz

Part 2 Review Exam- Bakbakan na!


Questions and Answers
  • 1. 
    This is a form within a form that also displays data records from more than one table.
    • A. 

      List box

    • B. 

      Rectangle

    • C. 

      Line

    • D. 

      Sub form/Sub report

  • 2. 
    This works like a combo box, but is displayed differently.
    • A. 

      List box

    • B. 

      Rectangle

    • C. 

      Line

    • D. 

      Sub form/Sub report

  • 3. 
    This is used to provide users with a list of values that can either be bound to a field in a table, or     Unbound which stores values not related with any of the tables.
    • A. 

      Label

    • B. 

      Text box

    • C. 

      Combo box

    • D. 

      Button

  • 4. 
    It used to perform an action or set of actions when clicked.
    • A. 

      Label

    • B. 

      Text box

    • C. 

      Combo box

    • D. 

      Button

  • 5. 
    It is one or more fields whose value or values uniquely identify each record in a table.
    • A. 

      Ctrl key

    • B. 

      Primary key

    • C. 

      One to one

    • D. 

      Relationship

  • 6. 
    The key used to select one or more primary keys while clicking the field row selector.
    • A. 

      Ctrl key

    • B. 

      Primary key

    • C. 

      One to one

    • D. 

      Relationship

  • 7. 
    It is an association established between common fields in two tables.
    • A. 

      Ctrl key

    • B. 

      Primary key

    • C. 

      One to one

    • D. 

      Relationship

  • 8. 
    It is a relationship that can be established when one record in a table has only one matching record       In another table.
    • A. 

      Ctrl key

    • B. 

      Primary key

    • C. 

      One to one

    • D. 

      Relationship

  • 9. 
    It is the most common type of relationship.
    • A. 

      One too many

    • B. 

      Many too many

    • C. 

      Junction table

    • D. 

      Foreign keys

  • 10. 
    It is an association between two tables in which one record in either table can relate to many     Records in another table.
    • A. 

      One too many

    • B. 

      Foreign keys

    • C. 

      Junction table

    • D. 

      Many too many

  • 11. 
    It is a table that contains common fields from two tables.
    • A. 

      One too many

    • B. 

      Foreign keys

    • C. 

      Junction table

    • D. 

      Many too many

  • 12. 
    It ensures that relationships between records in related tables are valid and that you don't     Accidentally delete or change related data.
    • A. 

      Design

    • B. 

      Referential

    • C. 

      Both A and B

    • D. 

      None of the above

  • 13. 
    The contextual tab where the Edit Relationships button belongs.
    • A. 

      Design

    • B. 

      Referential

    • C. 

      Both A and B

    • D. 

      None of the above

  • 14. 
    It is the most commonly used type of query which retrieves records from one or more tables.
    • A. 

      Action

    • B. 

      Cross tab

    • C. 

      Select

    • D. 

      Other

  • 15. 
    This query is used to make changes to records or move a group of records.
    • A. 

      Action

    • B. 

      Cross tab

    • C. 

      Select

    • D. 

      Other

  • 16. 
    This query is used to calculate and restructure data for easier analysis.
    • A. 

      Action

    • B. 

      Cross tab

    • C. 

      Select

    • D. 

      Other

  • 17. 
    The group where the Query Wizard and Query Design belongs.
    • A. 

      Action

    • B. 

      Cross tab

    • C. 

      Select

    • D. 

      Other

  • 18. 
    These are values such as numbers, characters, or dates, which Access evaluates exactly as     Written.
    • A. 

      Literal Values

    • B. 

      Functions

    • C. 

      Constants

    • D. 

      Identifiers

  • 19. 
    Elements in an expression with values that do not change are called______.
    • A. 

      Literal Values

    • B. 

      Functions

    • C. 

      Constants

    • D. 

      Identifiers

  • 20. 
    In an expression, a function returns a valued based on the results of a calculation or other     Operation.
    • A. 

      Literal Values

    • B. 

      Functions

    • C. 

      Constants

    • D. 

      Identifiers

  • 21. 
    The value of a field, control, or property is referred to______.
    • A. 

      Literal Values

    • B. 

      Functions

    • C. 

      Constants

    • D. 

      Identifiers

  • 22. 
    This is the area where you construct/build your expression.
    • A. 

      Expression elements

    • B. 

      Expression box

    • C. 

      Operator buttons

    • D. 

      None of the above

  • 23. 
    These are commonly used operators that you can use in your expression
    • A. 

      Expression elements

    • B. 

      Expression box

    • C. 

      Operator buttons

    • D. 

      Both A and B

  • 24. 
    This contains three columns: the left column displays the folder that list the tables, queries, forms     And reports in your database, as well as the available functions.
    • A. 

      Expression elements

    • B. 

      Expression box

    • C. 

      Operator buttons

    • D. 

      None of the above

  • 25. 
    These are ready- made databases formats with pre- designed objects available in MS Access 07.
    • A. 

      Templates

    • B. 

      Table templates

    • C. 

      Functions

    • D. 

      Fields templates

Back to Top Back to top