Question 1

Which function should you use to calculate today's current date?

Accepted Answer

A)  CURRENT 
B)  DATE 
C)  YEAR 
D)  DAY 
A)  CURRENT 
B)  DATE 
C)  YEAR 
D)  DAY

Question 2

Filtering refers to reordering records in either ascending or descending order based on the values in the field. _________________________

Accepted Answer

A) True 
 B)False

Question 3

-In the accompanying figure, item 2 refers to a(n) ____.

Accepted Answer

A)  field list 
B)  one-to-many link line 
C)  query design grid 
D)  Show Table window 
A)  field list 
B)  one-to-many link line 
C)  query design grid 
D)  Show Table window

Question 4

SQL statements start with the FROM keyword. _________________________

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

-How many calculated fields are shown in the accompanying figure?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 8

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 9

Which function should you use to calculate the monthly payment on a loan?

Accepted Answer

A)  PMT 
B)  LOAN 
C)  PAY 
D)  RATE 
A)  PMT 
B)  LOAN 
C)  PAY 
D)  RATE

Question 10

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

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 11

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

Accepted Answer

A)  Sum 
B)  Sub 
C)  Subtotal 
D)  Total 
A)  Sum 
B)  Sub 
C)  Subtotal 
D)  Total

Question 12

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 13

Explain the relationship between the Like operator and the wildcard character using an example that describes how to create criteria for all values in a CompanyName field that start with the letter J.

Accepted Answer

The criteria for the CompanyName field w

Question 14

Multiple criteria added to the same line of the query design grid means that each must be true for the record to appear in the datasheet.

Accepted Answer

A) True 
 B)False

Question 15

____ criteria are two or more criteria on the same Criteria row of the query design grid.

Accepted Answer

A)  OR 
B)  Expand 
C)  AND 
D)  Wildcard 
A)  OR 
B)  Expand 
C)  AND 
D)  Wildcard

Question 16

The Find ____ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

Accepted Answer

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

Question 17

-In the accompanying figure, item 1 refers to a(n) ____.

Accepted Answer

A)  table name 
B)  field list 
C)  query design grid 
D)  one-to-many join line 
A)  table name 
B)  field list 
C)  query design grid 
D)  one-to-many join line

Question 18

The > operator means less than in a query. _________________________

Accepted Answer

A) True 
 B)False

Question 19

Which aggregate function would NOT work well on a Short Text field?

Accepted Answer

A)  Sum 
B)  Min 
C)  Max 
D)  Count 
A)  Sum 
B)  Min 
C)  Max 
D)  Count

Question 20

Match each of the following with the correct definition or statement.
-A predefined Access formula that returns a value such as a subtotal or count

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

Which function should you use to calculate today's current date?

Filtering refers to reordering records in either ascending or descending order based on the values in the field. _________________________

-In the accompanying figure, item 2 refers to a(n) ____.

SQL statements start with the FROM keyword. _________________________

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

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

-How many calculated fields are shown in the accompanying figure?

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

Which function should you use to calculate the monthly payment on a loan?

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

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

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

Explain the relationship between the Like operator and the wildcard character using an example that describes how to create criteria for all values in a CompanyName field that start with the letter J.

Multiple criteria added to the same line of the query design grid means that each must be true for the record to appear in the datasheet.

____ criteria are two or more criteria on the same Criteria row of the query design grid.

The Find ____ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

-In the accompanying figure, item 1 refers to a(n) ____.

The > operator means less than in a query. _________________________

Which aggregate function would NOT work well on a Short Text field?

Match each of the following with the correct definition or statement. -A predefined Access formula that returns a value such as a subtotal or count

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 function should you use to calculate today's current date?

Filtering refers to reordering records in either ascending or descending order based on the values in the field. _________________________

-In the accompanying figure, item 2 refers to a(n) ____.

SQL statements start with the FROM keyword. _________________________

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

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

-How many calculated fields are shown in the accompanying figure?

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

Which function should you use to calculate the monthly payment on a loan?

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

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

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

Explain the relationship between the Like operator and the wildcard character using an example that describes how to create criteria for all values in a CompanyName field that start with the letter J.

Multiple criteria added to the same line of the query design grid means that each must be true for the record to appear in the datasheet.

____ criteria are two or more criteria on the same Criteria row of the query design grid.

The Find ____ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

-In the accompanying figure, item 1 refers to a(n) ____.

The > operator means less than in a query. _________________________

Which aggregate function would NOT work well on a Short Text field?

Match each of the following with the correct definition or statement. -A predefined Access formula that returns a value such as a subtotal or count

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