Question 1

A nonnull field is a field that contains any data at all,including a single space.

Accepted Answer

A nonnull field can contain any data at all, including a single space. It is not empty or null.

Question 2

An input mask with a 0 character indicates that only a digit can be entered as the value and that the entry is optional.____________________

Accepted Answer

mandatory

Question 3

Tables used in a find unmatched query must have a common field.____________________

Accepted Answer

Tables used in a find unmatched query must have a common field that links the two tables together. Without a common field, it would be impossible to determine which records in one table do not have a matching record in the other table.

Question 4

A parameter query displays a dialog box that prompts the user to enter one or more values when the query is run.____________________

Accepted Answer

This is true as a parameter query prompts the user to input values dynamically when running the query.

Question 5

When using the IIf function,a condition is tested,and if the condition is false,the first value of the condition is returned by the function.____________________

Accepted Answer

The answer of When using the IIf function,a condition is...

Question 6

A value of true will be returned if a field is empty when the IsNull function is used.

Accepted Answer

This is because the IsNull function in SQL Server returns a value of true if the specified expression is NULL, and an empty field is considered to be NULL.

Question 7

TheLike comparison operator is used to select records by matching field values to a specific pattern that includes one or more of the wildcard characters (*,?,#)in a query.____________________

Accepted Answer

This statement is correct as the Like comparison operator is used in SQL to select records by matching field values to a specific pattern that includes one or more of the wildcard characters (*,?,#) in a query.

Question 8

A summarized record for each unique field value is displayed in a crosstab query.

Accepted Answer

Crosstab queries group data by one field (the row field) and summarize data by another field (the column field), displaying the summarized data in a matrix format. Each unique value in the row field represents one row in the query output, and each unique value in the column field represents one column. The summary operation (e.g., count, sum, average) is applied to the data that falls in the intersection of each row and column. Therefore, each unique field value in the row field is displayed as a separate row in the output, with a summarized record for each one.

Question 9

Yes/No field values are stored in an Access database as a --1 for a checked value and a 0 for an unchecked value.

Accepted Answer

Yes/No field values in Access are stored as -1 for checked values and 0 for unchecked values.

Question 10

A calculated query uses aggregate functions to perform arithmetic operations on selected records.

Accepted Answer

The answer of A calculated query uses aggregate functions to...

Question 11

A pattern match selects records whose values for the designated field matches one of two or more simple condition values.

Accepted Answer

The answer of A pattern match selects records whose values...

Question 12

The ____ function tests a condition and returns one of two values;the function returns the first value if the condition is true and the second value if the condition is false.
A)IIf
B)Pmt
C)IsNull
D)NPV

Accepted Answer

The IIf function is built specifically for testing a condition and returning one of two values. It takes three arguments: the condition to test, the value to return if the condition is true, and the value to return if the condition is false. Pmt calculates the payment for a loan based on constant payments and a constant interest rate. IsNull tests whether a value is null or not. NPV calculates the net present value of an investment based on a series of cash flows.

Question 13

Which of the following illustrates a calculated field with the name of the calculated field in the proper format?
A)[Donation]>=2500
B)DonationsGreaterThan2500: [Donation]>=2500
C)>=2500[Donation]
D)[Donation]:DonationsGreaterThan2500:>=2500

Accepted Answer

Option B shows the proper format of a calculated field by starting with a unique and descriptive name, followed by a colon and the calculation formula. The formula in this case is [Donation]>=2500, which checks if the value in the donation field is greater than or equal to 2500.

Question 14

The standard naming convention prefix tag for a query used to identify the object type is ____.
A)Query
B)QURY
C)qry
D)QRY#

Accepted Answer

The standard naming convention prefix tag for a query used to identify the object type is "qry". This convention is widely used in Microsoft Access for query objects.

Question 15

The format field command freezes a field (column)in a datasheet so that the field stays visible when the user scrolls to the right while viewing the datasheet.____________________

Accepted Answer

freeze field

Question 16

An input mask property cannot be changed after the Input Mask Wizard closes.

Accepted Answer

The input mask property can be changed manually in the property sheet after the Input Mask Wizard closes.

Question 17

When using the IIF function,each part of the function is separated by a colon.____________________

Accepted Answer

comma

Question 18

Any type of Access object may be deleted from the Tables Pane using the Delete command on the shortcut menu.____________________

Accepted Answer

Navigation Pane

Question 19

Max is an example of a(n)logical function used in a crosstab query.____________________

Accepted Answer

aggregate

Question 20

Joining two or more fields in a calculated field using an expression such as =Title &" "&FirstName &" " &LastName is an example of concatenation.____________________

Accepted Answer

Concatenation refers to joining two or more strings together, which is what the given expression is doing by joining the values of the Title, FirstName, and LastName fields with spaces in between.

Quiz 5: Creating Advanced Queries and Enhancing Table Design