Question 1

Which of the following is NOT an Access arithmetic operator?

Accepted Answer

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

Question 2

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 B

Question 3

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  True

Question 4

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 { }

Question 5

When creating a calculated field using field names,Access automatically surrounds the field names with ________.

Accepted Answer

A)  braces { } 
B)  parentheses ( ) 
C)  brackets [ ] 
D)  quotation marks " " 
A)  braces { } 
B)  parentheses ( ) 
C)  brackets [ ] 
D)  quotation marks " "

Question 6

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 7

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 8

If you misspell a field name in a calculated field of a query and then run the query,Access will:

Accepted Answer

A)  display a dialog box asking for a value for the field. 
B)  substitute a zero value for the field and proceed with the calculation. 
C)  substitute a value of NULL for the field and proceed with the calculation. 
D)  stop running the query and produce no results. 
A)  display a dialog box asking for a value for the field. 
B)  substitute a zero value for the field and proceed with the calculation. 
C)  substitute a value of NULL for the field and proceed with the calculation. 
D)  stop running the query and produce no results.

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

A(n)________ function performs a calculation on an entire column and returns a single result.

Accepted Answer

A)  compound 
B)  aggregate 
C)  summary 
D)  abridged 
A)  compound 
B)  aggregate 
C)  summary 
D)  abridged

Question 11

Which of the following is NOT an aggregate function?

Accepted Answer

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

Question 12

You can use Pmt to find the future value of a mortgage.

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 15

You can use the Expression Wizard to supply fields,operators,and functions to help you create expressions.

Accepted Answer

A) True 
 B)False

Which of the following is NOT an Access arithmetic operator?

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

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

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

When creating a calculated field using field names,Access automatically surrounds the field names with ________.

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

Pmt is an example of a(n)________.

If you misspell a field name in a calculated field of a query and then run the query,Access will:

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

A(n)________ function performs a calculation on an entire column and returns a single result.

Which of the following is NOT an aggregate function?

You can use Pmt to find the future value of a mortgage.

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

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

You can use the Expression Wizard to supply fields,operators,and functions to help you create expressions.

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: 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

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

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

Exam 3: Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Which of the following is NOT an Access arithmetic operator?

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

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

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

When creating a calculated field using field names,Access automatically surrounds the field names with ________.

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

Pmt is an example of a(n)________.

If you misspell a field name in a calculated field of a query and then run the query,Access will:

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

A(n)________ function performs a calculation on an entire column and returns a single result.

Which of the following is NOT an aggregate function?

You can use Pmt to find the future value of a mortgage.

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

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

You can use the Expression Wizard to supply fields,operators,and functions to help you create expressions.

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: 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

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

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