Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

When the result of a calculated field is too large to fit in a column, a series of pound signs # is displayed.

Accepted Answer

A) True 
 B)False

Question 3

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 4

When using the Pmt function, principal is another term for the ________ of a loan.

Accepted Answer

A)  rate 
B)  duration 
C)  future value 
D)  present value 
A)  rate 
B)  duration 
C)  future value 
D)  present value

Question 5

Explain what the order of operations is and why parentheses might be needed when evaluating an expression. Give a specific example of where parentheses would be need.

Accepted Answer

The order of operations specifies the se

Question 6

Following the order of operations, 3+2*6 evaluates to 30.

Accepted Answer

A) True 
 B)False

Question 7

The AVG function can only be used with the Number data type.

Accepted Answer

A) True 
 B)False

Question 8

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 9

It is NOT possible to add a condition to a Totals query.

Accepted Answer

A) True 
 B)False

Question 10

PEMDAS is a mnemonic device used to remember the ________.

Accepted Answer

The answer of PEMDAS is a mnemonic device used to...

Question 11

Forgetting the colon between a column title and the formula would give you an invalid syntax error.

Accepted Answer

A) True 
 B)False

Question 12

Pmt is an example of a(n)________.

Accepted Answer

A)  parameter 
B)  function 
C)  argument 
D)  subroutine 
A)  parameter 
B)  function 
C)  argument 
D)  subroutine

Question 13

Formats available on the Property Sheet vary based on the data type.

Accepted Answer

A) True 
 B)False

Question 14

When the results of using the COUNT or MAXIMUM aggregate functions in a query are displayed, they appear in the Total row.

Accepted Answer

A) True 
 B)False

Question 15

What is the value of =4+3*2^2?

Accepted Answer

A)  16 
B)  28 
C)  40 
D)  196 
A)  16 
B)  28 
C)  40 
D)  196

Question 16

When you use a table field in an expression, Access will automatically correct any spelling errors in the field name.

Accepted Answer

A) True 
 B)False

Question 17

When creating a calculated field, field names are enclosed in ________.

Accepted Answer

The answer of When creating a calculated field, field names...

Question 18

An expression or integer value specifying total number of payments in a loan is the ________ argument in the PMT function.

Accepted Answer

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

Question 19

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 20

When using date data, the date is surrounded by ________.

Accepted Answer

A)  parentheses ( ) 
B)  pound signs # # 
C)  brackets [ ] 
D)  braces { } 
A)  parentheses ( ) 
B)  pound signs # # 
C)  brackets [ ] 
D)  braces { }

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

When the result of a calculated field is too large to fit in a column, a series of pound signs # is displayed.

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

When using the Pmt function, principal is another term for the ________ of a loan.

Explain what the order of operations is and why parentheses might be needed when evaluating an expression. Give a specific example of where parentheses would be need.

Following the order of operations, 3+2*6 evaluates to 30.

The AVG function can only be used with the Number data type.

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

It is NOT possible to add a condition to a Totals query.

PEMDAS is a mnemonic device used to remember the ________.

Forgetting the colon between a column title and the formula would give you an invalid syntax error.

Pmt is an example of a(n)________.

Formats available on the Property Sheet vary based on the data type.

When the results of using the COUNT or MAXIMUM aggregate functions in a query are displayed, they appear in the Total row.

What is the value of =4+3*2^2?

When you use a table field in an expression, Access will automatically correct any spelling errors in the field name.

When creating a calculated field, field names are enclosed in ________.

An expression or integer value specifying total number of payments in a loan is the ________ argument in the PMT function.

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

When using date data, the date is surrounded by ________.

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

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

When the result of a calculated field is too large to fit in a column, a series of pound signs # is displayed.

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

When using the Pmt function, principal is another term for the ________ of a loan.

Explain what the order of operations is and why parentheses might be needed when evaluating an expression. Give a specific example of where parentheses would be need.

Following the order of operations, 3+2*6 evaluates to 30.

The AVG function can only be used with the Number data type.

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

It is NOT possible to add a condition to a Totals query.

PEMDAS is a mnemonic device used to remember the ________.

Forgetting the colon between a column title and the formula would give you an invalid syntax error.

Pmt is an example of a(n)________.

Formats available on the Property Sheet vary based on the data type.

When the results of using the COUNT or MAXIMUM aggregate functions in a query are displayed, they appear in the Total row.

What is the value of =4+3*2^2?

When you use a table field in an expression, Access will automatically correct any spelling errors in the field name.

When creating a calculated field, field names are enclosed in ________.

An expression or integer value specifying total number of payments in a loan is the ________ argument in the PMT function.

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

When using date data, the date is surrounded by ________.

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