Question 1

When you set a _____ for a table, you create an expression that restricts the values that users can enter into a record.
A) criterion
B) data type
C) validation rule
D) relationship

Accepted Answer

A validation rule is used to restrict the values that users can enter into a record in a table. It is an expression that defines the conditions that data must meet in order to be added to or updated in the table.

Question 2

How do you enter a value in a lookup field in Table Datasheet view?
A) Click the arrow in the column heading, and then click an option.
B) Press an arrow key
C) Click the Lookup arrow on the Home tab.
D) Click the arrow in the field, and then click an item on the list.

Accepted Answer

In a lookup field in Table Datasheet view, you can enter a value by clicking the arrow in the field and then selecting an item on the list that appears. Option A is incorrect because it refers to clicking the arrow in the column heading, which would open the filter options, rather than allowing you to enter a value. Option B is incorrect because pressing an arrow key would simply move the cursor to a different cell in the table. Option C is also incorrect because clicking the Lookup arrow on the Home tab would simply open the Lookup Wizard to create a new lookup field, rather than allowing you to enter a value in an existing lookup field.

Question 3

Use a Long Text field when you need to store more than 256 characters in a field, such as for comments, reviews, or notes.

Accepted Answer

Long Text fields can store more than 256 characters, making them ideal for storing lengthy comments, reviews, and notes.

Question 4

You use the Find Unmatched Query Wizard to find records in one table that do not have related records in another table.

Accepted Answer

This is the correct use of the Find Unmatched Query Wizard.

Question 5

To create a single-value lookup field in Table Design view, you use the _____ in the Field Properties pane.
A) Lookup tab
B) Input Mask property
C) Lookup button
D) List property

Accepted Answer

To create a single-value lookup field in Table Design view, you use the Lookup tab in the Field Properties pane.

Question 6

Which of the following are properties you can set for a query? Select all the options that apply.
A) Description
B) Recordset Type
C) Default View
D) Field Size

Accepted Answer

A) Description: This property allows you to provide a brief description of the query for documentation purposes.
B) Recordset Type: This property determines the type of recordset that the query returns, such as a dynaset, snapshot, or forward-only recordset.
C) Default View: This property determines the default view of the query when it is opened, such as as a datasheet, pivot table, or form.
D) Field Size: This property sets the maximum size of a field in the query's underlying table or tables, and is not a property of the query itself.

Question 7

If you select 25 in the Top Values list, Access displays _____ in the query results.
A) the top 25% of the records
B) 25 randomly selected records
C) 25 fields
D) the top 25 records

Accepted Answer

Selecting 25 in the Top Values list will display the top 25 records in the query results.

Question 8

Which of the following fields are good candidates for a single-value lookup field? Select all the options that apply.
A) OrderDate
B) Gender
C) State
D) Department

Accepted Answer

The answer of Which of the following fields are good...

Question 9

Create a Top Values query to find the highest values in set of unsorted records.

Accepted Answer

The answer of Create a Top Values query to find...

Question 10

You cannot use the Validation Rule property with Short Text or Date/Time fields.

Accepted Answer

The Validation Rule property can be used with Short Text or Date/Time fields.

Question 11

If you want users to enter a positive Currency value in a Price field, enter _____ as the validation rule expression.
A) <= 0
B) > 0
C) '+ 1
D) "Positive"

Accepted Answer

The validation rule expression for a positive Currency value in a Price field should be "> 0", as this specifies that the value must be greater than zero. Option A, "<= 0", would allow values of zero or negative values, which is not desirable for a Price field. Option C, "+ 1", is not a valid expression for a validation rule. Option D, "Positive", is not a valid expression for a validation rule and is too general, as it does not specify the exact condition that must be met.

Question 12

You use the Explanation property to display a message when a user tries to enter data that break the validation rule.

Accepted Answer

The answer of You use the Explanation property to display...

Question 13

Dynaset is the default value of the _____ property in a query; it lets you update data in the query recordset.
A) Snapshot
B) Recordset Type
C) Description
D) Caption

Accepted Answer

The Recordset Type property determines the type of recordset a query will return. Dynaset, being the default value, allows for a dynamic set of records that can be updated.

Question 14

If the Quantity field has "< 50" as its validation rule, and a user tries to enter "100" in the field, Access displays the message in the _____ property.
A) Explanatory Message
B) Validation Text
C) Violation Message
D) Error Text

Accepted Answer

The Validation Text property is used to display a message when a user violates a validation rule. In this case, if the Quantity field has a validation rule of "< 50" and a user enters "100", Access would display the Validation Text message stating that the value entered is not valid.

Question 15

Which of the following are options you can select in the Top Values list for a query? Select all the options that apply.
A) 5
B) None
C) 25%
D) All

Accepted Answer

The answer of Which of the following are options you...

Question 16

To set a validation rule in the Employees table specifying that the DateHired field value must be greater than the DateBorn field value, you set the Validation Rule property for the _____.
A) DateHired field
B) Employees table
C) DateBorn field
D) database

Accepted Answer

The validation rule to ensure that the DateHired field value is greater than the DateBorn field value affects the relationship between two fields within the Employees table. Therefore, it should be set at the table level (option B) to apply this rule across the entire table, ensuring data integrity for the relationship between these two fields.

Question 17

The Validation Rule and _____ properties help prevent users from entering unreasonable data in the database.
A) Validation Text
B) Format
C) Caption
D) Validation Error

Accepted Answer

The Validation Rule property defines the criteria for data that can be entered into a field, and the Validation Text property provides an error message if the data entered does not meet the validation criteria. The Format property determines how the data is displayed, and the Caption property changes the label for the field. The Validation Error property is not a property that helps prevent users from entering unreasonable data but rather provides information about the specific error message.

Question 18

You use the _____ to create a query that finds records in one table that do not have related records in another table.
A) Find Duplicates Query Wizard
B) Find Unmatched Query Wizard
C) Crosstab Query Wizard
D) Select Orphans Query Wizard

Accepted Answer

The Find Unmatched Query Wizard is specifically designed to find records in one table that do not have related records in another table. The other options listed are not relevant to this task.

Question 19

Which of the following are settings you specify in the Crosstab row of the query design grid when you create a crosstab query? Select all the options that apply.
A) Row heading
B) Value
C) Sort order
D) Column heading

Accepted Answer

The answer of Which of the following are settings you...

Question 20

In a Date/Time field named HireDate, the validation rule expression >#7/1/21# means _____.
A) the date must be after 7/1/21
B) the date must be before 7/1/21
C) the date must be in July of 2021
D) the date must be 7/1/21

Accepted Answer

The symbol ">" denotes "greater than," and "#7/1/21#" is the specified date. Therefore, the validation rule expression ">#7/1/21#" means the date must be after 7/1/21.

Quiz 5: Generating Reports From Multiple Worksheets and Workbooks

When you set a _____ for a table, you create an expression that restricts the values that users can enter into a record.

How do you enter a value in a lookup field in Table Datasheet view?

Use a Long Text field when you need to store more than 256 characters in a field, such as for comments, reviews, or notes.

You use the Find Unmatched Query Wizard to find records in one table that do not have related records in another table.

To create a single-value lookup field in Table Design view, you use the _____ in the Field Properties pane.

Which of the following are properties you can set for a query? Select all the options that apply.

If you select 25 in the Top Values list, Access displays _____ in the query results.

Which of the following fields are good candidates for a single-value lookup field? Select all the options that apply.

Create a Top Values query to find the highest values in set of unsorted records.

You cannot use the Validation Rule property with Short Text or Date/Time fields.

If you want users to enter a positive Currency value in a Price field, enter _____ as the validation rule expression.

You use the Explanation property to display a message when a user tries to enter data that break the validation rule.

Dynaset is the default value of the _____ property in a query; it lets you update data in the query recordset.

If the Quantity field has "< 50" as its validation rule, and a user tries to enter "100" in the field, Access displays the message in the _____ property.

Which of the following are options you can select in the Top Values list for a query? Select all the options that apply.

To set a validation rule in the Employees table specifying that the DateHired field value must be greater than the DateBorn field value, you set the Validation Rule property for the _____.

The Validation Rule and _____ properties help prevent users from entering unreasonable data in the database.

You use the _____ to create a query that finds records in one table that do not have related records in another table.

Which of the following are settings you specify in the Crosstab row of the query design grid when you create a crosstab query? Select all the options that apply.

In a Date/Time field named HireDate, the validation rule expression >#7/1/21# means _____.