Question 1

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 only display the top 25 records in the query results.

Question 2

To set the validation text for a table in Table Datasheet view,you use the _____ button on the Table Tools Fields tab.
A) Validation
B) Property Sheet
C) Message
D) Required

Accepted Answer

To set validation text for a table in Table Datasheet view, you need to use the Validation button on the Table Tools Fields tab. This button allows you to create and manage validation rules for the fields in your table, including setting validation text to display when a user enters data that violates one of your validation rules.

Question 3

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 used to find records in one table that do not have related records in another table.

Question 4

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 5

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: A description can be added to a query to provide context and information about its purpose.
B) Recordset Type: This property defines how the query results will be presented, such as a table, snapshot, or dynaset.
C) Default View: This property determines the default view for the query when it is opened, such as datasheet or form view.
D) Field Size: This property pertains to the size of individual fields within a table, not the query as a whole.

Question 6

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 statement is true. The Find Unmatched Query Wizard is specifically designed to identify records in one table that do not have matches in another table. This type of query is commonly used in database applications to identify records that are missing important information or that need to be updated. By using the Find Unmatched Query Wizard, users can quickly and easily identify these records and take necessary actions to resolve any issues.

Question 7

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 8

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. This allows you to specify the source of the lookup values, such as a table or query, and the displayed fields and sort order. You can also set various options for the lookup field, such as whether to store the lookup value or display text, and whether to allow multiple values or limit choices to those in the source table or query.

Question 9

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 validation rule expression ">#7/1/21#" means that the date entered must be greater than (after) the date 7/1/21.

Question 10

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 11

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

To enter a value in a lookup field in Table Datasheet view, you need to click the arrow in the field, and then click an item on the list. Option A is incorrect as it refers to the column heading, not the field itself. Option B is incorrect as arrow keys are used for navigation in the datasheet view. Option C is incorrect as the Lookup arrow on the Home ribbon is used to create or modify a lookup field, not to enter data into an already existing lookup field.

Question 12

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

When you set a validation rule for a table, you define an expression that limits the values that users can enter into a record. This helps ensure data accuracy and consistency. A criterion is a condition used to filter data in a query, a data type defines the type of data that can be stored in a field, and a relationship determines how two tables are related to each other.

Question 13

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

Accepted Answer

The Validation Rule property can be applied to Short Text and Date/Time fields, as well as other field types, to enforce specific data entry requirements.

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 tries to enter data that violates the validation rule for a field. In this case, if a user enters "100" in the Quantity field which has "< 50" as the validation rule, Access will display the message set in the Validation Text property.

Question 15

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 field can accommodate more than 256 characters in a field, hence it is used for storing comments, reviews or notes that exceed the character limit of a standard text field.

Question 16

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 expression '> 0' checks for a value that is greater than 0, which ensures that the price entered is a positive currency value.

Question 17

To set the properties for an entire table,open the table's property sheet in Table Design view.

Accepted Answer

The table's property sheet in Table Design view allows you to set the properties for the entire table.

Question 18

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 19

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 20

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

Gender, State, and Department are good candidates for single-value lookup fields as they typically have a limited set of predefined values that can be referenced from a lookup table.

Quiz 5: Generating Reports From Multiple Worksheets and Workbooks

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

To set the validation text for a table in Table Datasheet view,you use the _____ button on the Table Tools Fields tab.

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

To set the properties for an entire table,open the table's property sheet in Table Design view.

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

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 _____.

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