Working with Queries

A ______ is a database object that helps you to retrieve and view information from one or

more database tables.

• Forms

• Query

• Tables

• Reports

_____ are the links that associate a field in one table with the same field in another table.

• Reports

• Forms

• Relationships

A relationship works by matching _______ with the same name in both the tables.

• Field

• Record

• Report

Which query prompts you input?

• Action Query

• Parameter query

• Select Query

Which query creates a new table or alters your data or database by adding or deleting or updating and appending data to it.

• Parameter Query

• Action Query

• Cross tab Query

In how many ways ,you can create queries?

• one

• two

• three

_____ contains the condition on the basis of which the records will be filtered in the Query output.

• Criteria

• Table

• Field

Which property is used to set multiple criteria in a query?

• And

• Or

• Not

_____ is used to filter the data either in an ascending or descending order.

• Edit

• Sort

• Field

Which key defines a relationship between two tables?

• Candidate key

• Primary Key

• Secondary key