Question 1

In the formula, =1+(2-3)+5/6-6^2, what will Access evaluate first?

Accepted Answer

A)  5/6 
B)  1+ 
C)  6^2 
D)  (2-3) 
A)  5/6 
B)  1+ 
C)  6^2 
D)  (2-3)

Question 2

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 3

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 4

For a 15-year loan paid monthly, which of the following would not be correct for the num_periods argument in the Pmt function?

Accepted Answer

A)  15 
B)  15*12 
C)  180 
D)  12*15 
A)  15 
B)  15*12 
C)  180 
D)  12*15

Question 5

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

Accepted Answer

The answer of A(n) ________ function performs a calculation on...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

It is permissible to use the percent (%) sign when entering the interest rate in the Pmt function.

Accepted Answer

A) True 
 B)False

Question 8

The ________ sheet allows you to format a field.

Accepted Answer

The answer of The ________ sheet allows you to format...

Question 9

What can the phrase "Please Excuse My Dear Aunt Sally" help you remember?

Accepted Answer

A)  The various printing options available in Excel 
B)  Naming convention for cell ranges 
C)  How to do date calculations 
D)  Order of operations 
A)  The various printing options available in Excel 
B)  Naming convention for cell ranges 
C)  How to do date calculations 
D)  Order of operations

In the formula, =1+(2-3)+5/6-6^2, what will Access evaluate first?

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

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

For a 15-year loan paid monthly, which of the following would not be correct for the num_periods argument in the Pmt function?

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

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

It is permissible to use the percent (%) sign when entering the interest rate in the Pmt function.

The ________ sheet allows you to format a field.

What can the phrase "Please Excuse My Dear Aunt Sally" help you remember?

Introduction to Access

Tables and Queries in Relational Databases

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters

Exam 3: Using Queries to Make Decisions

In the formula, =1+(2-3)+5/6-6^2, what will Access evaluate first?

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

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

For a 15-year loan paid monthly, which of the following would not be correct for the num_periods argument in the Pmt function?

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

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

It is permissible to use the percent (%) sign when entering the interest rate in the Pmt function.

The ________ sheet allows you to format a field.

What can the phrase "Please Excuse My Dear Aunt Sally" help you remember?

Introduction to Access

Tables and Queries in Relational Databases

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters