Deck 15: Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Question 1

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

Answer 1

D

Question 2

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.

Answer 2

D

Question 3

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.

Answer 3

A

Question 4

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

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

Question 5

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

Question 6

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 7

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

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

Question 8

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 9

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.

Question 10

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 11

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 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

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 14

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

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

Question 15

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 16

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 17

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 18

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 19

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 20

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 21

Multiple arguments in a function are separated by:

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

Question 22

Which of the following is NOT a total row option?

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

Question 23

A ________ query has an additional row displaying aggregate data.

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

Question 24

The arguments to a function are enclosed in:

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

Question 25

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

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

Question 26

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

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

Question 27

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

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

Question 28

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

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

Question 29

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

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

Question 30

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 31

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

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

Question 32

The default option in the total row is:

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

Question 33

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

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

Question 34

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

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

Question 35

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

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

Question 36

Which of the following is NOT a Pmt function argument?

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

Question 37

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 38

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 39

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 40

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 41

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 42

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

Question 43

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

Question 44

Exponents are evaluated first according to the order of operations.

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

Calculated fields can only be displayed on a form.

Question 51

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

Question 52

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

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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 58

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

Question 59

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

Question 60

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

Question 61

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

Question 62

The MAXIMUM aggregate function can work with Short Text data.

Question 63

* is the symbol for ________.

Question 65

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

Question 66

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

Question 67

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

Question 68

PEMDAS is a mnemonic device used to remember the ________.

Question 70

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

Question 71

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

Question 73

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

Question 74

^ is the symbol for ________.

Question 75

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

Question 77

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

Question 78

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

Question 79

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