Question 1

Which of the following function checks to see if a field has no value?
A) IsNull
B) Sum
C) Average
D) IsNotNull

Accepted Answer

The IsNull function checks to see if a field has no value. This means that it will return true if the field is empty or null.

Question 2

A(n)________ performs calculations on an entire column of data and returns a single value.
A) Aggregate function
B) data macro
C) Expression Builder
D) Round function

Accepted Answer

Aggregate functions, such as SUM or AVG, perform calculations on a entire column of data and return a single value based on the values in that column. The other options listed do not perform calculations on entire columns of data.

Question 3

Assuming a hire date of February 15,2017,which of the following date part functions would return the number of days since the beginning of the current year?
A) DatePart("yyyy",[HireDate])
B) DatePart("y",[HireDate])
C) DatePart ("q",{HireDate])
D) DarePart("w",[HireDate])

Accepted Answer

The answer of Assuming a hire date of February 15,2017,which...

Question 4

________ function checks to see if a field does not contain a value.
A) IsNull
B) IsNotNull
C) IIF
D) Math

Accepted Answer

The IsNull function is used to check if a field contains a null (or no) value.

Question 5

________ is the correct syntax for the Round function.
A) Round(expression, precision)
B) Round(expression)
C) Round(expression, truepart, falsepart)
D) Round(expression, interval)

Accepted Answer

The Round function in VBA requires two arguments: expression (the number to be rounded) and precision (the number of decimal places to round to). Therefore, the correct syntax is "Round(expression, precision)".

Question 6

When two functions are not sufficient to evaluate an expression,you may need to use a(n):
A) Nested function.
B) IsNull function.
C) Round function.
D) Parameter query.

Accepted Answer

When two functions are not sufficient to evaluate an expression, you may need to use a nested function. A nested function is a function that is used as one of the arguments of another function. It allows you to perform more complex calculations by combining multiple functions within a single formula.

Question 7

Validation rules limit the type or range of data a user can enter into a field.

Accepted Answer

Validation rules can be used to enforce certain data types or limits on input within a field.

Question 8

Which of the following forces you to enter the phone number in a consistent manner in the database table?
A) Input mask
B) Default value
C) Lookup list
D) Validation rule

Accepted Answer

An input mask in database management systems is a string expression that forces data input into a particular format, ensuring consistency. For example, it can require phone numbers to be entered with a specific number of digits or in a particular pattern, such as (###) ###-####, where # represents a digit. This helps maintain data integrity and standardizes the format of data entries, such as phone numbers, in a database table.

Question 9

An Access function that examines a date and returns a portion of the date is: A) DatePart function. B) Date formatting. C) <>. D) <>.

Accepted Answer

The DatePart function allows you to extract a specific portion of a date, such as the year, month, or day. The other options listed do not apply to this specific task.

Question 10

A required field indicates that a value for the field must be entered.

Accepted Answer

A required field means that it is mandatory to enter a value for that field.

Question 11

The ________ function evaluates an expression and displays one value when the expression is true and another when the expression is false.
A) IIF
B) Math
C) IsNull
D) DatePart

Accepted Answer

The IIF (Immediate IF) function is used to evaluate an expression and return one value if the expression is true and another value if it is false. It allows for conditional logic within a query or expression.

Question 12

An input mask forces users to conform to a specific data-entry format for a given field.

Accepted Answer

An input mask does indeed force users to enter data in a specific format for a given field, such as phone numbers or dates.

Question 13

Which fields in a table are required fields by definition?
A) A field with a primary key
B) A field with a default value
C) A field with a lookup List
D) A field with an input mask

Accepted Answer

A required field is one that cannot be left blank or null. By definition, a primary key is a unique identifier for each record in a table and therefore cannot be left blank.

Question 14

Assuming a hire date of 7/31/2016,which of the following would be the correct DatePart Function for the correct day of the week?
A) DatePart("w",[HireDate])
B) DatePart("ww",([HireDate])
C) DatePart("y",[HireDate])
D) DatePart("m",(HireDate])

Accepted Answer

The "w" option in the DatePart function returns the day of the week as a number, with Sunday being 1 and Saturday being 7.

Question 15

A required field can be left blank when entering a record.

Accepted Answer

If a field is required, it must have a value entered before the record can be saved. Leaving it blank would result in an error message.

Question 16

Validation rules prevent invalid data from being entered into a field.

Accepted Answer

Validation rules are used to ensure that data entered into a field meets certain criteria, and prevent invalid data from being entered. This helps ensure data accuracy and completeness.

Question 17

________ is similar to a validation rule except the logic is more complex and the actions taken are more powerful when table data is changed.
A) Data macro
B) Validation text
C) Required text
D) Input mask

Accepted Answer

A data macro has similar functionality to a validation rule, but is able to perform more complex logic and actions when data is changed in a table. In addition, data macros can be used to automate tasks and enforce business rules. Options B, C, and D are all related to validation rules, but do not have the same level of power and flexibility as a data macro.

Question 18

A lookup list accepts multiple values in a single field.

Accepted Answer

A lookup list only accepts a single value in a field. It is a predefined list of values that a user can choose from to populate the field.

Question 19

________ affects the display of the date without affecting the underlying value.
A) Formatting
B) Rounding
C) Ruling
D) Nesting

Accepted Answer

Formatting allows the user to change the way a value is displayed, without altering the actual data stored. In this context, formatting can be used to change the way a date is displayed. Rounding refers to modifying a numerical value by approximating it to a shorter, simpler number. Ruling and nesting are not relevant terms in this context.

Question 20

________ functions refers to using one formula within another one.
A) Nesting
B) IIF
C) IsNull
D) Math

Accepted Answer

Nesting refers to using one formula within another one, such as including a SUM formula within an IF formula.

Quiz 17: Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Which of the following function checks to see if a field has no value?

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

Assuming a hire date of February 15,2017,which of the following date part functions would return the number of days since the beginning of the current year?

________ function checks to see if a field does not contain a value.

________ is the correct syntax for the Round function.

When two functions are not sufficient to evaluate an expression,you may need to use a(n) :

Validation rules limit the type or range of data a user can enter into a field.

Which of the following forces you to enter the phone number in a consistent manner in the database table?

An Access function that examines a date and returns a portion of the date is:

A required field indicates that a value for the field must be entered.

The ________ function evaluates an expression and displays one value when the expression is true and another when the expression is false.

An input mask forces users to conform to a specific data-entry format for a given field.

Which fields in a table are required fields by definition?

Assuming a hire date of 7/31/2016,which of the following would be the correct DatePart Function for the correct day of the week?

A required field can be left blank when entering a record.

Validation rules prevent invalid data from being entered into a field.

________ is similar to a validation rule except the logic is more complex and the actions taken are more powerful when table data is changed.

A lookup list accepts multiple values in a single field.

________ affects the display of the date without affecting the underlying value.

________ functions refers to using one formula within another one.