Deck 3: Using Queries to Make Decisions

Question 1

What can help you build more complex expressions in calculated fields?

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

Answer 1

C

Question 2

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

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

Answer 2

C

Question 3

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

Answer 3

C

Question 4

When creating a calculated field in a query, what common error will not give you a direct indication that there is a problem?

A) Misspelling the field name
B) Forgetting the order of operations
C) Forgetting the colon
D) Misspelling the name of a field within the calculated field

Question 5

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 6

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

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

Question 7

Which element will you never find in a calculated field?

A) Arithmetic operator
B) Constant
C) Function
D) Macro

Question 8

What value will Access calculate from the following formula: =1+(2-3)+5/6-6^2?

A) 16
B) 26.69
C) -35.2
D) -.17

Question 9

What result would be generated by the formula =10*2-3*2?

A) 34
B) -20
C) 14
D) -2

Question 10

What button do you click to see the results of a query?

A) Go
B) Query
C) View
D) Run

Question 11

Which of the following is not an arithmetic operator?

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

Question 12

What symbol does Access use to express exponentiation?

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

Question 13

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

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

Question 14

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 15

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 16

When you run a query, what is the default view?

A) Design
B) Datasheet
C) Layout
D) Form

Question 17

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

Question 18

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 19

What symbols does Access use to indicate a field name?

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

Question 20

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

A) Forgetting the colon
B) Using the wrong fields
C) Incorrectly spelled field names
D) Forgetting PEMDAS

Question 21

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

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

Question 22

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 23

________ your output will make your query results more readable.

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

A(n) ________ never changes its value.

Question 26

What is not an example of a function?

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

Question 27

Which of the following is not a common aggregate function?

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

Question 28

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

A calculated field has a(n) ________ after the field name.

Question 31

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

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

Question 32

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

Question 33

The ________ sheet allows you to format a field.

Question 34

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 35

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 36

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

Question 37

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

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

Question 38

What are predefined computations that perform complex calculations?

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

Question 39

As what does Access refer to aggregate functions?

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

Question 40

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

Question 41

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

Question 42

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

Question 43

The ________ aggregate function totals the items in a column.

Question 44

Functions generate results based on ________.

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

The Zoom window allows you to see the entire contents of a cell.

Question 51

Calculating values will help to avoid inconsistencies.

Question 52

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

Question 53

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

Question 54

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

Question 55

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

Question 56

Calculated fields must always contain at least one constant.

Question 57

________ fields can use any aggregate function.

Question 58

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

Question 59

Access uses parenthesis () to identify a field name.

Question 60

Having the user input the values directly is the best way to ensure that errors will not be included in the data.

Question 61

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

Question 62

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

Question 63

Access will identify logical errors in calculated fields.

Question 64

All aggregate functions can be used with any field type.

Question 65

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

Question 66

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

Question 67

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 68

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

Question 69

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 70

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

Question 71

You can add conditions to a Totals query.

Question 72

You can add aggregate functions to calculated fields.

Question 73

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

Question 74

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

Question 75

The Expression Creator tool helps you create complex expressions.

Question 76

Some functions have optional arguments.

Question 77

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

Question 78

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

Question 79

It is useful, at times, to add the same field to a query several times.

Question 80

<> is an example of an argument.