Deck 3: Access: Using Queries to Make Decisions

Question 1

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

Answer 1

C

Question 2

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

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

Answer 2

D

Question 3

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

Answer 3

C

Question 4

What symbols does Access use to indicate a field name?

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

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

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 7

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 8

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 9

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 10

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

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

Question 11

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

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

Question 12

What are predefined computations that perform complex calculations?

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

Question 13

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 14

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

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

Question 15

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 16

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 17

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 18

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 19

As what does Access refer to aggregate functions?

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

Question 20

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 21

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

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

Question 22

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

Question 23

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 24

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

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

Question 25

What symbol does Access use to express exponentiation?

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

Question 26

Which of the following is not a common aggregate function?

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

Question 27

Functions generate results based on ________.

Question 28

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 29

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

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

Question 30

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

Question 31

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

Question 32

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

Question 33

________ fields can use any aggregate function.

Question 34

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)

Question 35

What is not an example of a function?

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

Question 36

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

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

Question 37

Which of the following is not an arithmetic operator?

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

Question 38

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

Question 39

Which element will you never find in a calculated field?

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

Question 40

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

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

Question 41

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

Question 42

The ________ aggregate function totals the items in a column.

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

Calculated fields must always contain at least one constant.

Question 50

Some functions have optional arguments.

Question 51

A(n)________ never changes its value.

Question 52

________ your output will make your query results more readable.

Question 53

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

Question 54

All aggregate functions can be used with any field type.

Question 55

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

Question 56

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

Question 57

The ________ sheet allows you to format a field.

Question 58

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

Question 59

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

Question 60

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

Question 61

You can add conditions to a Totals query.

Question 62

<> is an example of an argument.

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

Calculating values will help to avoid inconsistencies.

Question 70

The Expression Creator tool helps you create complex expressions.

Question 71

Access uses parenthesis ()to identify a field name.

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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 77

Access will identify logical errors in calculated fields.

Question 78

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 79

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

Question 80

You can add aggregate functions to calculated fields.