Question 1

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

Accepted Answer

aggregate

Question 2

A(n)________ is a variable or constant that is needed to produce output for a function in a calculated field.

Accepted Answer

A) formula 
B) argument 
C) expression 
D) function 
A) formula 
B) argument 
C) expression 
D) function B

Question 3

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

Accepted Answer

A) True 
 B)False  False

Question 4

In terms of creating a calculated field in a query,define the term expression and give two examples of expression elements.

Accepted Answer

An expression is a formula used to calcu

Question 5

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 6

* is the symbol for ________.

Accepted Answer

The answer of * is the symbol for ________....

Question 7

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 8

To create a new query,click Query Design in the:

Accepted Answer

A) Insert group on the CREATE tab. 
B) Insert group on the DATABASE TOOLS tab. 
C) Queries group on the CREATE tab. 
D) Queries group on the DATABASE TOOLS tab. 
A) Insert group on the CREATE tab. 
B) Insert group on the DATABASE TOOLS tab. 
C) Queries group on the CREATE tab. 
D) Queries group on the DATABASE TOOLS tab.

Question 9

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 10

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 11

When using a datasheet,explain what an aggregate function is and identify an aggregate function and explain what it does.

Accepted Answer

An aggregate function performs calculati

Question 12

It is a good habit to use spaces in calculated field names so that it will be easier to reference these fields in other queries.

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 15

A Total row displays the results of aggregate functions as the last row in the Datasheet view.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

The Pmt function is used to ca

Question 17

The Property Sheet enables you to change settings such as number format,number of decimal places,and other settings.

Accepted Answer

A) True 
 B)False

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

Exponents are evaluated first according to the order of operations.

Accepted Answer

A) True 
 B)False

Question 20

Which aggregate function would be used to find the highest value in a column?

Accepted Answer

A) MAXIMUM 
B) MOST 
C) HIGHEST 
D) COUNT 
A) MAXIMUM 
B) MOST 
C) HIGHEST 
D) COUNT

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

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

A(n)________ is a variable or constant that is needed to produce output for a function in a calculated field.

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

In terms of creating a calculated field in a query,define the term expression and give two examples of expression elements.

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

* is the symbol for ________.

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

To create a new query,click Query Design in the:

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

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

When using a datasheet,explain what an aggregate function is and identify an aggregate function and explain what it does.

It is a good habit to use spaces in calculated field names so that it will be easier to reference these fields in other queries.

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

The Pmt function is BEST suited to determine:

A Total row displays the results of aggregate functions as the last row in the Datasheet view.

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

The Property Sheet enables you to change settings such as number format,number of decimal places,and other settings.

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

Exponents are evaluated first according to the order of operations.

Which aggregate function would be used to find the highest value in a column?

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

Word: Desktop Publishing and Graphic Design: Creating a Newsletter, working With Graphics, and Linking Objects

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

Word: Word and the Internet: Web Page Creation and Enhancement, and Blogs

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

Power: Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Specialized Functions

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

Access : Introduction to Access: Finding Your Way Through an Access Database

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

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

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

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters