Deck 17: Access: Presentation Design

Question 1

Which of the following statements is true in reference to calculated fields:

A) Calculated fields can be used as input for other calculated fields
B) Calculated field names should contain spaces
C) Calculated fields cannot be created with Expression Builder
D) Calculated fields cannot be added to tables

Answer 1

A

Question 2

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

A) Argument
B) Formula
C) Expression
D) Syntax

Answer 2

A

Question 3

Constants that are used as arguments in expressions can be defined as ________.

A) Variables that do not change
B) Objects that do not change
C) Values that do not change
D) Functions that do not change

Answer 3

C

Question 4

Syntax can most accurately be defined as the ________.

A) names of fields, controls, or properties.
B) formulas used to calculate new fields from the values in existing fields.
C) arithmetic instructions such as * , / , + , or - .
D) set of language rules that Access follows when evaluating expressions.

Question 5

Which of the following statements is true about date formatting?

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 6

Access contains ________ that perform routine calculations.

A) Identifiers
B) Built-in Functions
C) Operators
D) Constants

Question 7

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

A) Date
B) Aggregate
C) Number
D) Totalling

Question 8

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

A) Tables
B) Queries
C) Forms
D) Macros

Question 9

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

A) Expression Builder
B) Table Wizard
C) Form Wizard
D) Report Builder

Question 10

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

A) expression
B) Excel spreadsheet
C) second query
D) formula

Question 11

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) DatePart
B) Date
C) DateDiff
D) DateArithmetic

Question 12

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

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

Question 13

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

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

Question 14

The first two arguments of the DatePart function are ________ which describes the part of the date that will be returned; and ________ which tells Access where to locate the date / time information.

A) <>, <>
B) <>, <>
C) <>, <>
D) <>, <>

Question 15

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.

A) Avg
B) Min
C) Max
D) Count

Question 16

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

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

Question 17

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

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

Question 18

Expression Builder inserts ________ that tell you where each argument belongs.

A) rows
B) fields
C) columns
D) placeholders

Question 19

Jenna is working on a database that stores a company's invoices. The database includes a Table called Invoices, which has a column called outBalances that shows all outstanding balances. Jenna's boss has asked her to design a query that calculates the numerical mean of all outstanding balances. Which function should Jenna use on the outBalances column to help her complete this task?

A) Avg
B) Sum
C) Count
D) Max

Question 20

The built-in IIf Function evaluates a condition and displays ________.

A) the same value for conditions that evaluate to true or false
B) a value only if the condition is true
C) one value when the condition is true and another value when the condition is false
D) a value only if the condition is false

Question 21

Which of the following is the correct mathematical sequence for the order of operations:

A) Multiplication, Division, Exponentiation, Addition, Subtraction
B) Exponentiation, Multiplication, Division, Addition, Subtraction
C) Multiplication, Exponentiation, Division, Addition, Subtraction
D) Addition, Subtraction, Multiplication, Exponentiation, Division

Question 22

The PMT function is BEST suited to determine:

A) The rate of interest on a car loan
B) The due date of a car loan
C) The monthly payment on a car loan
D) The average payment of a car loan

Question 23

Which of the following statements offers the best method for ensuring that a database is recoverable in case of corruption?

A) Limit the number of queries containing expressions in order to limit the chances of corrupting the database
B) Avoid using the misspelled names of tables and fields in calculated field expressions
C) Avoid using too many date arithmetic related functions.
D) Make a copy of the database before attempting to make changes to the database.

Question 24

All of the following are valid statements in reference to the IIf function EXCEPT:

A) IIf functions can only be used when a condition will evaluate to either true or false
B) IIf functions can be nested when two when two conditions are not sufficient to evaluate an expression
C) IIf functions can contain other functions as arguments
D) IIf functions work only with numeric values and not with text

Question 25

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

A) Colon
B) Exclamation Point
C) Bracket
D) Parentheses

Question 26

Consider the following equation: 3 * (6 + 5) - 4 / 2. Which operation would be calculated FIRST according the order of operations:

A) 3 * 6
B) 4 / 2
C) 6 + 5
D) 5-4

Question 27

Which of the following statements is INCORRECT regarding aggregate functions?

A) Aggregate functions perform calculations on entire columns of data
B) Access refers to aggregate functions as Totals.
C) Aggregate functions are not designed to perform calculations on individual records in a table or query
D) Aggregate functions can return multiple values

Question 28

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

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 29

Steve is working in a database that stores student exam grades. He needs to create a query that will show the numerical mean of exam grades. He should use the ________ function on the column containing the grades.

A) Sum
B) Avg
C) Count
D) Max

Question 30

-Consider the table pictured above. GrossPay is a calculated field. Which of the following expressions was used to calculate the data for the field?

A) [HoursWorked]*[HourlyWage]
B) [HoursWorked] x [HourlyWage]
C) [HoursWorked]([HourlyWage])
D) [HoursWorked]+ [HourlyWage]

Question 31

Expression Builder can be opened by selecting Builder located in the Query:

A) Show / Hide group
B) Setup group
C) Type group
D) Results group

Question 32

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

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 33

-Consider the table pictured above. The value of $17.50 in the totals row represents the mean hourly wage. How was this value calculated in the totals row?

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

Question 34

All the following statements are true regarding functions arguments EXCEPT:

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 35

A total row, which can be displayed as the last row in the Datasheet view of a table, provides a number of ________ functions that can be applied to columns of data.

A) Aggregate
B) DateTime
C) Statistical
D) PMT

Question 36

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

A) A function produces a result based on variable inputs known as arguments.
B) You can use Expression Builder to find out if a built-in function exists in Access.
C) Built-in functions can only perform calculations on numeric data.
D) Built-in functions work the same in Access as they do in Excel.

Question 37

Craig is working in a database that stores homes for sale for a Realtor. The database contains a table called HomeListings which contains a field called ListingDate that holds the date that a home was listed. Craig is designing a query that will identify houses on the market for less than 30 days as new listings, and houses on the market 30 days or more as old listings. This information will be included in a query column called ListingAge. Which of the following expressions will achieve these results:

A) ListingAge: IIf(Date-[HomeListings]![ListingDate]<30,"New Listing","Old Listing")
B) ListingAge: IIf(Date-[HomeListings]![ListingDate]>30,"New Listing","Old Listing")
C) ListingAge: IIf(Date-[HomeListings]![ListingDate] < 30, "Old Listing","New Listing")
D) ListingAge: IIf(Date-[ListingDate]![HomeListings]<30,"New Listing","Old Listing")

Question 38

You create a calculated field that finds the average of a column of numbers. Access automatically names the field Expr1. Which of the following statements is true regarding the automatic naming of the calculated field?

A) You cannot edit an expression in a calculated field that has been named Expr1 by Access
B) Access assigns Expr1 to a calculated field name when an expression contains an error.
C) You cannot edit the name of a calculated field that has been named Expr1
D) Access assigns Expr1 to a calculated field without a name, and this name can be edited

Question 39

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

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 40

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?

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.

Question 41

According to the order of operations, addition and subtraction are evaluated before multiplication and division if the addition and subtraction equations are contained within parentheses.

Question 42

Previous versions of Access allowed you to add calculated fields to tables.

Question 43

The order of operations determines the sequence by which operations are calculated.

Question 44

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

Question 45

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

Question 46

The PMT function returns the monthly payment due on a loan.

Question 47

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

Question 48

What function in a Totals Row would calculate the least valued data item in a group?

A) Maximum
B) Count
C) Average
D) Minimum

Question 49

You can use the ________ function in an expression requiring the current date.

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

Question 50

An expression or integer value specifying total number of payments in a loan is the ________ argument in the PMT function.

A) rate
B) num_periods
C) present value
D) future value

Question 51

Following the order of operations, 3+2*6 evaluates to 30.

Question 52

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

Question 53

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

Question 54

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

Question 55

Calculated fields can only be displayed on a form.

Question 56

Exponents are evaluated first according to the order of operations.

Question 57

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

Question 58

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

Question 59

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

Question 60

The Average or AVG function can only be used with the Number datatype.

Question 61

The currency field format automatically rounds to two decimal places.

Question 62

Calculated fields in Datasheet view can be edited in the same way other fields from a table are edited.

Question 63

When designing expressions in Expression Builder, you cannot use nested IIf functions.

Question 64

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

Question 65

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

Question 66

When you use a table field in an expression, Access will automatically correct any spelling errors in the field name.

Question 67

The set of rules that Access follows when evaluating expressions in calculated fields is called ________.

Question 68

The ________ function calculates loan payments.

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

Rounding fields to two decimal places in a column formatted as currency formats can help you avoid potential problems when the column is totaled.

Question 75

Functions do not work the same way in Access and Excel.

Question 76

The ________ function evaluates a condition and displays different values for true and false conditions.

Question 77

When designing an expression using Expression builder in Access, expressions can only be created with constants

Question 78

Aggregate functions only work with numerical data.

Question 79

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

Question 80

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