placeholder image to represent content

Access 2013 Unit 2

Quiz by Jennifer Michaels

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
7 questions
Show answers
  • Q1
    A query can only pull information from one table.
    False
    True
    30s
  • Q2
    If you put criteria for your query on two different rows, it's called a(n) ________________ query, and will return records that meet either criteria.
    And
    Not
    Criteria
    Or
    30s
  • Q3
    If you want to do a query, but you don't know the exact criteria, you can use ___________ which is a wildcard in place of characters or numbers.
    *
    /
    -
    +
    30s
  • Q4
    If you put 2 criteria on the same row, Access ___________________________.
    returns records, that meet one or the other criteria or both.
    returns records that meet at least one of the two criteria.
    returns only those records that meet both criteria.
    doesn't do anything - you can't put 2 criteria on the same row.
    30s
  • Q5
    If I want to run a query to figure out which products cost $10. or more, what criteria would I put in the Cost field?
    <>10
    >=10
    >10
    <10
    30s
  • Q6
    A _________________________________ query let you use the same query over and over but allows you to enter different criteria for the field each time that you run it.
    multi-table
    criteria
    join
    parameter
    30s
  • Q7
    A field that has a checkbox is a __________________ field type.
    Currency
    Yes/No
    Date
    Short Text
    30s

Teachers give this quiz to your class