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

50 Questions | Total Attempts: 297

SettingsSettingsSettings
Please wait...
Microsoft Access Quizzes & Trivia

To my 3rd year Students


Questions and Answers
  • 1. 
    It has rows and columns. It has rows and columns.
    • A. 

      Field

    • B. 

      Table

    • C. 

      Record

    • D. 

      None of the above

  • 2. 
    It is a category or type of information, e.g. , First Name, Last Name, Address, etc.
    • A. 

      Record

    • B. 

      Table

    • C. 

      Field

    • D. 

      None of the above

  • 3. 
    It is a set of fields for a specific item.
    • A. 

      Record

    • B. 

      Field

    • C. 

      Table

    • D. 

      None of the above

  • 4. 
    It allows you to view your data in a spreadsheet format. You can enter data in the same manner as a spreadsheet program like MS Excel 2007.
    • A. 

      Design View

    • B. 

      Datasheet view

    • C. 

      Both A and B

    • D. 

      Table in datasheet view

  • 5. 
    It is an empty table with a pre-defined but customizable format that you can immediately start using.
    • A. 

      Contacts

    • B. 

      Tasks

    • C. 

      Events

    • D. 

      Table template

  • 6. 
    A table for managing business contact information. It has fields such as Company, Last Name, First    Name, Job title, etc.
    • A. 

      Contacts

    • B. 

      Tasks

    • C. 

      Issues

    • D. 

      Events

  • 7. 
    A table for tracking tasks. It has fields such as Title, Priority, Status, etc.
    • A. 

      Contacts

    • B. 

      Tasks

    • C. 

      Issues

    • D. 

      Events

  • 8. 
    Table for tracking issues. It includes fields such as Title, Opened data, statue, etc.
    • A. 

      Contacts

    • B. 

      Tasks

    • C. 

      Issues

    • D. 

      Events

  • 9. 
    A table for managing events. It has a rich-text Memo field and a field for attachments.
    • A. 

      Contacts

    • B. 

      Tasks

    • C. 

      Issues

    • D. 

      Events

  • 10. 
    A table for managing business assets. It has fields such as Description, Category, Condition, etc.     which are crucial for assets management.
    • A. 

      Asset

    • B. 

      Events

    • C. 

      Tasks

    • D. 

      Contacts

  • 11. 
    It is advisable that the name of the table be related to its contents.
    • A. 

      Navigation Pane

    • B. 

      Rename

    • C. 

      Naming a table

    • D. 

      Enter

  • 12. 
    The default table name is called ______.
    • A. 

      Naming a table

    • B. 

      Table

    • C. 

      Both A and B

    • D. 

      None of the above

  • 13. 
    . for entries that can contain alphanumeric character and special symbols.
    • A. 

      Memo

    • B. 

      Date/ time

    • C. 

      Number

    • D. 

      Text

  • 14. 
    This data type can also contain a combination of text and numbers.
    • A. 

      Memo

    • B. 

      Date/ time

    • C. 

      Number

    • D. 

      Text

  • 15. 
    This is used for numbers that will be used for calculations.
    • A. 

      Memo

    • B. 

      Date/ time

    • C. 

      Number

    • D. 

      Text

  • 16. 
    Stores date and time values from the year 100 through 9999. a date field automatically assigns a      fields size.
    • A. 

      Memo

    • B. 

      Date/ time

    • C. 

      Number

    • D. 

      Text

  • 17. 
    For money, such as price or cost. Same as a number, but with decimal places and the currency      symbols.
    • A. 

      Currency

    • B. 

      Yes/ No

    • C. 

      AutoNumber

    • D. 

      OLE object

  • 18. 
    For automatic entry of non-repeating sequential numbers that uniquely identify a record in a table.
    • A. 

      Currency

    • B. 

      Yes/ No

    • C. 

      AutoNumber

    • D. 

      OLE object

  • 19. 
    For entries that must be answered by Yes or No, true or False, or on or off.
    • A. 

      Currency

    • B. 

      Yes/ No

    • C. 

      AutoNumber

    • D. 

      OLE object

  • 20. 
    For storing any object that can be linked or embedded in a table.
    • A. 

      Currency

    • B. 

      Yes/ No

    • C. 

      AutoNumber

    • D. 

      OLE object

  • 21. 
    For entries that contain a path to an object, file, website, or hard drive locations on your computer.
    • A. 

      Hyperlink

    • B. 

      Lookup wizard

    • C. 

      Attachment

    • D. 

      OLE object

  • 22. 
    Same as with OLE object. It can contain any supported type of file, including pictures, charts, and so      on.
    • A. 

      Hyperlink

    • B. 

      Lookup wizard

    • C. 

      Attachment

    • D. 

      OLE object

  • 23. 
    Creates a drop-down list from a specified table or from a list of entries you create.
    • A. 

      Hyperlink

    • B. 

      Lookup wizard

    • C. 

      Attachment

    • D. 

      OLE object

  • 24. 
    Stores up to 255 characters.
    • A. 

      Memo

    • B. 

      Number

    • C. 

      Date/ time

    • D. 

      Text

  • 25. 
    Stores up to 65,535 characters if you enter them manually and 2GB of data if you enter them from the program.
    • A. 

      Memo

    • B. 

      Number

    • C. 

      Date/ time

    • D. 

      Text

Back to Top Back to top