Exam 17: Access: Presentation Design

Rich is working on a database that stores a list of vendors and price quotes for a remodeling project. If Rich wanted to create a query to find the least expensive price quote, he should use the ________ function on the column containing the price quotes.

(Multiple Choice)

4.9/5

(87)

Question 21

When building an expression using Expression Builder, Access will add the necessary brackets if you leave them out of the expression.

(True/False)

4.8/5

(72)

Question 22

A constant is a value that remains the same in an expression.

(True/False)

4.8/5

(82)

Question 23

A(n) ________ is a variable or constant that is needed to produce output for a function in a calculated field.

(Multiple Choice)

4.9/5

(92)

Question 24

The ________ function isolates a specific portion of a date, such as the day, month, or year, in a date field.

(Multiple Choice)

4.8/5

(93)

Question 25

Exponents are evaluated first according to the order of operations.

(True/False)

4.9/5

(82)

Question 26

According to the order of operations, expressions in ________ are calculated first.

(Short Answer)

4.8/5

(71)

Question 27

Unlike Excel, Access does not contain any built-in functions.

(True/False)

4.8/5

(60)

Question 28

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

(Multiple Choice)

4.9/5

(82)

Question 29

Calculated fields are created in the datasheet view of a table.

(True/False)

4.8/5

(84)

Question 30

________ changes the appearance of a field containing a date without affecting the data the field contains.

(Short Answer)

4.8/5

(98)

Question 31

When designing a calculated field, complex formulas can be created with the ________.

(Multiple Choice)

4.8/5

(83)

Question 32

Calculated fields can only be displayed on a form.

(True/False)

4.8/5

(83)

Question 33

A totals row in a table can include functions such as Sum, Avg, and Min.

(True/False)

4.7/5

(88)

Question 34

A(n) ________ produces results based on variable or constant inputs known as arguments.

(Short Answer)

4.9/5

(76)

Question 35

Aggregate functions are most commonly used in all of the following Access objects EXCEPT:

(Multiple Choice)

4.9/5

(77)

Question 36

The sequence by which operations are calculated in an expression for a calculated field is determined by the ________.

(Short Answer)

4.8/5

(77)

Question 37

In addition to verifying the accuracy of a calculated field using a calculator, you can also use a(n) ________ to verify results

(Multiple Choice)

4.9/5

(82)

Question 38

Variables that are needed to produce the output for a function in a calculated field are called ________.

(Short Answer)

4.8/5

(93)

Question 39

When designing an expression for a calculated field, the name of the calculated field followed by a(n):

(Multiple Choice)

4.8/5

(76)

Question 40

Showing 21 - 40 of 96

Rich is working on a database that stores a list of vendors and price quotes for a remodeling project. If Rich wanted to create a query to find the least expensive price quote, he should use the ________ function on the column containing the price quotes.

When building an expression using Expression Builder, Access will add the necessary brackets if you leave them out of the expression.

A constant is a value that remains the same in an expression.

A(n) ________ is a variable or constant that is needed to produce output for a function in a calculated field.

The ________ function isolates a specific portion of a date, such as the day, month, or year, in a date field.

Exponents are evaluated first according to the order of operations.

According to the order of operations, expressions in ________ are calculated first.

Unlike Excel, Access does not contain any built-in functions.

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

Calculated fields are created in the datasheet view of a table.

________ changes the appearance of a field containing a date without affecting the data the field contains.

When designing a calculated field, complex formulas can be created with the ________.

Calculated fields can only be displayed on a form.

A totals row in a table can include functions such as Sum, Avg, and Min.

A(n) ________ produces results based on variable or constant inputs known as arguments.

Aggregate functions are most commonly used in all of the following Access objects EXCEPT:

The sequence by which operations are calculated in an expression for a calculated field is determined by the ________.

In addition to verifying the accuracy of a calculated field using a calculator, you can also use a(n) ________ to verify results

Variables that are needed to produce the output for a function in a calculated field are called ________.

When designing an expression for a calculated field, the name of the calculated field followed by a(n):

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