Question 1

What allows you to summarize data by the values of a field?

Accepted Answer

A)  Adding a summarizing field 
B)  Adding the proper calculated field 
C)  Adding grouping to a query 
D)  Adding an update field 
A)  Adding a summarizing field 
B)  Adding the proper calculated field 
C)  Adding grouping to a query 
D)  Adding an update field

Question 2

Which of the following is not an arithmetic operator?

Accepted Answer

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

Question 3

A(n) ________ never changes its value.

Accepted Answer

The answer of A(n) ________ never changes its value....

Question 4

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

Accepted Answer

The answer of When you add ________ to a query...

Question 5

Match the following terms with their description:
I. Argument
II. Expression
III. Grouping
IV. Function
V. Constant
A. Combination of elements that produce a value
B. Value that does not change
C. Input used in a function
D. Predefined computation
E. Method of summarizing data

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 6

The ________ aggregate function totals the items in a column.

Accepted Answer

The answer of The ________ aggregate function totals the items...

Question 7

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

Accepted Answer

The answer of A calculated field displays the results of...

Question 8

The Expression Creator tool helps you create complex expressions.

Accepted Answer

A) True 
 B)False

Question 9

Match the following formatting options with their examples:
I. Long Date
II. Medium Date
III. Short Date
IV. Long Time
V. Medium Time
A. 12/26/1959
B. 26-Dec-59
C. Saturday, December 26, 1959
D. 3:03
E. 3:03:03 PM

Accepted Answer

The answer of Match the following formatting options with their...

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Match the following mathematical terms with how they are displayed in Access:
I. Parenthesis
II. Exponentiation
III. Division
IV. Multiplication
V. Subtraction
A. /
B. -
C. ^
D. *
E. ()

Accepted Answer

The answer of Match the following mathematical terms with how...

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Match the following terms with their description:
I. Total row
II. Totals query
III. Property Sheet
IV. Expression Builder
V. Aggregate function
A. Calculation performed on a column and returns one value
B. Way to display aggregate function results when a query is run
C. Tool to create complicated expressions
D. Where you can change the number of decimals
E. Displays aggregate function results as the last row in a table or query

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

As what does Access refer to aggregate functions?

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

What is not an example of a function?

Accepted Answer

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

What are predefined computations that perform complex calculations?

Accepted Answer

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

Question 20

Match the following terms with their examples:
I. Formula
II. Function
III. Argument
IV. Expression
V. Constant
A. 58
B. =9*2
C. (rate, num_periods, present_value, future_value, type)
D. >
E. =Sum

Accepted Answer

The answer of Match the following terms with their examples:
I....

What allows you to summarize data by the values of a field?

Which of the following is not an arithmetic operator?

A(n) ________ never changes its value.

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

Match the following terms with their description: I. Argument II. Expression III. Grouping IV. Function V. Constant A. Combination of elements that produce a value B. Value that does not change C. Input used in a function D. Predefined computation E. Method of summarizing data

The ________ aggregate function totals the items in a column.

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

The Expression Creator tool helps you create complex expressions.

Match the following formatting options with their examples: I. Long Date II. Medium Date III. Short Date IV. Long Time V. Medium Time A. 12/26/1959 B. 26-Dec-59 C. Saturday, December 26, 1959 D. 3:03 E. 3:03:03 PM

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

Match the following mathematical terms with how they are displayed in Access: I. Parenthesis II. Exponentiation III. Division IV. Multiplication V. Subtraction A. / B. - C. ^ D. * E. ()

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

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

As what does Access refer to aggregate functions?

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

What is not an example of a function?

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

What are predefined computations that perform complex calculations?

Match the following terms with their examples: I. Formula II. Function III. Argument IV. Expression V. Constant A. 58 B. =9*2 C. (rate, num_periods, present_value, future_value, type) D. <> E. =Sum

Introduction to Access

Tables and Queries in Relational Databases

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters

Exam 3: Using Queries to Make Decisions

What allows you to summarize data by the values of a field?

Which of the following is not an arithmetic operator?

A(n) ________ never changes its value.

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

Match the following terms with their description: I. Argument II. Expression III. Grouping IV. Function V. Constant A. Combination of elements that produce a value B. Value that does not change C. Input used in a function D. Predefined computation E. Method of summarizing data

The ________ aggregate function totals the items in a column.

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

The Expression Creator tool helps you create complex expressions.

Match the following formatting options with their examples: I. Long Date II. Medium Date III. Short Date IV. Long Time V. Medium Time A. 12/26/1959 B. 26-Dec-59 C. Saturday, December 26, 1959 D. 3:03 E. 3:03:03 PM

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

Match the following mathematical terms with how they are displayed in Access: I. Parenthesis II. Exponentiation III. Division IV. Multiplication V. Subtraction A. / B. - C. ^ D. * E. ()

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

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

As what does Access refer to aggregate functions?

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

What is not an example of a function?

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

What are predefined computations that perform complex calculations?

Match the following terms with their examples: I. Formula II. Function III. Argument IV. Expression V. Constant A. 58 B. =9*2 C. (rate, num_periods, present_value, future_value, type) D. <> E. =Sum

Introduction to Access

Tables and Queries in Relational Databases

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters