Question 1

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 2

-In the accompanying figure, the criteria in the TourStartDate column would be considered OR criteria.

Accepted Answer

A) True 
 B)False

Question 3

OR queries narrow the number of records that will appear in the datasheet because a record must be true for all criteria.

Accepted Answer

A) True 
 B)False

Question 4

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 5

In a query, the  operator means not equal.

Accepted Answer

A) True 
 B)False

Question 6

In the query shown in the accompanying figure, what sort orders have been specified?

Accepted Answer

The answer of In the query shown in the accompanying...

Question 7

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

Accepted Answer

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

Question 8

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 9

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 10

If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in any other query that also displays this customer's name.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

When a query is saved, it saves VBA statements. _________________________

Accepted Answer

A) True 
 B)False

Question 13

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

Access helps you with criteria syntax in the query design grid.

Accepted Answer

A) True 
 B)False

Question 15

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 16

-In the accompanying figure, how many fields will display on the resulting datasheet?

Accepted Answer

A)  3 
B)  4 
C)  5 
D)  6 
A)  3 
B)  4 
C)  5 
D)  6

Question 17

A select query can be used to develop summary calculations, such as the sum of the values in a field.

Accepted Answer

A) True 
 B)False

Question 18

A query can display fields from one or more tables in a relational database.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

The Customers and Sales tables are relat

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

-In the accompanying figure, the criteria in the TourStartDate column would be considered OR criteria.

OR queries narrow the number of records that will appear in the datasheet because a record must be true for all criteria.

The < comparison operator means ____.

In a query, the <> operator means not equal.

In the query shown in the accompanying figure, what sort orders have been specified?

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

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

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.

If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in any other query that also displays this customer's name.

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

When a query is saved, it saves VBA statements. _________________________

-In the accompanying figure, 1 refers to a ____.

Access helps you with criteria syntax in the query design grid.

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

-In the accompanying figure, how many fields will display on the resulting datasheet?

A select query can be used to develop summary calculations, such as the sum of the values in a field.

A query can display fields from one or more tables in a relational database.

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

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

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

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

-In the accompanying figure, the criteria in the TourStartDate column would be considered OR criteria.

OR queries narrow the number of records that will appear in the datasheet because a record must be true for all criteria.

The < comparison operator means ____.

In a query, the <> operator means not equal.

In the query shown in the accompanying figure, what sort orders have been specified?

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

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

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.

If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in any other query that also displays this customer's name.

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

When a query is saved, it saves VBA statements. _________________________

-In the accompanying figure, 1 refers to a ____.

Access helps you with criteria syntax in the query design grid.

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

-In the accompanying figure, how many fields will display on the resulting datasheet?

A select query can be used to develop summary calculations, such as the sum of the values in a field.

A query can display fields from one or more tables in a relational database.

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

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

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