Quiz: Queries In MS. Access

10 Questions | Total Attempts: 951

SettingsSettingsSettings
Please wait...
Sophies Choice Quizzes & Trivia

MS Access has it all what it takes to manage a whole database with its tools and features to face the modern world data-related problems.


Questions and Answers
  • 1. 
    Give the correct expression operator - Numbers between 1 to 10.
    • A. 

      Between 1 or 10

    • B. 

      Between 1 to 10

    • C. 

      Between 1 and 10

    • D. 

      Between 1 - 10

  • 2. 
    Give the correct expression operator - Values are Apple or Orange.
    • A. 

      "Apple" or "Orange"

    • B. 

      "Apple" and "Orange"

    • C. 

      "Apple" not "Orange"

    • D. 

      "Apple" in "Orange"

  • 3. 
    Give the correct expression operator - Values are Ham and Egg. 
    • A. 

      "Ham" or "Egg"

    • B. 

      "Ham" and "Egg"

    • C. 

      "Ham" not "Egg"

    • D. 

      "Ham" in "Egg"

  • 4. 
    Give the correct expression operator - All words beginning with "z"
    • A. 

      Like "z!"

    • B. 

      Like "z#"

    • C. 

      Like "z?"

    • D. 

      Like "z*"

  • 5. 
    It is a database object used to view, change, and analyze data in different ways.
    • A. 

      Query

    • B. 

      Inquiry

    • C. 

      Inquire

    • D. 

      Questions

  • 6. 
    It retrieves records from one or more tables and then displays the results in the order you want.
    • A. 

      Parameter Query

    • B. 

      Select Query

    • C. 

      Crosstab Query

    • D. 

      Action Query

  • 7. 
    It is used to calculate and restructure data for easier analysis or your data. It calculates the sum, average, count, or other types of total for data that is grouped by two types of information.
    • A. 

      Select Query

    • B. 

      Parameter Query

    • C. 

      Action Query

    • D. 

      Crosstab Query

  • 8. 
    It is a query that when run, displays its own dialog box prompting you for information, such as criteria for retrieving records or a value you want to insert in a field.
    • A. 

      Crosstab Query

    • B. 

      Action Query

    • C. 

      Parameter Query

    • D. 

      Select Query

  • 9. 
    It matches any letter.
    • A. 

      #

    • B. 

      ?

    • C. 

    • D. 

      =

  • 10. 
    Indicated criteria should not be met
    • A. 

      NOT

    • B. 

    • C. 

      >

    • D. 

      !

Back to Top Back to top