Question 1

In a query, the operator means not equal.

Accepted Answer

A) True 
 B)False

Question 2

The wildcard character that represents any combination of characters 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 3

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 4

You want to search for all last names beginning with the letter M in the query shown in the accompanying figure. Describe how to do this.

Accepted Answer

In the query design grid, ente

Question 5

The ____ function returns a number of characters from the first part of a field.

Accepted Answer

The answer of The ____ function returns a number of...

Question 6

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 7

Which arithmetic operator signifies exponentiation?

Accepted Answer

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

Question 8

SQL statements start with the FROM keyword.

Accepted Answer

A) True 
 B)False

Question 9

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 10

The ____ function returns the number of characters in a field.

Accepted Answer

The answer of The ____ function returns the number of...

Question 11

Which aggregate function is used to find the number of values in a field?

Accepted Answer

A)  Values 
B)  Num 
C)  Number 
D)  Count 
A)  Values 
B)  Num 
C)  Number 
D)  Count

Question 12

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 13

An SQL statement determines what fields are selected after the ____ keyword.

Accepted Answer

A)  SELECT 
B)  FROM 
C)  ORDER BY 
D)  LIST 
A)  SELECT 
B)  FROM 
C)  ORDER BY 
D)  LIST

Question 14

A select query is the most common type of query.

Accepted Answer

A) True 
 B)False

Question 15

Describe the one-to-many relationships of the tables shown in the accompanying figure.

Accepted Answer

The Customers and Sales tables are relat

Question 16

When a query is saved, it saves VBA statements.

Accepted Answer

A) True 
 B)False

Question 17

In SQL, the FROM keyword determines how records are sorted.

Accepted Answer

A) True 
 B)False

Question 18

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

Question 19

In the accompanying figure, 1 refers to a ____.

Accepted Answer

A)  function 
B)  operator 
C)  expression 
D)  calculated field name 
A)  function 
B)  operator 
C)  expression 
D)  calculated field name

Question 20

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...

In a query, the operator means not equal.

The wildcard character that represents any combination of characters in query criteria is the ____.

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

You want to search for all last names beginning with the letter M in the query shown in the accompanying figure. Describe how to do this.

The ____ function returns a number of characters from the first part of a field.

Which query wizard helps you build a crosstab query?

Which arithmetic operator signifies exponentiation?

SQL statements start with the FROM keyword.

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

The ____ function returns the number of characters in a field.

Which aggregate function is used to find the number of values in a field?

The > comparison operator means ____.

An SQL statement determines what fields are selected after the ____ keyword.

A select query is the most common type of query.

Describe the one-to-many relationships of the tables shown in the accompanying figure.

When a query is saved, it saves VBA statements.

In SQL, the FROM keyword determines how records are sorted.

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

In the accompanying figure, 1 refers to a ____.

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

Getting Started With Microsoft Office 2013

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Filters

Exam 6: Modifying the Database Structure

In a query, the operator means not equal.

The wildcard character that represents any combination of characters in query criteria is the ____.

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

You want to search for all last names beginning with the letter M in the query shown in the accompanying figure. Describe how to do this.

The ____ function returns a number of characters from the first part of a field.

Which query wizard helps you build a crosstab query?

Which arithmetic operator signifies exponentiation?

SQL statements start with the FROM keyword.

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

The ____ function returns the number of characters in a field.

Which aggregate function is used to find the number of values in a field?

The > comparison operator means ____.

An SQL statement determines what fields are selected after the ____ keyword.

A select query is the most common type of query.

Describe the one-to-many relationships of the tables shown in the accompanying figure.

When a query is saved, it saves VBA statements.

In SQL, the FROM keyword determines how records are sorted.

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

In the accompanying figure, 1 refers to a ____.

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

Getting Started With Microsoft Office 2013

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Filters