TipsMake

What do you know about data queries?

Query is a way to search and compile data from one or more tables. Query execution is like asking a detailed question about databases. When creating a query in Access, you are defining specific search conditions to find exactly the data you need. In the quiz below, go with the network administrator to learn about this topic.

★ Create data queries in Access 2016 from simple to complex
★ Options to create data queries in Access 2016
  • Question 1. Query data means:
    • Print data
    • Search and display data
    • Updating data
    • Delete the data you no longer need
  • Question 2. If problems with which the question relates to only one table, we can:
    • Perform a search and filter operation on a table or form
    • Use the question form
    • A and B are both correct
    • A and B are all wrong
  • Question 3. If the problems are complex, involving many tables, we use:
    • Sample asked
    • Table
    • Report
    • Form
  • Question 4. To display some records in the database, statistics data, we use:
    • Sample asked
    • Question
    • Listed
    • Reply
  • Question 5. Before creating a questionnaire to solve problems involving multiple tables, which action should we take?
    • Grouping
    • Links between tables
    • Select the fields you want to display in the Show row
    • Enter the conditions in the QBE grid
  • Question 6. Question forms are often used to:
    • Arrange the records, select the fields to display, perform calculations
    • Select the records that meet the given conditions
    • Summarize and display information from multiple tables or other question forms
    • Both a, b and c
  • Question 7. The working modes with the questionnaire are:
    • Sample asked
    • Sample inquiry and design
    • Data page and design
    • Data pages and sample questions
  • Question 8. The results of the questionnaire implementation also act as:
    • A table
    • A form
    • A report
    • A sample asked
  • Question 9. The results of the questionnaire implementation can be involved in creating:
    • Tables, forms, question forms or reports
    • Other tables, forms, question forms or other pages
    • Tables, forms, other questionnaires or reports
    • Other tables, forms and questions
  • Question 10. '/' is a group operation:
    • Comparison operations
    • Arithmetic operation
    • Logical operations
    • Not belong to the above groups
  • Question 10. 'not' is a group operation:
    • Comparison operations
    • Arithmetic operation
    • Logical operations
    • Not belong to the above groups

Discover more

query creation query design Access queries query settings
Kareem Winters

Share by

Kareem Winters
Update 24 May 2019

You should read it