Question 1

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

Accepted Answer

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

Question 2

Following the rules for the order of operations, what is the result of the following expression: (9 * 5) + 5 + 10 - 10 * 6?

Accepted Answer

A)  0 
B)  25 
C)  40 
D)  540 
A)  0 
B)  25 
C)  40 
D)  540

Question 3

Explain how the Pmt function is used and identify two of its required arguments.

Accepted Answer

The Pmt function is used to ca

Question 4

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

Accepted Answer

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

Question 5

The Pmt function is BEST suited to determine:

Accepted Answer

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

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

Accepted Answer

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

Question 7

A(n) ________ is used to change settings such as formatting and captions.

Accepted Answer

A)  dialog box 
B)  parameter list 
C)  property sheet 
D)  argument menu 
A)  dialog box 
B)  parameter list 
C)  property sheet 
D)  argument menu

Question 8

Sum, Avg, and Count are examples of ________ functions.

Accepted Answer

The answer of Sum, Avg, and Count are examples of...

Question 9

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

Accepted Answer

The answer of A(n) ________ function performs a calculation on...

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

The default option in the total row is:

Accepted Answer

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

Question 12

When using Design view, you click Totals in the ________ group on the QUERY TOOLS DESIGN tab to display the total row.

Accepted Answer

The answer of When using Design view, you click Totals...

Question 13

When designing a calculated field, complex formulas can be created with the:

Accepted Answer

A)  Table Wizard. 
B)  Form Wizard. 
C)  Expression Builder. 
D)  Report Builder. 
A)  Table Wizard. 
B)  Form Wizard. 
C)  Expression Builder. 
D)  Report Builder.

Question 14

When designing an expression for a calculated field, the name of the calculated field is followed by a(n):

Accepted Answer

A)  colon. 
B)  exclamation point. 
C)  semicolon. 
D)  period. 
A)  colon. 
B)  exclamation point. 
C)  semicolon. 
D)  period.

Question 15

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

Accepted Answer

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

Question 16

All of the following are true in reference to Expression Builder EXCEPT:

Accepted Answer

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

Match each mathematical symbols to the operation that is performed:
I. +
II. *
III. /
IV. ^
V. -
A. Exponentiation
B. Multiplication
C. Subtraction
D. Addition
E. Division

Accepted Answer

The answer of Match each mathematical symbols to the operation...

Question 18

Constants that are used as arguments in expressions can be defined as ________ that do not change.

Accepted Answer

A)  variables 
B)  objects 
C)  values 
D)  functions 
A)  variables 
B)  objects 
C)  values 
D)  functions

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

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

Following the rules for the order of operations, what is the result of the following expression: (9 * 5) + 5 + 10 - 10 * 6?

Explain how the Pmt function is used and identify two of its required arguments.

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

The Pmt function is BEST suited to determine:

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

A(n) ________ is used to change settings such as formatting and captions.

Sum, Avg, and Count are examples of ________ functions.

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

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

The default option in the total row is:

When using Design view, you click Totals in the ________ group on the QUERY TOOLS DESIGN tab to display the total row.

When designing a calculated field, complex formulas can be created with the:

When designing an expression for a calculated field, the name of the calculated field is followed by a(n):

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

All of the following are true in reference to Expression Builder EXCEPT:

Match each mathematical symbols to the operation that is performed: I. + II. * III. / IV. ^ V. - A. Exponentiation B. Multiplication C. Subtraction D. Addition E. Division

Constants that are used as arguments in expressions can be defined as ________ that do not change.

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

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

Introduction to Access: Finding Your Way Through an Access Database

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters

Exam 3: Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

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

Following the rules for the order of operations, what is the result of the following expression: (9 * 5) + 5 + 10 - 10 * 6?

Explain how the Pmt function is used and identify two of its required arguments.

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

The Pmt function is BEST suited to determine:

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

A(n) ________ is used to change settings such as formatting and captions.

Sum, Avg, and Count are examples of ________ functions.

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

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

The default option in the total row is:

When using Design view, you click Totals in the ________ group on the QUERY TOOLS DESIGN tab to display the total row.

When designing a calculated field, complex formulas can be created with the:

When designing an expression for a calculated field, the name of the calculated field is followed by a(n):

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

All of the following are true in reference to Expression Builder EXCEPT:

Match each mathematical symbols to the operation that is performed: I. + II. * III. / IV. ^ V. - A. Exponentiation B. Multiplication C. Subtraction D. Addition E. Division

Constants that are used as arguments in expressions can be defined as ________ that do not change.

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

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

Introduction to Access: Finding Your Way Through an Access Database

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters