Question 1

Fields with a ________ data type can use any aggregate function.

Accepted Answer

Number,Numeric

Question 2

What sheet will allow you to change the formatting of a field in a query?

Accepted Answer

A) Formatting 
B) Modify 
C) Build 
D) Property 
A) Formatting 
B) Modify 
C) Build 
D) Property D

Question 3

An expression is a formula used in a calculated field that contains only one element.

Accepted Answer

A) True 
 B)False  False

Question 4

What is a type of field that displays the result of an expression rather than the data stored in a field?

Accepted Answer

A) Calculated 
B) Lookup 
C) AutoNumber 
D) Hyperlink 
A) Calculated 
B) Lookup 
C) AutoNumber 
D) Hyperlink

Question 5

A totals query allows you to see only the results of aggregate functions,not the detail.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is not a common mistake when creating calculated fields?

Accepted Answer

A) Forgetting the colon 
B) Putting the same field in more than once 
C) Incorrectly spelling the field names 
D) Forgetting PEMDAS 
A) Forgetting the colon 
B) Putting the same field in more than once 
C) Incorrectly spelling the field names 
D) Forgetting PEMDAS

Question 7

When creating expressions,the ________ is useful to beginning users.

Accepted Answer

The answer of When creating expressions,the ________ is useful to...

Question 8

When you want to add a condition to a Totals query,which option do you select from the Totals row list?

Accepted Answer

A) When 
B) Group 
C) Where 
D) Condition 
A) When 
B) Group 
C) Where 
D) Condition

Question 9

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 10

The Total row,when using aggregate functions,displays both the total and the individual records.

Accepted Answer

A) True 
 B)False

Question 11

What best describes the concept of syntax?

Accepted Answer

A) Predefined computation that performs a complex calculation 
B) Specific inputs used to complete the calculation 
C) Options that can be included in a function 
D) Determines the layout and order of the function and its arguments 
A) Predefined computation that performs a complex calculation 
B) Specific inputs used to complete the calculation 
C) Options that can be included in a function 
D) Determines the layout and order of the function and its arguments

Question 12

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 13

According to the order of operations,what is not calculated after exponentiation?

Accepted Answer

A) Parenthesis 
B) Multiplication 
C) Division 
D) Addition 
A) Parenthesis 
B) Multiplication 
C) Division 
D) Addition

Question 14

Match between columns
                        Premises: Bottom Center
Bottom Right
Top
Bottom Left
Expression Builder dialog box

Accepted Answer

The Answer of Expression Categories and Expression Elements and What is...

Question 15

Which of the following is not an argument used in the Pmt function?

Accepted Answer

A) Total_due 
B) Rate 
C) Future_value 
D) Type 
A) Total_due 
B) Rate 
C) Future_value 
D) Type

Question 16

When you are prompted to enter a value when you run a query which includes a calculated field,you probably ________.

Accepted Answer

A) entered too many arguments in the formula 
B) used the wrong arithmetic operator in your formula 
C) forgot to name the new,calculated field 
D) typed a field name incorrectly 
A) entered too many arguments in the formula 
B) used the wrong arithmetic operator in your formula 
C) forgot to name the new,calculated field 
D) typed a field name incorrectly

Question 17

If the arguments in a formula are in the wrong order,you will get a syntax error.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following can help you build more complex expressions in calculated fields?

Accepted Answer

A) Property sheet 
B) Design view 
C) Expression Builder 
D) Expression Creator 
A) Property sheet 
B) Design view 
C) Expression Builder 
D) Expression Creator

Question 19

You can add multiple levels of grouping to a Totals query.

Accepted Answer

A) True 
 B)False

Question 20

A(n)________ is a part of a formula that never changes its value.

Accepted Answer

The answer of A(n)________ is a part of a formula...

Fields with a ________ data type can use any aggregate function.

What sheet will allow you to change the formatting of a field in a query?

An expression is a formula used in a calculated field that contains only one element.

What is a type of field that displays the result of an expression rather than the data stored in a field?

A totals query allows you to see only the results of aggregate functions,not the detail.

Which of the following is not a common mistake when creating calculated fields?

When creating expressions,the ________ is useful to beginning users.

When you want to add a condition to a Totals query,which option do you select from the Totals row list?

What are predefined computations that perform complex calculations?

The Total row,when using aggregate functions,displays both the total and the individual records.

What best describes the concept of syntax?

What is not an example of a function?

According to the order of operations,what is not calculated after exponentiation?

Which of the following is not an argument used in the Pmt function?

When you are prompted to enter a value when you run a query which includes a calculated field,you probably ________.

If the arguments in a formula are in the wrong order,you will get a syntax error.

Which of the following can help you build more complex expressions in calculated fields?

You can add multiple levels of grouping to a Totals query.

A(n)________ is a part of a formula that never changes its value.

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters

Exam 4: Query Calculations and Expressions

Fields with a ________ data type can use any aggregate function.

What sheet will allow you to change the formatting of a field in a query?

An expression is a formula used in a calculated field that contains only one element.

What is a type of field that displays the result of an expression rather than the data stored in a field?

A totals query allows you to see only the results of aggregate functions,not the detail.

Which of the following is not a common mistake when creating calculated fields?

When creating expressions,the ________ is useful to beginning users.

When you want to add a condition to a Totals query,which option do you select from the Totals row list?

What are predefined computations that perform complex calculations?

The Total row,when using aggregate functions,displays both the total and the individual records.

What best describes the concept of syntax?

What is not an example of a function?

According to the order of operations,what is not calculated after exponentiation?

Which of the following is not an argument used in the Pmt function?

When you are prompted to enter a value when you run a query which includes a calculated field,you probably ________.

If the arguments in a formula are in the wrong order,you will get a syntax error.

Which of the following can help you build more complex expressions in calculated fields?

You can add multiple levels of grouping to a Totals query.

A(n)________ is a part of a formula that never changes its value.

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters