Question 1

Calculated fields must always contain at least one constant.

Accepted Answer

A) True 
 B)False  False

Question 2

Access will calculate exactly what you tell it to calculate, even if you make logical errors in the calculation.

Accepted Answer

A) True 
 B)False  True

Question 3

Where does the Total row of an aggregate function display its results?

Accepted Answer

A)  Last row in Datasheet view 
B)  First row in Datasheet view 
C)  Only row in Datasheet view 
D)  It does not display in Datasheet view. 
A)  Last row in Datasheet view 
B)  First row in Datasheet view 
C)  Only row in Datasheet view 
D)  It does not display in Datasheet view. A

Question 4

Unless you add a minus sign, the Pmt function by default returns a(n) ________ value.

Accepted Answer

The answer of Unless you add a minus sign, the...

Question 5

Match the following terms with their description:
i. Total row
II. Totals query
III. Property Sheet
IV. Expression Builder
v. Aggregate function

Accepted Answer

A)  Calculation performed on a column and returns one value 
B)  Way to display aggregate function results when a query is run 
C)  Tool to create complicated expressions 
D)  Where you can change the number of decimals 
E)  Displays aggregate function results as the last row in a table or query 
A)  Calculation performed on a column and returns one value 
B)  Way to display aggregate function results when a query is run 
C)  Tool to create complicated expressions 
D)  Where you can change the number of decimals 
E)  Displays aggregate function results as the last row in a table or query

Question 6

The Total row, when using aggregate functions, displays both the total and the individual records.

Accepted Answer

A) True 
 B)False

Question 7

In the PMT function, what is not true about the type argument?

Accepted Answer

A)  It is often filled in with zero. 
B)  It is often left blank. 
C)  It is required. 
D)  It is optional. 
A)  It is often filled in with zero. 
B)  It is often left blank. 
C)  It is required. 
D)  It is optional.

Question 8

A totals query allows you to see only the results of aggregate functions, not the detail.

Accepted Answer

A) True 
 B)False

Question 9

The rate argument in the Pmt function always uses the annual rate.

Accepted Answer

A) True 
 B)False

Question 10

A calculated field displays the results of an expression in contrast to other data which is stored directly in a(n) ________.

Accepted Answer

The answer of A calculated field displays the results of...

Question 11

Which of the following can help you build more complex expressions in calculated fields?

Accepted Answer

A)  Property sheet 
B)  Design view 
C)  Expression Builder 
D)  Expression Creator 
A)  Property sheet 
B)  Design view 
C)  Expression Builder 
D)  Expression Creator

Question 12

Match the following terms with their description:
i. Argument
II. Expression
III. Grouping
IV. Function
v. Constant

Accepted Answer

A)  Combination of elements that produce a value 
B)  Value that does not change 
C)  Input used in a function 
D)  Predefined computation 
E)  Method of summarizing data 
A)  Combination of elements that produce a value 
B)  Value that does not change 
C)  Input used in a function 
D)  Predefined computation 
E)  Method of summarizing data

Question 13

For a 15-year loan paid monthly, which of the following would not be correct for the num_periods argument in the Pmt function?

Accepted Answer

A)  15 
B)  15*12 
C)  180 
D)  12*15 
A)  15 
B)  15*12 
C)  180 
D)  12*15

Question 14

In the PMT function, what is not true about the Num_periods argument?

Accepted Answer

A)  It reflects a count of how many times payments will be made. 
B)  It can contain references to fields. 
C)  You must use constants for this argument. 
D)  It is required. 
A)  It reflects a count of how many times payments will be made. 
B)  It can contain references to fields. 
C)  You must use constants for this argument. 
D)  It is required.

Question 15

It is permissible to use the percent (%) sign when entering the interest rate in the Pmt function.

Accepted Answer

A) True 
 B)False

Question 16

The ________ aggregate function returns the value with the highest value.

Accepted Answer

The answer of The ________ aggregate function returns the value...

Question 17

What punctuation do you use to separate the arguments in a function?

Accepted Answer

A)  (;) 
B)  (,) 
C)  (:) 
D)  ")" 
A)  (;) 
B)  (,) 
C)  (:) 
D)  ")"

Question 18

A(n) ________ is a part of a formula that never changes its value.

Accepted Answer

The answer of A(n) ________ is a part of a...

Question 19

What is not a necessary piece of data needed for the Pmt function?

Accepted Answer

A)  Interest rate 
B)  Amount already paid on the loan 
C)  Amount of the loan 
D)  Number of periods required to pay off the loan 
A)  Interest rate 
B)  Amount already paid on the loan 
C)  Amount of the loan 
D)  Number of periods required to pay off the loan

Question 20

What is not an example of a function?

Accepted Answer

A)  =RATE 
B)  =PV 
C)  =PMT 
D)  =15*21 
A)  =RATE 
B)  =PV 
C)  =PMT 
D)  =15*21

Calculated fields must always contain at least one constant.

Access will calculate exactly what you tell it to calculate, even if you make logical errors in the calculation.

Where does the Total row of an aggregate function display its results?

Unless you add a minus sign, the Pmt function by default returns a(n) ________ value.

Match the following terms with their description: i. Total row II. Totals query III. Property Sheet IV. Expression Builder v. Aggregate function

The Total row, when using aggregate functions, displays both the total and the individual records.

In the PMT function, what is not true about the type argument?

A totals query allows you to see only the results of aggregate functions, not the detail.

The rate argument in the Pmt function always uses the annual rate.

A calculated field displays the results of an expression in contrast to other data which is stored directly in a(n) ________.

Which of the following can help you build more complex expressions in calculated fields?

Match the following terms with their description: i. Argument II. Expression III. Grouping IV. Function v. Constant

For a 15-year loan paid monthly, which of the following would not be correct for the num_periods argument in the Pmt function?

In the PMT function, what is not true about the Num_periods argument?

It is permissible to use the percent (%) sign when entering the interest rate in the Pmt function.

The ________ aggregate function returns the value with the highest value.

What punctuation do you use to separate the arguments in a function?

A(n) ________ is a part of a formula that never changes its value.

What is not a necessary piece of data needed for the Pmt function?

What is not an example of a function?

Common Features

Access: Introduction to Powerpoint

Access: Tables and Queries in Relational Databases

Access: Basic Forms and Reports

Excell: Introduction to Excel

Excell: Formulas and Functions

Excell: Charts

Excell: Datasets and Tables

Powerpoint: Introduction to Powerpoint

Powerpoint: Effective Presentation Development

Powerpoint: Presentation Enhancement

Powerpoint: Presentation Refinement

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Research and Collaboration

Filters

Exam 4: Access: Query Calculations and Expressions

Calculated fields must always contain at least one constant.

Access will calculate exactly what you tell it to calculate, even if you make logical errors in the calculation.

Where does the Total row of an aggregate function display its results?

Unless you add a minus sign, the Pmt function by default returns a(n) ________ value.

Match the following terms with their description: i. Total row II. Totals query III. Property Sheet IV. Expression Builder v. Aggregate function

The Total row, when using aggregate functions, displays both the total and the individual records.

In the PMT function, what is not true about the type argument?

A totals query allows you to see only the results of aggregate functions, not the detail.

The rate argument in the Pmt function always uses the annual rate.

A calculated field displays the results of an expression in contrast to other data which is stored directly in a(n) ________.

Which of the following can help you build more complex expressions in calculated fields?

Match the following terms with their description: i. Argument II. Expression III. Grouping IV. Function v. Constant

For a 15-year loan paid monthly, which of the following would not be correct for the num_periods argument in the Pmt function?

In the PMT function, what is not true about the Num_periods argument?

It is permissible to use the percent (%) sign when entering the interest rate in the Pmt function.

The ________ aggregate function returns the value with the highest value.

What punctuation do you use to separate the arguments in a function?

A(n) ________ is a part of a formula that never changes its value.

What is not a necessary piece of data needed for the Pmt function?

What is not an example of a function?

Common Features

Access: Introduction to Powerpoint

Access: Tables and Queries in Relational Databases

Access: Basic Forms and Reports

Excell: Introduction to Excel

Excell: Formulas and Functions

Excell: Charts

Excell: Datasets and Tables

Powerpoint: Introduction to Powerpoint

Powerpoint: Effective Presentation Development

Powerpoint: Presentation Enhancement

Powerpoint: Presentation Refinement

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Research and Collaboration

Filters