Question 1

What is a Query in MS Access program?

Accepted Answer

It is an object used to select records from one or more tables based on conditions specified by the user.

Answer

It is a control  used to edit and add records from one or more data based on conditions specified by the type.

Answer

It is an object used to delete records from one or more fields based on conditions specified by the query.

Answer

It is a control used to add records from one or more queries based on conditions specified by the user.

Question 2

Which of the following is considered  type of a Query we can create?

Accepted Answer

Cross-tab Query

Answer

Record Query

Answer

Table Query

Answer

Fields Query

Question 3

SQL is one of the query types we can create in MS Access program, what does SQL stand for?

Accepted Answer

It stands for Structured Query Lanugage.

Answer

It stands for System Queue Language.

Answer

It stands for System Query Language.

Answer

It stands for Structured Queue Leagues.

Question 4

What are the two ways for creating a Select Query in MS Access program?

Accepted Answer

Query Wizard, and Design View.

Answer

Query template and Design sheet.

Answer

Query View, and Design Wizard.

Answer

Query sheet and Design template.

Question 5

Where does MS Access display all of the records we add to the table?

Accepted Answer

Access displays all of the records in Datasheet view.

Answer

Access displays all of the records in Querysheet view.

Answer

Access displays all of the records in Designsheet view.

Answer

Access displays all of the records in Tablesheet view.

Question 6

What is a Parameter Query in MS Access program?

Accepted Answer

It is a  query type that is  used to retrieve the data based on the criteria.

Answer

It is a  table  type that is  used to retrieve the fields based on the criteria.

Answer

It is a  field type that is  used to retrieve the table based on the criteria.

Answer

It is a  record type that is  used to retrieve the query based on the criteria.

Question 7

Is it TRUE or FALSE, that we must enclose phrases in brackets when creating a parameter query.

Accepted Answer

TRUE.

Answer

All of the above.

Answer

FALSE.

Answer

Neither Nor.

Question 8

What are the two types of sorting records on query results?

Accepted Answer

Ascending and Descending orders.

Answer

Ascembing and Descembing orders.

Answer

Sort fields order and Sort Records order.

Answer

Format query and Format records.

Question 9

What does a prompt mean in a Parameter Query?

Accepted Answer

It is the text that appears in the Enter Parameter Value dialog box to tell the user what information should be entered.

Answer

It is the table that appears in the Enter Parameter table dialog box to tell the user what table should be edited.

Answer

It is the query that appears in the Enter Parameter phrase dialog box to tell the user what query should be entered.

Answer

It is the record  that appears in the Enter the Value dialog box to tell the user what record should be deleted.

Question 10

Is it TRUE or FALSE, that the message entered in the criteria when creating a parameter query should be preceded by " ( "  and followed by " ) ".

Accepted Answer

FALSE.

Answer

All of the above.

Answer

Neither Nor.

Answer

TRUE.

Related quizzes

Related quizzes