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

Question 1

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.

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

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

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

Answer 3

B

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

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 6

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 7

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 8

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

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

Question 9

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 10

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 11

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 12

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

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

Question 13

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 14

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 15

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 16

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 17

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

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 21

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

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

Question 22

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

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

Question 23

A ________ query has an additional row displaying aggregate data.

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

Question 24

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 25

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 26

Multiple arguments in a function are separated by:

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

Question 27

The default option in the total row is:

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

Question 28

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

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

Question 29

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

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

Question 30

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

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

Question 31

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 32

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

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

Question 33

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

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

Question 34

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

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

Question 35

The arguments to a function are enclosed in:

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

Question 36

Which of the following is NOT a total row option?

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

Question 37

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 38

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

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

Question 39

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 40

Which of the following is NOT a Pmt function argument?

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

Question 41

Calculated fields can only be displayed on a form.

Question 42

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

Question 43

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

Question 44

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

Question 45

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 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

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

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

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

Question 57

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

Question 58

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 59

Exponents are evaluated first according to the order of operations.

Question 60

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

Question 61

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

Question 62

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

Question 63

The MAXIMUM aggregate function can work with Short Text data.

Question 64

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

Question 65

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

Question 66

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

Question 67

^ is the symbol for ________.

Question 68

PEMDAS is a mnemonic device used to remember the ________.

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

* is the symbol for ________.

Question 75

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

Question 76

Explain what a totals query is and the steps necessary to create one.

Question 77

Function arguments are separated by ________.

Question 78

A(n)________ is a predefined computation that performs complicated calculations.

Question 79

To change a field's caption or the number of decimal places,you would use its ________.

Question 80

The ________ aggregate functions return the item with the lowest value.