Deck 3: Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Question 1

Which of the following is NOT an Expression Builder component used when constructing an expression?

A) Expression Values
B) Expression Categories
C) Expression Arguments
D) Expression Elements

Answer 1

C

Question 2

Constants that are used as arguments in expressions can be defined as ________ that do not change.

A) variables
B) objects
C) values
D) functions

Answer 2

C

Question 3

All of the following are true in reference to Expression Builder EXCEPT:

A) Expression Builder inserts placeholders that tell you where each argument belongs when you insert functions.
B) Expression Builder gives you lists of fields, operators, and functions you need to create expressions.
C) Expression Builder can only be used with user-designed functions and not with built-in functions.
D) Expression Builder can be used when working with controls in forms and reports.

Answer 3

C

Question 4

All of the following are true in reference to built-in functions EXCEPT:

A) Built-in functions can only perform calculations on numeric data.
B) A function produces a result based on variable inputs known as arguments.
C) You can use Expression Builder to find out if a built-in function exists in Access.
D) Built-in functions work the same in Access as they do in Excel.

Question 5

When designing an expression for a calculated field, field names are surrounded by:

A) parentheses.
B) brackets.
C) braces.
D) double-quotation marks.

Question 6

Following the rules for the order of operations, what is the result of the following expression: 1 + 2 * 5 ^ 2?

A) 225
B) 121
C) 101
D) 51

Question 7

Expression Builder can be opened by clicking Builder in the:

A) Query Setup group on the QUERY TOOLS DESIGN tab.
B) Query Setup group on the DATABASE TOOLS tab.
C) Analyze group on the QUERY TOOLS DESIGN tab.
D) Analyze group on the DATABASE TOOLS tab.

Question 8

When designing a calculated field, complex formulas can be created with the:

A) Table Wizard.
B) Form Wizard.
C) Expression Builder.
D) Report Builder.

Question 9

Which of the following is the correct mathematical sequence for the order of operations?

A) Multiplication, Division, Exponentiation, Addition, Subtraction
B) Exponentiation, Multiplication, Division, Addition, Subtraction
C) Multiplication, Exponentiation, Division, Addition, Subtraction
D) Addition, Subtraction, Multiplication, Exponentiation, Division

Question 10

Following the rules for the order of operations, what is the result of the following expression: (9 * 5) + 5 + 10 - 10 * 6?

A) 0
B) 25
C) 40
D) 540

Question 11

Syntax can most accurately be defined as the:

A) names of fields, controls, or properties.
B) formulas used to calculate new fields from the values in existing fields.
C) arithmetic operators such as * , / , + , or -.
D) set of language rules that Access follows when evaluating expressions.

Question 12

When viewing the results of a query, a series of ________ symbols indicates that a column is too narrow to display the complete results.

A) &
B) #
C) !
D) @

Question 13

A(n) ________ is a formula used to calculate new fields from the values in existing fields.

A) argument
B) expression
C) parameter
D) macro

Question 14

All of the following may be used in an expression EXCEPT:

A) identifiers.
B) arithmetic operators.
C) functions.
D) properties.

Question 15

A(n) ________ is a variable or constant that is needed to produce output for a function in a calculated field.

A) formula
B) argument
C) expression
D) function

Question 16

Consider the following equation: 3 * (6 + 5) - 4 / 2. Which operation would be calculated FIRST according the order of operations?

A) 3 * 6
B) 4 / 2
C) 6 + 5
D) 5 - 4

Question 17

Which of the following can be used to zoom in and see an entire calculated field expressions?

A) F2
B) Shift + F2
C) F4
D) Shift + F4

Question 18

A(n) ________ is used to change settings such as formatting and captions.

A) dialog box
B) parameter list
C) property sheet
D) argument menu

Question 19

When designing an expression for a calculated field, the name of the calculated field is followed by a(n):

A) colon.
B) exclamation point.
C) semicolon.
D) period.

Question 20

To create a new query, click Query Design in the:

A) Insert group on the CREATE tab.
B) Insert group on the DATABASE TOOLS tab.
C) Queries group on the CREATE tab.
D) Queries group on the DATABASE TOOLS tab.

Question 21

A ________ query has an additional row displaying aggregate data.

A) digest
B) totals
C) summary
D) synopsis

Question 22

Which of the following is NOT a Pmt function argument?

A) rate
B) present_value
C) future_value
D) loan_payment

Question 23

Which aggregate function would be used to find the highest value in a column?

A) MAXIMUM
B) MOST
C) HIGHEST
D) COUNT

Question 24

An expression or integer value specifying total number of payments in a loan is the ________ argument in the PMT function.

A) rate
B) num_periods
C) present_value
D) future_value

Question 25

A ________ query is used to summarize data organized by field values.

A) grouping
B) digest
C) summary
D) hierarchical

Question 26

To display the total row, you click Totals in the:

A) pmt.
B) avg.
C) count.
D) were.

Question 27

Which aggregate function would be used to find the least valued item in a column?

A) MINIMUM
B) LEAST
C) LOWEST
D) COUNT

Question 28

To display the total row, you click Totals in the:

A) Query Setup group on the DATABASE TOOLS tab.
B) Query Setup group on the QUERY TOOLS DESIGN tab.
C) Show/Hide group on the DATABASE TOOLS tab.
D) Show/Hide group on the QUERY TOOLS DESIGN tab.

Question 29

Multiple arguments in a function are separated by:

A) commas.
B) semicolons.
C) colons.
D) spaces.

Question 30

Aggregate functions are most commonly used in all of the following Access objects EXCEPT:

A) tables.
B) queries.
C) macros.
D) reports.

Question 31

Expression Builder inserts ________ that tell you where each argument belongs.

A) rows
B) fields
C) placeholders
D) columns

Question 32

When using the Pmt function, principal is another term for the ________ of a loan.

A) rate
B) duration
C) future value
D) present value

Question 33

The default option in the total row is:

A) first.
B) group By.
C) sum.
D) expression.

Question 34

The arguments to a function are enclosed in:

A) brackets.
B) parentheses.
C) braces.
D) single-quotation marks.

Question 35

The Pmt function is BEST suited to determine:

A) the rate of interest on a car loan.
B) the due date of a car loan.
C) the monthly payment on a car loan.
D) the average payment of a car loan.

Question 36

Sum, Avg, and Max are examples of ________ functions that are used to evaluate entire columns of data.

A) compound
B) aggregate
C) number
D) summary

Question 37

Which of the following aggregate functions CANNOT be used with Short Text data?

A) MINIMUM
B) AVG
C) MAXIMUM
D) COUNT

Question 38

A(n) ________ is the data used by a function to produce a result.

A) control
B) parameter
C) constraint
D) argument

Question 39

Which of the following is NOT a total row option?

A) Pmt
B) Avg
C) Count
D) Where

Question 40

Which of the following aggregate functions CANNOT be used with Data/Time data?

A) SUM
B) AVG
C) MINIMUM
D) COUNT

Question 41

The Calculated fields in Datasheet view can be edited in the same way other fields from a table are edited.

Question 42

Calculated fields can only be displayed on a form.

Question 43

You must have a query open in Design view to launch the Expression Builder.

Question 44

Expression builder can be launched by right-clicking the cell where you want the expression, and selecting Build from the shortcut menu.

Question 45

Exponents are evaluated first according to the order of operations.

Question 46

It is NOT possible to change the caption for a calculated field column heading.

Question 47

According to the order of operations, multiplication and addition are evaluated before Division and subtraction.

Question 48

The order of operations determines the sequence by which operations are calculated.

Question 49

Calculated fields are created in the Datasheet view of a table.

Question 50

Formats available on the Property Sheet vary based on the data type.

Question 51

The Pmt function returns the monthly payment due on a loan.

Question 52

Following the order of operations, 3+2*6 evaluates to 30.

Question 53

Unlike Excel, Access does not contain any built-in functions.

Question 54

The sequence which operations are performed is determined by the order of operations.

Question 55

According to the order of operations, addition and subtraction are evaluated before multiplication and division if the addition and subtraction equations are contained within parentheses

Question 56

When you use a table field in an expression, Access will automatically correct any spelling errors in the field name.

Question 57

A constant is a value that remains the same in an expression.

Question 58

Forgetting the colon between a column title and the formula would give you an invalid syntax error.

Question 59

It is a good habit to use spaces in calculated field names so that it will be easier to reference these fields in other queries.

Question 60

The Property Sheet enables you to change settings such as number format, number of decimal places, and other settings.

Question 61

PEMDAS is a mnemonic device used to remember the ________.

Question 62

The future_value argument of the Pmt Function is the amount that is being borrowed.

Question 63

Match the following terms to their meanings:
I. Aggregate function
II. Expression Builder
III. Property sheet
IV. Totals Query
V. Syntax
A. Performs calculations on a column of data and returns a single value
B. Tool used to create complicated expressions
C. Contains an additional row that displays aggregate data
D. Specifies structure and components for a calculation
E. Contains formatting information

Question 64

Sum, Count, and Avg are all examples of aggregate functions.

Question 65

The MAXIMUM aggregate function can work with Short Text data.

Question 66

The present_value argument of the Pmt Function is the amount owed after the final payment has been made.

Question 67

A query with a Total row is the same as a totals query.

Question 68

Match each mathematical symbols to the operation that is performed:
I. +
II. *
III. /
IV. ^
V. -
A. Exponentiation
B. Multiplication
C. Subtraction
D. Addition
E. Division

Question 69

Match each element of an expression with is definition:
I. Identifiers
II. Operators
III. Functions
IV. Constants
V. Variables
A. Produce results based on inputs
B. Values that do not change
C. Arithmetic instructions such as * , / , + , or -
D. Elements with a changing value
E. The names of fields, controls, or properties

Question 70

Match each aggregate function with the value it returns:
I. Avg
II. Count
III. Maximum
IV. Minimum
V. Sum
A. Returns the data item with the highest value
B. Returns the data item with the lowest value
C. Returns the mean value of a group of numbers
D. Returns the total value of a column of numbers
E. Returns the number of fields containing data

Question 71

Match the following terms to their meanings:
I. Grouping
II. Order of operations
III. Argument
IV. Total Row
V. Expression
A. Data needed to produce the output for a function
B. Consist of different elements to produce the desired output
C. Summarizes data by the values of a field
D. Determines the sequence in which calculations are performed
E. Displays results of aggregate functions in last row in a Datasheet

Question 72

A Total row displays the results of aggregate functions as the last row in the Datasheet view.

Question 73

Aggregate functions perform calculations on an entire row of data and return a single value.

Question 74

It is NOT possible to add a condition to a Totals query.

Question 75

The SUM aggregate function can work with Date/Time data.

Question 76

A summary query is used to display only aggregate data when the query is run.

Question 77

A Total row in a table can include functions such as Sum, Avg, and Count.

Question 78

^ is the symbol for ________.

Question 79

The AVG function can only be used with the Number data type.

Question 80

* is the symbol for ________.