Question 1

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 2

Match each of the following with the correct definition or statement.
-A field of data that is created based on values of other fields

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 3

Match each of the following with the correct definition or statement.
-An asterisk or question mark used in a query

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 4

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 5

An SQL statement determines how the resulting records are sorted after the ____ keyword.

Accepted Answer

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

Question 6

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

Accepted Answer

A)  Avg 
B)  Average 
C)  Mean 
D)  Mode 
A)  Avg 
B)  Average 
C)  Mean 
D)  Mode

Question 7

In Query Design View, one-to-many join lines identify linking fields between related tables.

Accepted Answer

A) True 
 B)False

Question 8

-In the query shown in the accompanying figure, what are the names of the tables involved in the query?

Accepted Answer

Only one table is in

Question 9

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 10

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 11

When the comparison operator Null is used as criteria in the query design grid, the query finds records in which ____.

Accepted Answer

A)  the value is not equal to the text "Null" 
B)  the field value is equal to the text "Null" 
C)  any value has been entered for a field 
D)  no value has been entered for a field 
A)  the value is not equal to the text "Null" 
B)  the field value is equal to the text "Null" 
C)  any value has been entered for a field 
D)  no value has been entered for a field

Question 12

-You want to add the PaymentDate field from the Payments table in the query shown in the accompanying figure. Describe how you can do this.

Accepted Answer

Drag the PaymentDate field in the Paymen

Question 13

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 14

Match each of the following with the correct definition or statement.
-A combination of field names, operators and functions

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 15

Queries evaluate sort orders from left to right. _________________________

Accepted Answer

A) True 
 B)False

Question 16

Which arithmetic operator signifies division?

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

-In the accompanying figure, what is the primary key field of the Tours table?

Accepted Answer

A)  TourNo 
B)  Customers 
C)  Sales 
D)  Tours 
A)  TourNo 
B)  Customers 
C)  Sales 
D)  Tours

Question 20

In Query Design View, you can drag the edge of a(n) field list to resize it. _________________________

Accepted Answer

A) True 
 B)False

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

Match each of the following with the correct definition or statement. -A field of data that is created based on values of other fields

Match each of the following with the correct definition or statement. -An asterisk or question mark used in a query

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

An SQL statement determines how the resulting records are sorted after the ____ keyword.

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

In Query Design View, one-to-many join lines identify linking fields between related tables.

-In the query shown in the accompanying figure, what are the names of the tables involved in the query?

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

The >= comparison operator means ____.

When the comparison operator Null is used as criteria in the query design grid, the query finds records in which ____.

-You want to add the PaymentDate field from the Payments table in the query shown in the accompanying figure. Describe how you can do this.

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

Match each of the following with the correct definition or statement. -A combination of field names, operators and functions

Queries evaluate sort orders from left to right. _________________________

Which arithmetic operator signifies division?

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

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

-In the accompanying figure, what is the primary key field of the Tours table?

In Query Design View, you can drag the edge of a(n) field list to resize it. _________________________

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

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

Match each of the following with the correct definition or statement. -A field of data that is created based on values of other fields

Match each of the following with the correct definition or statement. -An asterisk or question mark used in a query

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

An SQL statement determines how the resulting records are sorted after the ____ keyword.

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

In Query Design View, one-to-many join lines identify linking fields between related tables.

-In the query shown in the accompanying figure, what are the names of the tables involved in the query?

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

The >= comparison operator means ____.

When the comparison operator Null is used as criteria in the query design grid, the query finds records in which ____.

-You want to add the PaymentDate field from the Payments table in the query shown in the accompanying figure. Describe how you can do this.

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

Match each of the following with the correct definition or statement. -A combination of field names, operators and functions

Queries evaluate sort orders from left to right. _________________________

Which arithmetic operator signifies division?

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

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

-In the accompanying figure, what is the primary key field of the Tours table?

In Query Design View, you can drag the edge of a(n) field list to resize it. _________________________

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