Question 1

A summary query is used to display only aggregate data when the query is run.

Accepted Answer

A) True 
 B)False

Question 2

Exponents are evaluated first according to the order of operations.

Accepted Answer

A) True 
 B)False

Question 3

The order of operations specifies that any exponents are performed first.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is NOT an Access arithmetic operator?

Accepted Answer

A)  ÷ 
B)  + 
C)  * 
D)  ^ 
A)  ÷ 
B)  + 
C)  * 
D)  ^

Question 5

Expression builder can be launched by right-clicking the cell where you want the expression, and selecting Build from the shortcut menu.

Accepted Answer

A) True 
 B)False

Question 6

A Total row in a table can include functions such as Sum, Avg, and Count.

Accepted Answer

A) True 
 B)False

Question 7

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 8

The results of PricePerRoom: [ListPrice]/([Beds]+[Baths]+3) will appear in a column with the heading ________.

Accepted Answer

A)  PricePerRoom 
B)  ListPrice 
C)  Beds 
D)  Baths 
A)  PricePerRoom 
B)  ListPrice 
C)  Beds 
D)  Baths

Question 9

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

Accepted Answer

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

Question 10

A ________ query has an additional row displaying aggregate data.

Accepted Answer

A)  digest 
B)  totals 
C)  summary 
D)  synopsis 
A)  digest 
B)  totals 
C)  summary 
D)  synopsis

Question 11

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

When a(n) ________ query is run, it contains an extra row that displays aggregate data.

Accepted Answer

A)  aggregate 
B)  totals 
C)  summary 
D)  condensed 
A)  aggregate 
B)  totals 
C)  summary 
D)  condensed

Question 14

Explain what a totals query is and the steps necessary to create one.

Accepted Answer

A totals query contains an additional ro

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

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 17

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 18

A(n) ________ displays the results of the aggregate functions as the last row in the Datasheet view.

Accepted Answer

The answer of A(n) ________ displays the results of the...

Question 19

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 20

A query with a Total row is the same as a totals query.

Accepted Answer

A) True 
 B)False

A summary query is used to display only aggregate data when the query is run.

Exponents are evaluated first according to the order of operations.

The order of operations specifies that any exponents are performed first.

Which of the following is NOT an Access arithmetic operator?

Expression builder can be launched by right-clicking the cell where you want the expression, and selecting Build from the shortcut menu.

A Total row in a table can include functions such as Sum, Avg, and Count.

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

The results of PricePerRoom: [ListPrice]/([Beds]+[Baths]+3) will appear in a column with the heading ________.

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

A ________ query has an additional row displaying aggregate data.

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

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

When a(n) ________ query is run, it contains an extra row that displays aggregate data.

Explain what a totals query is and the steps necessary to create one.

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

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

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

A(n) ________ displays the results of the aggregate functions as the last row in the Datasheet view.

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.

A query with a Total row is the same as a totals query.

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

A summary query is used to display only aggregate data when the query is run.

Exponents are evaluated first according to the order of operations.

The order of operations specifies that any exponents are performed first.

Which of the following is NOT an Access arithmetic operator?

Expression builder can be launched by right-clicking the cell where you want the expression, and selecting Build from the shortcut menu.

A Total row in a table can include functions such as Sum, Avg, and Count.

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

The results of PricePerRoom: [ListPrice]/([Beds]+[Baths]+3) will appear in a column with the heading ________.

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

A ________ query has an additional row displaying aggregate data.

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

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

When a(n) ________ query is run, it contains an extra row that displays aggregate data.

Explain what a totals query is and the steps necessary to create one.

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

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

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

A(n) ________ displays the results of the aggregate functions as the last row in the Datasheet view.

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.

A query with a Total row is the same as a totals query.

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