Question 1

To find all first names that are either Tom or Tim, you would use the____ wildcard character.

Accepted Answer

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

Question 2

When you open a query in Datasheet View, you run it.

Accepted Answer

A) True 
 B)False

Question 3

Use the ____ check box in the query design grid to select or unselect a field to display in the resulting datasheet.

Accepted Answer

The answer of Use the ____ check box in the...

Question 4

You can view the SQL code for any query by switching to Code View. _________________________

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

The >= comparison operator means ____.

Accepted Answer

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

Question 7

Each criteria row of the query design grid is evaluated separately.

Accepted Answer

A) True 
 B)False

Question 8

Which arithmetic operator signifies exponentiation?

Accepted Answer

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

Question 9

A select query is the most common type of query.

Accepted Answer

A) True 
 B)False

Question 10

An SQL statement determines how the tables are joined after the ____ keyword

Accepted Answer

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

Question 11

Use the ____ Query Wizard to guide you through the steps of creating a crosstab query.

Accepted Answer

The answer of Use the ____ Query Wizard to guide...

Question 12

Deleting a field from the query design grid deletes it from the database table that contains that field.

Accepted Answer

A) True 
 B)False

Question 13

In Query Design View, primary key fields in a field list are ____.

Accepted Answer

A)  underlined 
B)  the first field listed 
C)  the last field listed 
D)  indicated with a key icon 
A)  underlined 
B)  the first field listed 
C)  the last field listed 
D)  indicated with a key icon

Question 14

The

Accepted Answer

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

Question 15

Which row in the query design grid identifies which of the three positions each field takes in the crosstab query?

Accepted Answer

A)  Group By row 
B)  Total row 
C)  Values row 
D)  Crosstab row 
A)  Group By row 
B)  Total row 
C)  Values row 
D)  Crosstab row

Question 16

In a query, the operator means not equal.

Accepted Answer

A) True 
 B)False

Question 17

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 18

The <  comparison operator means ____.

Accepted Answer

A)  less than 
B)  not equal to 
C)  greater than 
D)  null 
A)  less than 
B)  not equal to 
C)  greater than 
D)  null

Question 19

The data displayed in a query is sometimes called a(n) ____ view of the data.

Accepted Answer

The answer of The data displayed in a query is...

Question 20

A(n) ____ character is used in criteria to represent any combination of characters.

Accepted Answer

A)  Wildcard 
B)  Default 
C)  Criteria 
D)  Expression 
A)  Wildcard 
B)  Default 
C)  Criteria 
D)  Expression

To find all first names that are either Tom or Tim, you would use the____ wildcard character.

When you open a query in Datasheet View, you run it.

Use the ____ check box in the query design grid to select or unselect a field to display in the resulting datasheet.

You can view the SQL code for any query by switching to Code View. _________________________

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

The >= comparison operator means ____.

Each criteria row of the query design grid is evaluated separately.

Which arithmetic operator signifies exponentiation?

A select query is the most common type of query.

An SQL statement determines how the tables are joined after the ____ keyword

Use the ____ Query Wizard to guide you through the steps of creating a crosstab query.

Deleting a field from the query design grid deletes it from the database table that contains that field.

In Query Design View, primary key fields in a field list are ____.

The

Which row in the query design grid identifies which of the three positions each field takes in the crosstab query?

In a query, the operator means not equal.

Which query wizard helps you build a crosstab query?

The < comparison operator means ____.

The data displayed in a query is sometimes called a(n) ____ view of the data.

A(n) ____ character is used in criteria to represent any combination of characters.

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 6: Improving Queries

To find all first names that are either Tom or Tim, you would use the____ wildcard character.

When you open a query in Datasheet View, you run it.

Use the ____ check box in the query design grid to select or unselect a field to display in the resulting datasheet.

You can view the SQL code for any query by switching to Code View. _________________________

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

The >= comparison operator means ____.

Each criteria row of the query design grid is evaluated separately.

Which arithmetic operator signifies exponentiation?

A select query is the most common type of query.

An SQL statement determines how the tables are joined after the ____ keyword

Use the ____ Query Wizard to guide you through the steps of creating a crosstab query.

Deleting a field from the query design grid deletes it from the database table that contains that field.

In Query Design View, primary key fields in a field list are ____.

The

Which row in the query design grid identifies which of the three positions each field takes in the crosstab query?

In a query, the operator means not equal.

Which query wizard helps you build a crosstab query?

The < comparison operator means ____.

The data displayed in a query is sometimes called a(n) ____ view of the data.

A(n) ____ character is used in criteria to represent any combination of characters.

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters