HomeTech infoQuiz technology

What do you know about data queries?

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

You should read it

May be interested

  • Action Query in Action 2016Action Query in Action 2016
    action queries are queries that perform actions on data, can add, change or delete records.
  • Query analysis in MongoDBQuery analysis in MongoDB
    analyzing queries is a very important aspect to assess the effectiveness of database and the effectiveness of the designed index. we will explore the two most frequently used queries, $ explain and $ hint.
  • How to create duplicate search queries in Access 2016How to create duplicate search queries in Access 2016
    duplicate search queries allow you to search and identify duplicate records in a table or multiple tables. duplicate records are a record that refers to the same or the same person as another record.
  • MS Access - Lesson 3: Objects in the databaseMS Access - Lesson 3: Objects in the database
    objects in the database include tables, queries (queries), reports (reports), forms (forms), ...
  • MS Access 2003 - Lesson 21: Chapter 6: Using Query to check dataMS Access 2003 - Lesson 21: Chapter 6: Using Query to check data
    in this chapter, you will learn how to filter and organize data, which is a powerful tool provided by access - queries.
  • Steps to export Microsoft Access data to Word documentsSteps to export Microsoft Access data to Word documents
    access provides most of the features you would expect from a relational database management system. you can create tables, forms, queries, relationships, reports, macros, modules, etc. but sometimes, you may want to export data from microsoft access to word.
  • MS Access 2003 - Lesson 23: Own query designMS Access 2003 - Lesson 23: Own query design
    at this point, you can use the query wizard to create queries. but query wizard only creates a few commonly used queries. if one of those queries doesn't match, you can create your own query.
  • How to connect and use PostgreSQL in PythonHow to connect and use PostgreSQL in Python
    if you are writing a python program that needs to access data from a postgres database, you will need to know how to connect the two. once you establish a connection, you can use it to run queries and fetch or save data.
  • How to Send Sql Queries to Mysql from the Command LineHow to Send Sql Queries to Mysql from the Command Line
    a simple text-based program called mysql should have been part of your mysql installation. it lets you send sql queries directly to the mysql server and output the results in text format. it is a quick and easy way to test your mysql...
  • Alternate Criteria in Access 2016Alternate Criteria in Access 2016
    in addition to the uses of the tipsmake.com query introduced in the previous lessons, you can also view data and records that meet two or more conditions using the alternative criteria.

Quiz technology