Final Exam Access

26 Questions | Total Attempts: 147

SettingsSettingsSettings
Please wait...
Final Exam Access

.


Questions and Answers
  • 1. 
    What is a table?
  • 2. 
     In MS Access, AutoNumber Data Type
    • A. 

      Can be Sequential

    • B. 

      Can be Random

    • C. 

      Can be Edited

    • D. 

      Only A & B

  • 3. 
     Which object is used to create a form?
    • A. 

      Tables and Queries

    • B. 

      Tables only

    • C. 

      Tables and reports

    • D. 

      Queries and reports

  • 4. 
    What determines a table’s sort order?
    • A. 

      Primary key

    • B. 

      Field order

    • C. 

      Index field

    • D. 

      AutoNumber field

  • 5. 
    Which of the following is not a view for interacting with a form object?
    • A. 

      Datasheet view

    • B. 

      Design view

    • C. 

      Form view

    • D. 

      Layout view

  • 6. 
    There are three types of relationships in Microsoft Access: One-to-many Many-to-many One-to-one
    • A. 

      True

    • B. 

      False

  • 7. 
    Which is the valid data type in Access?
    • A. 

      Number

    • B. 

      Text

    • C. 

      Currency

    • D. 

      All of the above

  • 8. 
    Table, Query, Form, Report, Macro and Module are the objects in Ms Access
    • A. 

      True

    • B. 

      False

  • 9. 
    Table- The central framework of a database that stores data in fields (columns) and records (rows).
    • A. 

      True

    • B. 

      False

  • 10. 
    ________________________________ are used to create a new report
  • 11. 
    What is an intersection of a row and a column?
    • A. 

      Form

    • B. 

      Cursor

    • C. 

      Cell

    • D. 

      Record

  • 12. 
    Which of the following is not a view for interacting with a form object?
    • A. 

      Datasheet view

    • B. 

      Design view

    • C. 

      Form view

    • D. 

      Layout view

  • 13. 
    Which is the valid data type in Access?
    • A. 

      Number

    • B. 

      Text

    • C. 

      Currency

    • D. 

      All of the above

  • 14. 
     It is important to assign appropriate data types to a field since they specify what type of data can be entered into a field.
    • A. 

      True

    • B. 

      False

  • 15. 
    Which data type is better to use for storing phone number in the following format “977-1-1234567”?
    • A. 

      Text

    • B. 

      AutoNumber

    • C. 

      Number

    • D. 

      Currency

  • 16. 
    Which criteria return only those addresses beginning with the letter “K”?
    • A. 

      Address = “K”

    • B. 

      Address = “K*”

    • C. 

      Address = “K?”

    • D. 

      Address = “K#”

  • 17. 
    How to make a date field DOB store the dates like “2002/10/17” ?
    • A. 

      By setting the input mask property to “yyyy/mm/dd”

    • B. 

      By setting the format property to “yyyy/mm/dd”

    • C. 

      By entering dates in yyyy, mm, dd order

    • D. 

      None of the above

  • 18. 
    Which leads you through the process of creating a table?
    • A. 

      Wizard

    • B. 

      Assistant

    • C. 

      Relation

    • D. 

      Coach

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

      Text

    • B. 

      AutoNumber

    • C. 

      Number

    • D. 

      Currency

  • 20. 
    Ms Access is a software to manage data to produce information  which is called Database Management System or DBMS
    • A. 

      True

    • B. 

      False

  • 21. 
    Which of the following is not a valid Data Type in MS Access?
    • A. 

      Memo

    • B. 

      Picture

    • C. 

      Currency

    • D. 

      AutoNumber

  • 22. 
    In MS Access “Hyperlink” Data Type can store
    • A. 

      Web Address

    • B. 

      Email Address

    • C. 

      Path of a file

    • D. 

      All of the above

  • 23. 
    Which of the following views enables you to enter values in to a table?
    • A. 

      Design

    • B. 

      Datasheet

    • C. 

      Database

    • D. 

      Layout

  • 24. 
    A report is graphical interface used for data entry.
    • A. 

      True

    • B. 

      False

  • 25. 
    Is [your statement here] true or false?
    • A. 

      True

    • B. 

      False