Question 1

Which of the following is NOT an Expression Builder component used when constructing an expression?

Accepted Answer

A)  Expression Values 
B)  Expression Categories 
C)  Expression Arguments 
D)  Expression Elements 
A)  Expression Values 
B)  Expression Categories 
C)  Expression Arguments 
D)  Expression Elements

Question 2

Syntax can most accurately be defined as the:

Accepted Answer

A)  names of fields, controls, or properties. 
B)  formulas used to calculate new fields from the values in existing fields. 
C)  arithmetic operators such as * , / , + , or -. 
D)  set of language rules that Access follows when evaluating expressions. 
A)  names of fields, controls, or properties. 
B)  formulas used to calculate new fields from the values in existing fields. 
C)  arithmetic operators such as * , / , + , or -. 
D)  set of language rules that Access follows when evaluating expressions.

Question 3

Following the rules for the order of operations,what is the result of the following expression: 1 + 2 * 5 ^ 2?

Accepted Answer

A)  225 
B)  121 
C)  101 
D)  51 
A)  225 
B)  121 
C)  101 
D)  51

Question 4

It is NOT possible to change the caption for a calculated field column heading.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A)  Query Setup group on the DATABASE TOOLS tab. 
B)  Query Setup group on the QUERY TOOLS DESIGN tab. 
C)  Show/Hide group on the DATABASE TOOLS tab. 
D)  Show/Hide group on the QUERY TOOLS DESIGN tab. 
A)  Query Setup group on the DATABASE TOOLS tab. 
B)  Query Setup group on the QUERY TOOLS DESIGN tab. 
C)  Show/Hide group on the DATABASE TOOLS tab. 
D)  Show/Hide group on the QUERY TOOLS DESIGN tab.

Question 6

When using Expression Builder,you can ________ an item in the Expression Categories or Expression Values sections to automatically add it to the expression box.

Accepted Answer

The answer of When using Expression Builder,you can ________ an...

Question 7

Aggregate functions perform calculations on an entire row of data and return a single value.

Accepted Answer

A) True 
 B)False

Question 8

Calculated fields are created in the Datasheet view of a table.

Accepted Answer

A) True 
 B)False

Question 9

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 10

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

Question 11

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 12

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 13

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 14

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

Accepted Answer

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

Question 15

Which of the following is NOT a Pmt function argument?

Accepted Answer

A)  rate 
B)  present_value 
C)  future_value 
D)  loan_payment 
A)  rate 
B)  present_value 
C)  future_value 
D)  loan_payment

Question 16

Sum,Avg,and Max are examples of ________ functions that are used to evaluate entire columns of data.

Accepted Answer

A)  compound 
B)  aggregate 
C)  number 
D)  summary 
A)  compound 
B)  aggregate 
C)  number 
D)  summary

Question 17

The sequence which operations are performed is determined by the order of operations.

Accepted Answer

A) True 
 B)False

Question 18

Expression Builder can be opened by clicking Builder in the:

Accepted Answer

A)  Query Setup group on the QUERY TOOLS DESIGN tab. 
B)  Query Setup group on the DATABASE TOOLS tab. 
C)  Analyze group on the QUERY TOOLS DESIGN tab. 
D)  Analyze group on the DATABASE TOOLS tab. 
A)  Query Setup group on the QUERY TOOLS DESIGN tab. 
B)  Query Setup group on the DATABASE TOOLS tab. 
C)  Analyze group on the QUERY TOOLS DESIGN tab. 
D)  Analyze group on the DATABASE TOOLS tab.

Question 19

Multiple arguments in a function are separated by:

Accepted Answer

A)  commas. 
B)  semicolons. 
C)  colons. 
D)  spaces. 
A)  commas. 
B)  semicolons. 
C)  colons. 
D)  spaces.

Question 20

The arguments to a function are enclosed in:

Accepted Answer

A)  brackets. 
B)  parentheses. 
C)  braces. 
D)  single-quotation marks. 
A)  brackets. 
B)  parentheses. 
C)  braces. 
D)  single-quotation marks.

Exam 15: Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Which of the following is NOT an Expression Builder component used when constructing an expression?

Syntax can most accurately be defined as the:

Following the rules for the order of operations,what is the result of the following expression: 1 + 2 * 5 ^ 2?

It is NOT possible to change the caption for a calculated field column heading.

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

When using Expression Builder,you can ________ an item in the Expression Categories or Expression Values sections to automatically add it to the expression box.

Aggregate functions perform calculations on an entire row of data and return a single value.

Calculated fields are created in the Datasheet view of a table.

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

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

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

The default option in the total row is:

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

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

Which of the following is NOT a Pmt function argument?

Sum,Avg,and Max are examples of ________ functions that are used to evaluate entire columns of data.

The sequence which operations are performed is determined by the order of operations.

Expression Builder can be opened by clicking Builder in the:

Multiple arguments in a function are separated by:

The arguments to a function are enclosed in:

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

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 SQL in Access: Advanced Techniques

Filters