Question 1

Which of the following aggregate functions CANNOT be used with Data/Time data?

Accepted Answer

A)  SUM 
B)  AVG 
C)  MINIMUM 
D)  COUNT 
A)  SUM 
B)  AVG 
C)  MINIMUM 
D)  COUNT

Question 2

A ________ query is used to summarize data organized by field values.

Accepted Answer

A)  grouping 
B)  digest 
C)  summary 
D)  hierarchical 
A)  grouping 
B)  digest 
C)  summary 
D)  hierarchical

Question 3

Match between columns
                        Premises: Total Row
Order of operations
Grouping
Argument
Expression

Accepted Answer

The Answer of Consist of different elements to produce the is...

Question 4

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 5

Which of the following aggregate functions CANNOT be used with Short Text data?

Accepted Answer

A)  MINIMUM 
B)  AVG 
C)  MAXIMUM 
D)  COUNT 
A)  MINIMUM 
B)  AVG 
C)  MAXIMUM 
D)  COUNT

Question 6

The present_value argument of the Pmt Function is the amount owed after the final payment has been made.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following can be used to zoom in and see an entire calculated field expressions?

Accepted Answer

A)  F2 
B)  Shift + F2 
C)  F4 
D)  Shift + F4 
A)  F2 
B)  Shift + F2 
C)  F4 
D)  Shift + F4

Question 8

Explain what the Expression builder is,and how it is used.

Accepted Answer

The Expression Builder tool is used to c

Question 9

A(n)________ contains an additional row in the query design grid and displays aggregate data when the query is run.

Accepted Answer

The answer of A(n)________ contains an additional row in the...

Question 10

All of the following are true in reference to built-in functions EXCEPT:

Accepted Answer

A)  Built-in functions can only perform calculations on numeric data. 
B)  A function produces a result based on variable inputs known as arguments. 
C)  You can use Expression Builder to find out if a built-in function exists in Access. 
D)  Built-in functions work the same in Access as they do in Excel. 
A)  Built-in functions can only perform calculations on numeric data. 
B)  A function produces a result based on variable inputs known as arguments. 
C)  You can use Expression Builder to find out if a built-in function exists in Access. 
D)  Built-in functions work the same in Access as they do in Excel.

Question 11

A(n)________ is a predefined computation that performs complicated calculations.

Accepted Answer

The answer of A(n)________ is a predefined computation that performs...

Question 12

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 13

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 14

To create complicated expressions,you would use the ________ tool.

Accepted Answer

The answer of To create complicated expressions,you would use the...

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Unlike Excel,Access does not contain any built-in functions.

Accepted Answer

A) True 
 B)False

Question 17

The MAXIMUM aggregate function can work with Short Text data.

Accepted Answer

A) True 
 B)False

Question 18

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 19

Expression Builder inserts ________ that tell you where each argument belongs.

Accepted Answer

A)  rows 
B)  fields 
C)  placeholders 
D)  columns 
A)  rows 
B)  fields 
C)  placeholders 
D)  columns

Question 20

Function arguments are enclosed in ________.

Accepted Answer

The answer of Function arguments are enclosed in ________....

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

Which of the following aggregate functions CANNOT be used with Data/Time data?

A ________ query is used to summarize data organized by field values.

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

Which of the following aggregate functions CANNOT be used with Short Text data?

The present_value argument of the Pmt Function is the amount owed after the final payment has been made.

Which of the following can be used to zoom in and see an entire calculated field expressions?

Explain what the Expression builder is,and how it is used.

A(n)________ contains an additional row in the query design grid and displays aggregate data when the query is run.

All of the following are true in reference to built-in functions EXCEPT:

A(n)________ is a predefined computation that performs complicated calculations.

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

The Pmt function is BEST suited to determine:

To create complicated expressions,you would use the ________ tool.

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

Unlike Excel,Access does not contain any built-in functions.

The MAXIMUM aggregate function can work with Short Text data.

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

Expression Builder inserts ________ that tell you where each argument belongs.

Function arguments 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