Question 1

Which type of query retrieves data from one or more linked tables and displays the results in a datasheet?

Accepted Answer

A)  Common 
B)  Select 
C)  Linking 
D)  Web 
A)  Common 
B)  Select 
C)  Linking 
D)  Web B

Question 2

When you create a summary query, which row is added to the query design grid?

Accepted Answer

A)  Criteria 
B)  Table 
C)  Field 
D)  Total 
A)  Criteria 
B)  Table 
C)  Field 
D)  Total D

Question 3

Match each of the following with the correct definition or statement.
-A statistic such as a subtotal or count is determined on a given field in a group of records

Accepted Answer

A) Calculated field 
B) Expression 
C) Function 
D) Aggregate function 
E) Sort
F)Wildcard character 
A) Calculated field 
B) Expression 
C) Function 
D) Aggregate function 
E) Sort
F)Wildcard character D

Question 4

Discuss the use of the * wildcard character in query criteria.

Accepted Answer

The wildcard character * is us

Question 5

-In the accompanying figure, the criteria in the first row of the query would be considered AND criteria.

Accepted Answer

A) True 
 B)False

Question 6

The < comparison operator means ____.

Accepted Answer

A)  greater than 
B)  less than 
C)  like 
D)  not 
A)  greater than 
B)  less than 
C)  like 
D)  not

Question 7

The > comparison operator means ____.

Accepted Answer

A)  greater than 
B)  greater than or equal to 
C)  less than 
D)  less than or equal to 
A)  greater than 
B)  greater than or equal to 
C)  less than 
D)  less than or equal to

Question 8

When you are saving a query, you are saving a set of instructions written in Standard Query Language. _________________________

Accepted Answer

A) True 
 B)False

Question 9

In Query Design View, a table's name displays in the field list title bar.

Accepted Answer

A) True 
 B)False

Question 10

Match each of the following with the correct definition or statement.
-A datasheet's records are placed in a determined order

Accepted Answer

A) Calculated field 
B) Expression 
C) Function 
D) Aggregate function 
E) Sort
F)Wildcard character 
A) Calculated field 
B) Expression 
C) Function 
D) Aggregate function 
E) Sort
F)Wildcard character

Question 11

The wildcard character that represents one character in query criteria is the ____.

Accepted Answer

A)  asterisk (*) 
B)  exclamation point (!) 
C)  tilde (~) 
D)  question mark (?) 
A)  asterisk (*) 
B)  exclamation point (!) 
C)  tilde (~) 
D)  question mark (?)

Question 12

-In the accompanying figure, item 3 points to ____.

Accepted Answer

A)  a field from the Payments table 
B)  a field from the Tours table 
C)  the Payments field list 
D)  the Sales field list 
A)  a field from the Payments table 
B)  a field from the Tours table 
C)  the Payments field list 
D)  the Sales field list

Question 13

Syntax are tests, or limiting conditions, that must be true for a record to be selected for a datasheet in a query. _________________________

Accepted Answer

A) True 
 B)False

Question 14

The Find ____ Query Wizard is used to find records in one table that do not have related records in another table.

Accepted Answer

The answer of The Find ____ Query Wizard is used...

Question 15

A(n) ____ query is used to calculate statistics about a group of records.

Accepted Answer

The answer of A(n) ____ query is used to calculate...

Question 16

Which query wizard helps you build a crosstab query?

Accepted Answer

A)  Select Query Wizard 
B)  Crosstab Query Wizard 
C)  Simple Query Wizard 
D)  Find Aggregates Query Wizard 
A)  Select Query Wizard 
B)  Crosstab Query Wizard 
C)  Simple Query Wizard 
D)  Find Aggregates Query Wizard

Question 17

Sort orders defined in Query Design View are not saved with the query object.

Accepted Answer

A) True 
 B)False

Question 18

Which arithmetic operator signifies exponentiation?

Accepted Answer

A)  # 
B)  * 
C)  / 
D)  ^ 
A)  # 
B)  * 
C)  / 
D)  ^

Question 19

A select query is the most common type of query.

Accepted Answer

A) True 
 B)False

Question 20

____ queries summarize data in which one or more fields are chosen for the row headings, another for the column heading, and yet another for the field summarized within the datasheet itself.

Accepted Answer

The answer of ____ queries summarize data in which one...

Which type of query retrieves data from one or more linked tables and displays the results in a datasheet?

When you create a summary query, which row is added to the query design grid?

Match each of the following with the correct definition or statement. -A statistic such as a subtotal or count is determined on a given field in a group of records

Discuss the use of the * wildcard character in query criteria.

-In the accompanying figure, the criteria in the first row of the query would be considered AND criteria.

The < comparison operator means ____.

The > comparison operator means ____.

When you are saving a query, you are saving a set of instructions written in Standard Query Language. _________________________

In Query Design View, a table's name displays in the field list title bar.

Match each of the following with the correct definition or statement. -A datasheet's records are placed in a determined order

The wildcard character that represents one character in query criteria is the ____.

-In the accompanying figure, item 3 points to ____.

Syntax are tests, or limiting conditions, that must be true for a record to be selected for a datasheet in a query. _________________________

The Find ____ Query Wizard is used to find records in one table that do not have related records in another table.

A(n) ____ query is used to calculate statistics about a group of records.

Which query wizard helps you build a crosstab query?

Sort orders defined in Query Design View are not saved with the query object.

Which arithmetic operator signifies exponentiation?

A select query is the most common type of query.

____ queries summarize data in which one or more fields are chosen for the row headings, another for the column heading, and yet another for the field summarized within the datasheet itself.

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 7: Improving Queries

Which type of query retrieves data from one or more linked tables and displays the results in a datasheet?

When you create a summary query, which row is added to the query design grid?

Match each of the following with the correct definition or statement. -A statistic such as a subtotal or count is determined on a given field in a group of records

Discuss the use of the * wildcard character in query criteria.

-In the accompanying figure, the criteria in the first row of the query would be considered AND criteria.

The < comparison operator means ____.

The > comparison operator means ____.

When you are saving a query, you are saving a set of instructions written in Standard Query Language. _________________________

In Query Design View, a table's name displays in the field list title bar.

Match each of the following with the correct definition or statement. -A datasheet's records are placed in a determined order

The wildcard character that represents one character in query criteria is the ____.

-In the accompanying figure, item 3 points to ____.

Syntax are tests, or limiting conditions, that must be true for a record to be selected for a datasheet in a query. _________________________

The Find ____ Query Wizard is used to find records in one table that do not have related records in another table.

A(n) ____ query is used to calculate statistics about a group of records.

Which query wizard helps you build a crosstab query?

Sort orders defined in Query Design View are not saved with the query object.

Which arithmetic operator signifies exponentiation?

A select query is the most common type of query.

____ queries summarize data in which one or more fields are chosen for the row headings, another for the column heading, and yet another for the field summarized within the datasheet itself.

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters