Question 1

Creating spaces in the names of calculated fields is recommended because these fields are easier to reference in queries.

Accepted Answer

A) True 
 B)False  False

Question 2

You are reviewing a table you created in an Access database. As you review the table, you notice a column of cells that are supposed to contain sales figures have pound signs through them (#######). What is the cause of these pound signs?

Accepted Answer

A)  The pound signs are present because the value of the fields are null. 
B)  The pound signs serve as a warning that the data in the cells cannot totaled. 
C)  The pound signs are present because the column is not wide enough to display the data. 
D)  The pound signs are present because the currency format used on the cells is incorrect. 
A)  The pound signs are present because the value of the fields are null. 
B)  The pound signs serve as a warning that the data in the cells cannot totaled. 
C)  The pound signs are present because the column is not wide enough to display the data. 
D)  The pound signs are present because the currency format used on the cells is incorrect. C

Question 3

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

Accepted Answer

A) True 
 B)False  False

Question 4

-Consider the table pictured above. The value 4 in the totals row represents the number of employees listed in this table. How was this value calculated in the totals row?

Accepted Answer

A)  This value is a result of the Count function being applied to the LastName Field 
B)  This value is a result of the Average function being applied to the LastName Field 
C)  This value is a result of the Sum function being applied to the LastName Field 
D)  This value is a result of the Maximum function being applied to the LastName Field 
A)  This value is a result of the Count function being applied to the LastName Field 
B)  This value is a result of the Average function being applied to the LastName Field 
C)  This value is a result of the Sum function being applied to the LastName Field 
D)  This value is a result of the Maximum function being applied to the LastName Field

Question 5

It is not necessary to check the results of calculated fields with a calculator or an Excel spreadsheet.

Accepted Answer

A) True 
 B)False

Question 6

All of the following are true in reference to Expression Builder EXCEPT:

Accepted Answer

A)  Expression Builder inserts placeholders that tell you where each argument belongs when you insert functions 
B)  Expression Builder gives you lists of fields, operators, and functions you need to create expressions. 
C)  Expression Builder can be used when working with controls in forms and reports. 
D)  Expression Builder can only be used with functions designed by the user and not with built-in functions 
A)  Expression Builder inserts placeholders that tell you where each argument belongs when you insert functions 
B)  Expression Builder gives you lists of fields, operators, and functions you need to create expressions. 
C)  Expression Builder can be used when working with controls in forms and reports. 
D)  Expression Builder can only be used with functions designed by the user and not with built-in functions

Question 7

All the following statements are true regarding functions arguments EXCEPT:

Accepted Answer

A)  An argument can be a variable 
B)  An argument can be a constant 
C)  An argument can be the value of a field 
D)  An argument can be the value of a label 
A)  An argument can be a variable 
B)  An argument can be a constant 
C)  An argument can be the value of a field 
D)  An argument can be the value of a label

Question 8

Following the rules for the order of operations, what is the result of the following expression: (9 * 5) + 5 + 10 - 10 * 6

Accepted Answer

A)  540 
B)  40 
C)  25 
D)  0 
A)  540 
B)  40 
C)  25 
D)  0

Question 9

-Consider the table pictured above. The value of 150 in the totals row represents the total hours worked. How was this value calculated in the totals row?

Accepted Answer

A)  This value is a result of the Count function being applied to the HoursWorked Field 
B)  This value is a result of the Average function being applied to the HoursWorked Field 
C)  This value is a result of the Sum function being applied to the HoursWorked Field 
D)  This value is a result of the Maximum function being applied to the HoursWorked Field 
A)  This value is a result of the Count function being applied to the HoursWorked Field 
B)  This value is a result of the Average function being applied to the HoursWorked Field 
C)  This value is a result of the Sum function being applied to the HoursWorked Field 
D)  This value is a result of the Maximum function being applied to the HoursWorked Field

Question 10

Sum, Count, and Avg are all examples of aggregate functions.

Accepted Answer

A) True 
 B)False

Question 11

Expressions to perform calculations such as using a birthdate to find a person's age can be built using ________.

Accepted Answer

The answer of Expressions to perform calculations such as using...

Question 12

Expressions are entered in the first row of a blank query column.

Accepted Answer

A) True 
 B)False

Question 13

The ________ function measures the amount of time that has elapsed between two dates.

Accepted Answer

A)  DatePart 
B)  Date 
C)  DateDiff 
D)  DateArithmetic 
A)  DatePart 
B)  Date 
C)  DateDiff 
D)  DateArithmetic

Question 14

All of the following are arguments of the built-in PMT function EXCEPT:

Accepted Answer

A)  Rate 
B)  Present value 
C)  Future value 
D)  Loan payment 
A)  Rate 
B)  Present value 
C)  Future value 
D)  Loan payment

Question 15

According to the order of operations, multiplication and division are evaluated before addition and subtraction.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following statements is true about date formatting?

Accepted Answer

A)  Date formatting changes the underlying value of the date. 
B)  Date formatting changes the starting date that Access uses to determine the time elapsed between the current date and a starting date. 
C)  Date formatting returns a portion of the date such as the month, or year for use in functions. 
D)  Date formatting changes the way a date is displayed without changing the value of the date 
A)  Date formatting changes the underlying value of the date. 
B)  Date formatting changes the starting date that Access uses to determine the time elapsed between the current date and a starting date. 
C)  Date formatting returns a portion of the date such as the month, or year for use in functions. 
D)  Date formatting changes the way a date is displayed without changing the value of the date

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Jenny is working on a database that stores invoices. She needs to include the current day, month, and year, which will be derived from the computer system, on each new invoice. She should use the ________ function for this purpose.

Accepted Answer

A)  DatePart 
B)  Date 
C)  DateDiff 
D)  DateArithmetic 
A)  DatePart 
B)  Date 
C)  DateDiff 
D)  DateArithmetic

Question 19

A formula used to calculate new fields from the values in existing fields is called a(n) ________.

Accepted Answer

The answer of A formula used to calculate new fields...

Question 20

Calculated fields requiring complex expressions can be created with ________ in Access.

Accepted Answer

The answer of Calculated fields requiring complex expressions can be...

Creating spaces in the names of calculated fields is recommended because these fields are easier to reference in queries.

You are reviewing a table you created in an Access database. As you review the table, you notice a column of cells that are supposed to contain sales figures have pound signs through them (#######). What is the cause of these pound signs?

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

-Consider the table pictured above. The value 4 in the totals row represents the number of employees listed in this table. How was this value calculated in the totals row?

It is not necessary to check the results of calculated fields with a calculator or an Excel spreadsheet.

All of the following are true in reference to Expression Builder EXCEPT:

All the following statements are true regarding functions arguments EXCEPT:

Following the rules for the order of operations, what is the result of the following expression: (9 * 5) + 5 + 10 - 10 * 6

-Consider the table pictured above. The value of 150 in the totals row represents the total hours worked. How was this value calculated in the totals row?

Sum, Count, and Avg are all examples of aggregate functions.

Expressions to perform calculations such as using a birthdate to find a person's age can be built using ________.

Expressions are entered in the first row of a blank query column.

The ________ function measures the amount of time that has elapsed between two dates.

All of the following are arguments of the built-in PMT function EXCEPT:

According to the order of operations, multiplication and division are evaluated before addition and subtraction.

Which of the following statements is true about date formatting?

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

Jenny is working on a database that stores invoices. She needs to include the current day, month, and year, which will be derived from the computer system, on each new invoice. She should use the ________ function for this purpose.

A formula used to calculate new fields from the values in existing fields is called a(n) ________.

Calculated fields requiring complex expressions can be created with ________ in Access.

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Introduction to Access

Excel: Relational Databases and Queries

Excel: Customize, Analyze, and Summarize Query Data

Excel: Creating and Using Professional Forms and Reports

Access: Introduction to Powerpoint

Access: Presentation Development

Access: Powerpoint Rich Media Tools

Filters

Exam 17: Access: Presentation Design

Creating spaces in the names of calculated fields is recommended because these fields are easier to reference in queries.

You are reviewing a table you created in an Access database. As you review the table, you notice a column of cells that are supposed to contain sales figures have pound signs through them (#######). What is the cause of these pound signs?

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

-Consider the table pictured above. The value 4 in the totals row represents the number of employees listed in this table. How was this value calculated in the totals row?

It is not necessary to check the results of calculated fields with a calculator or an Excel spreadsheet.

All of the following are true in reference to Expression Builder EXCEPT:

All the following statements are true regarding functions arguments EXCEPT:

Following the rules for the order of operations, what is the result of the following expression: (9 * 5) + 5 + 10 - 10 * 6

-Consider the table pictured above. The value of 150 in the totals row represents the total hours worked. How was this value calculated in the totals row?

Sum, Count, and Avg are all examples of aggregate functions.

Expressions to perform calculations such as using a birthdate to find a person's age can be built using ________.

Expressions are entered in the first row of a blank query column.

The ________ function measures the amount of time that has elapsed between two dates.

All of the following are arguments of the built-in PMT function EXCEPT:

According to the order of operations, multiplication and division are evaluated before addition and subtraction.

Which of the following statements is true about date formatting?

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

Jenny is working on a database that stores invoices. She needs to include the current day, month, and year, which will be derived from the computer system, on each new invoice. She should use the ________ function for this purpose.

A formula used to calculate new fields from the values in existing fields is called a(n) ________.

Calculated fields requiring complex expressions can be created with ________ in Access.

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Introduction to Access

Excel: Relational Databases and Queries

Excel: Customize, Analyze, and Summarize Query Data

Excel: Creating and Using Professional Forms and Reports

Access: Introduction to Powerpoint

Access: Presentation Development

Access: Powerpoint Rich Media Tools

Filters