Question 1

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

Accepted Answer

The correct sequence for the order of operations is Exponentiation, Multiplication and Division (from left to right), and then Addition and Subtraction (from left to right). This is often remembered by the acronym PEMDAS (Parentheses, Exponents, Multiplication and Division, Addition and Subtraction).

Question 2

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

Accepted Answer

The PMT function is specifically designed to calculate the payment for a loan based on constant payments and a constant interest rate, making it best suited for determining the monthly payment on a car loan.

Question 3

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.

Accepted Answer

Making a copy of the database before attempting to make changes is a direct method to ensure that a database can be recovered in case of corruption. This approach allows for a backup to be restored if something goes wrong during the changes.

Question 4

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

Accepted Answer

The IIf (Immediate If) function in programming languages like Visual Basic and in applications like Microsoft Access can work with various types of values, not just numeric. It can evaluate conditions that result in text, dates, or other types of data, not limited to numeric values. This makes option D incorrect as it inaccurately restricts the function's capability to only numeric values.

Question 5

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

Accepted Answer

When designing an expression for a calculated field, the name of the calculated field is followed by a colon. This syntax is used in various programming and query languages to assign or define the expression that calculates the value of the field.

Question 6

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

Accepted Answer

According to the order of operations (PEMDAS/BODMAS), parentheses (or brackets) have the highest priority, so the operation within them, which is 6 + 5, would be calculated first.

Question 7

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

Accepted Answer

Aggregate functions, by definition, perform a calculation on a set of values and return a single value. They do not return multiple values. Examples include functions like SUM, AVG, MAX, MIN, and COUNT.

Question 8

-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

Accepted Answer

The value of 150 in the totals row represents the total hours worked, which indicates that the Sum function was applied to the HoursWorked Field to add up all the individual hours worked.

Question 9

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

Accepted Answer

The correct function to calculate the numerical mean (average) of exam grades in a database is the "Avg" function. This function adds up all the values in a column and then divides by the count of values to find the average.

Question 10

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

Accepted Answer

The correct expression for calculating GrossPay from HoursWorked and HourlyWage is by multiplying the two, which is correctly represented by the expression [HoursWorked]*[HourlyWage].

Question 11

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

Accepted Answer

The Expression Builder can be accessed from the Setup group in the Query tab.

Question 12

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

Accepted Answer

Expression Builder supports both user-defined and built-in functions, making it versatile for creating expressions in various contexts such as queries, forms, and reports. The statement that it can only be used with user-designed functions is incorrect.

Question 13

-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

Accepted Answer

The answer of 
-Consider the table pictured above. The value...

Question 14

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

Accepted Answer

Arguments in functions can indeed be variables, constants, or the value of a field. However, the value of a label is not typically considered an argument in programming contexts. Labels are often used in programming for marking sections of code, not for holding values that can be passed as arguments to functions.

Question 15

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

Accepted Answer

The total row in Datasheet view provides aggregate functions such as SUM, AVG, COUNT, etc., which can be applied to columns of data.

Question 16

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.

Accepted Answer

Built-in functions in Access (and in most programming environments) are designed to work with various types of data, not just numeric. They can handle strings, dates, and other data types, performing operations like concatenation, format conversion, and more. This makes choice C incorrect as it inaccurately limits the scope of built-in functions to only numeric data calculations.

Question 17

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")

Accepted Answer

The correct expression is A) ListingAge: IIf(Date-[HomeListings]![ListingDate]<30,"New Listing","Old Listing") because it correctly calculates the number of days a listing has been on the market by subtracting the listing date from the current date (using the Date function). If the result is less than 30, it labels the listing as "New Listing"; otherwise, it labels it as "Old Listing".

Question 18

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

Accepted Answer

Access automatically assigns the name Expr1 to a calculated field when a name is not specified by the user. However, this default name can be edited to something more meaningful, which helps in identifying the purpose of the calculated field more clearly.

Question 19

-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

Accepted Answer

The value 4 in the totals row represents the number of employees listed in the table, which is calculated by counting the number of entries in the LastName field. The Count function is used to tally the number of items in a column, making option A correct.

Question 20

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.

Accepted Answer

The pound signs (#######) appear because the column width is not sufficient to display the entire number or data. This is a common visual indicator in many database and spreadsheet applications, including Access, to alert the user that the column needs to be widened to view the content fully.

Quiz 17: Access: Presentation Design

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

The PMT function is BEST suited to determine:

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

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

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

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

Which of the following statements is INCORRECT regarding aggregate functions?

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

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.

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

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

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

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

All the following statements are true regarding functions arguments EXCEPT:

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.

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

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?

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

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?