Access Chapter 3

Question 1

Constant

Answer 1

A value that does not change.

Question 2

Expression

Answer 2

A formula used to calculate new fields form the values in existing fields.

Question 3

Order of Operations

Answer 3

Determines the sequence by which operations are calculated in an expression.

Question 4

Syntax

Answer 4

Dictates the structure and components required to perform the necessary calculations in an equation or evaluate expressions.

Question 5

Property Sheet

Answer 5

Enables you to change settings such as number format, number of decimal places, and caption.

Question 6

Expression Builder

Answer 6

An Access tool that helps you create more complicated expressions.

Question 7

Function

Answer 7

A predefined computation that performs a complex calculation. Almost 150 are built into Access.

Question 8

Argument

Answer 8

Any data needed to produce output for a function.

Question 9

Pmt Function

Answer 9

Calculates the periodic loan payment given the interest rate per period, term of the loan in months, and the original value of the loan.

Question 10

Aggregate Function

Answer 10

Performs calculations on an entire column of data and returns a single value. Includes functions such as Sum, Avg, and Count.

Question 11

Total Row

Answer 11

Displays aggregate function results as the last row in the Datasheet view of a table or query.

Question 12

Totals Query

Answer 12

Makes an additional row available in the query design grid. Used to display aggregate data when the query is run.

Question 13

Grouping

Answer 13

Allows you to summarize your data by the values of a field.

Question 14

Which of the following correctly identifies the rules for the order of operations?

Answer 14

Parentheses, exponentiation, multiplication, division, addition, subtraction

Question 15

What is the result of the following expression? (3*5)+7-2-6/2

Answer 15

17

Question 16

Which of the following cannot be adjusted in the Property Sheet?

Answer 16

Mathematical expression

Question 17

Which of the following can be adjusted in the Property Sheet?

Answer 17

• Number of decimal places.
• Caption.
• Number format (for example, currency)

Question 18

Which of the following is not an aggregate function?

Answer 18

Pmt

Question 19

Which of the following is an aggregate function?

Answer 19

• Avg
• Count
• Min

Question 20

Which of the following can be added to a totals query?

Answer 20

• Conditions
• Grouping Fields
• Aggregate Functions

Question 21

Which statement about a totals query is true?

Answer 21

A totals query may contain several grouping fields and sewerage aggregate fields.

Question 22

Which of the following statements is true?

Answer 22

A last name would be a common field to group by.

Question 23

After creating a calculated field, you run the query and a Parameter dialog box appears on your screen. How do you respond to the Parameter dialog box?

Answer 23

Look for a possible typing error in the calculated expression.

Question 24

A query contains student names. You run the query and while in Datasheet view, you notice a spelling error on one of the student’s names. You correct the error in Datasheet view. Which statement is true?

Answer 24

The name is correctly spelled in the table and in all queries based on the table.

Question 25

Which of the following about the Total row in the query design grid is false?

Answer 25

The Total row cannot be applied to numeric fields.

Question 26

Which of the following about the Total row in the query design grid is true?

Answer 26

• The Total row enables you to apply aggregate functions to the fields.
• The Total row does not display by default in all new queries.
• The Total row is located between the Table and the Sort rows.