Operate Database Application (Basic)

30 Questions | Total Attempts: 212

SettingsSettingsSettings
Please wait...
Database Quizzes & Trivia

This Quiz is for everyone who needs to understand more with skill in learning Microsoft Access 2007.


Questions and Answers
  • 1. 
    It refers to the processed data
  • 2. 
    A collection of related information that is organized in a table with rows and columns
  • 3. 
    Its store and organize data in a database
  • 4. 
    ____________ ask questions.
  • 5. 
    The row in the table is ____________
  • 6. 
    Microsoft Access is a
    • A. 

      Operating System

    • B. 

      Spreadsheet Solution

    • C. 

      Database Management System

    • D. 

      None of the above

  • 7. 
    ____________ Ensures that the relationship between a primary and related tables is maintained
    • A. 

      Primary Key

    • B. 

      Foreign Key

    • C. 

      Referential Integrity

  • 8. 
    A report header will display
    • A. 

      On all the pages

    • B. 

      On the first page of the report

    • C. 

      On the last page of the report

  • 9. 
    Which of he following is NOT a part of a database?
    • A. 

      Tables

    • B. 

      Records

    • C. 

      Fields

    • D. 

      Worksheets

  • 10. 
    In a database, each _________________ contains a collection of related data.
    • A. 

      Table

    • B. 

      Record

    • C. 

      Field

    • D. 

      None of the above

  • 11. 
    In a database, a _____________ is a unit of information about one individual or item.
    • A. 

      Table

    • B. 

      Record

    • C. 

      Field

    • D. 

      File

  • 12. 
    In a record, each separate piece of data, such as a last name, a first name, or an address, is called a _____________.
    • A. 

      File

    • B. 

      Field

    • C. 

      Record

    • D. 

      Table

  • 13. 
    What does GIGO stand for?
    • A. 

      Get in, get out

    • B. 

      Garbage in, garbage out

    • C. 

      Good information in, good information out

    • D. 

      Garbage input, garbage output

  • 14. 
    Which of the following is a way to sort data?
    • A. 

      Chronologically

    • B. 

      Alphabetically

    • C. 

      Numerically

    • D. 

      All of the above

    • E. 

      None of the above

  • 15. 
    If you sort data in order of decreasing value such as Z-A, or 10-1, what type of sort are you using?
    • A. 

      Ascending

    • B. 

      Descending

    • C. 

      Incremental

    • D. 

      Exponential

  • 16. 
    What is a query?
    • A. 

      A question you ask a database

    • B. 

      A question you ask a record

    • C. 

      A question you ask a table

    • D. 

      A question you ask a field

  • 17. 
    What does SQL stand for?
    • A. 

      Structured query language

    • B. 

      Stated question language

    • C. 

      System query lingo

    • D. 

      Status query language

  • 18. 
    A database is an organized collection of information.
    • A. 

      True

    • B. 

      False

  • 19. 
    A field's data type determines what kind of information can be stored there.
    • A. 

      True

    • B. 

      False

  • 20. 
    A computerized database can store millions of telephone numbers.
    • A. 

      True

    • B. 

      False

  • 21. 
    A database is a collection of related information, but a database management system is a type of software program.
    • A. 

      True

    • B. 

      False

  • 22. 
    A query lets you speed up the prowsing process by finding information that matches specifically to your criteria.
    • A. 

      True

    • B. 

      False

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

      Relationship

    • B. 

      One-to-One Relationship

    • C. 

      One-to-many Relationship

    • D. 

      Many-to-many Relationship

  • 24. 
    It is an association between two tables in which one record in either table can relate to many      records in other table.
    • A. 

      Relationship

    • B. 

      One-to-One Relationship

    • C. 

      One-to-many Relationship

    • D. 

      Many-to-many Relationship

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

      Ctrl key

    • B. 

      Primary key

    • C. 

      One to one

    • D. 

      Relationship

Related Topics
Back to Top Back to top