Deck 4: Access: Query Calculations and Expressions

Question 1

When you are prompted to enter a value when you run a query which includes a calculated field, you probably ________.

A) entered too many arguments in the formula
B) used the wrong arithmetic operator in your formula
C) forgot to name the new, calculated field
D) typed a field name incorrectly

Answer 1

D

Question 2

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

A) It can contain references to fields.
B) It is optional.
C) It reflects the total amount of a loan.
D) It returns a negative value by default.

Answer 2

B

Question 3

According to the order of operations, what is not calculated after exponentiation?

A) Parenthesis
B) Multiplication
C) Division
D) Addition

Answer 3

A

Question 4

What sheet will allow you to change the formatting of a field in a query?

A) Formatting
B) Modify
C) Build
D) Property

Question 5

Which of the following is not an advantage of using the Expression Builder?

A) It will guarantee that you do not type field names incorrectly.
B) Its size
C) Easy access to various objects
D) Placeholders

Question 6

In the formula, =1+(2-3)+5 / 6-6^2, what will Access evaluate first?

A) 5 / 6
B) 1+
C) 6^2
D) (2-3)

Question 7

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

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

Question 8

What error will you get if there is something wrong with the formula in a calculated field?

A) #NAME!
B) #FORMULA!
C) Invalid syntax
D) Invalid expression

Question 9

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

A) It assumes an annual interest rate.
B) It can contain references to fields.
C) It is optional.
D) It reflects the interest charged on a loan.

Question 10

What best describes the concept of syntax?

A) Predefined computation that performs a complex calculation
B) Specific inputs used to complete the calculation
C) Options that can be included in a function
D) Determines the layout and order of the function and its arguments

Question 11

Which of the following is not an arithmetic operator?

A) >
B) -
C) +
D) *

Question 12

Which of the following is not a common mistake when creating calculated fields?

A) Forgetting the colon
B) Putting the same field in more than once
C) Incorrectly spelling the field names
D) Forgetting PEMDAS

Question 13

In the formula, 3*[BaseSalary], the 3 is considered a(n) ________.

A) variable
B) field
C) argument
D) constant

Question 14

What symbol does Access use to express exponentiation?

A) ^
B) *
C) <>
D) ()

Question 15

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

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 16

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

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

Question 17

What symbols does Access use to indicate a field name?

A) []
B) ()
C) {}
D) ""

Question 18

What is a type of field that displays the result of an expression rather than the data stored in a field?

A) Calculated
B) Lookup
C) AutoNumber
D) Hyperlink

Question 19

What are predefined computations that perform complex calculations?

A) Formulas
B) Functions
C) Arguments
D) Expressions

Question 20

What can the phrase "Please Excuse My Dear Aunt Sally" help you remember?

A) The various printing options available in Excel
B) Naming convention for cell ranges
C) How to do date calculations
D) Order of operations

Question 21

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

Question 22

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

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 23

Which of the following is not an argument used in the Pmt function?

A) Total_due
B) Rate
C) Future_value
D) Type

Question 24

When you want to add a condition to a Totals query, which option do you select from the Totals row list?

A) When
B) Group
C) Where
D) Condition

Question 25

In the PMT function, Future_value is considered an optional argument.

Question 26

What type of query will allow you to see statistics by category?

A) Update query
B) Delete query
C) Statistical query
D) Totals query

Question 27

What allows you to summarize data by the values of a field?

A) Adding a summarizing field
B) Adding the proper calculated field
C) Adding grouping to a query
D) Adding an update field

Question 28

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

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

Question 29

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

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.

Question 30

Calculating values will help to avoid inconsistencies.

Question 31

If the arguments in a formula are in the wrong order, you will get a syntax error.

Question 32

Which of the following is not a common aggregate function?

A) Count
B) Sum
C) Lowest
D) Avg

Question 33

Access uses parenthesis () to identify a field name.

Question 34

Another name for an input in a function is a(n) ________.

A) Argument
B) Property
C) Value
D) Expression

Question 35

Calculated fields must always contain at least one constant.

Question 36

Access will identify logical errors in calculated fields.

Question 37

Access refers to ________ as aggregate functions.

A) Sums
B) Complex functions
C) Whole Column functions
D) Totals

Question 38

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

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

Question 39

Two good ways to test the results of a calculated field is to use a calculator or Excel.

Question 40

What is not an example of a function?

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

Question 41

You can add multiple levels of grouping to a Totals query.

Question 42

You can add aggregate functions to calculated fields.

Question 43

If you are not using a totals query, then you must display the Totals row in a query if you want to use aggregate functions.

Question 44

If you want to see the results of several aggregate functions for one field, you would add the field in the Totals query several times.

Question 45

<> is an example of an argument.

Question 46

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

Question 47

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

Question 48

You can add conditions to a Totals query.

Question 49

Some functions have optional arguments.

Question 50

Access will always give you step-by-step instructions to help you fix errors in formulas.

Question 51

You can enter an expression in the Expression Builder by either typing the expression manually or by right-clicking the expression.

Question 52

An expression is a formula used in a calculated field that contains only one element.

Question 53

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

Question 54

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

Question 55

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

Question 56

A function is a predefined computation that is used for simple calculations.

Question 57

The Expression Builder tool helps you create complex expressions.

Question 58

A combination of elements that produce a value is known as a(n) ________.

Question 59

All aggregate functions can be used with any field type.

Question 60

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

Question 61

When you add ________ to a query you can summarize data by fields.

Question 62

The ________ sheet allows you to format a field.

Question 63

A(n) ________ query has an additional row which is used to display aggregate data.

Question 64

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

Question 65

If the formula, 3*[Bonus], the 3 is considered a(n) ________.

Question 66

When creating a calculated field a(n) ________ is entered after the field name.

Question 67

If you type the name of a calculated field incorrectly you will get an invalid ________ error.

Question 68

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

Question 69

Fields with a ________ data type can use any aggregate function.

Question 70

Sometimes it is best to verify calculations by using a(n) ________ on a few records.

Question 71

The ________ aggregate function totals the items in a column.

Question 72

The Property Sheet in a query is very similar to the ________ properties in a table.

Question 73

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

Question 74

Match the following terms with their description:
I. Argument
II. Expression
III. Grouping
IV. Function
V. Constant
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 75

If you wanted to find the youngest person in your table, you would use the ________ function in a calculated field.

Question 76

Functions generate results based on ________.

Question 77

Using the Expression Builder can help you avoid ________ errors in field names.

Question 78

When creating expressions, the ________ is useful to beginning users.

Question 79

A(n) ________ function performs a calculation on an entire column of data and returns a single value.

Question 80

If you wanted to find out how many people are going on a trip you would use the ________ function in a calculated field.