Question 1

Access automatically validates some data entry.

Accepted Answer

Access automatically validates data entry to ensure that data entered into a field is in the correct format and meets any specified requirements.

Question 2

Validation rules serve as warnings; they do not actually prevent invalid data entry.

Accepted Answer

Validation rules in databases or software applications are designed to enforce data integrity by preventing the entry of invalid data, not just serving as warnings.

Question 3

To enable the Input Mask Wizard,you press the Build button.

Accepted Answer

The Input Mask Wizard can be accessed by clicking on the Build button in the Input Mask property of a field in the table or in the form design view.

Question 4

The default setting for the Required field property for most fields is "Yes".

Accepted Answer

The default setting for the Required field property in most database systems is typically "No," allowing users to leave fields blank unless specified otherwise.

Question 5

Storing the options used in a lookup field in a separate table makes adding options easier.

Accepted Answer

Storing the options used in a separate table allows for easier maintenance and updating of the lookup options, as well as reducing data redundancy. It also allows for referential integrity to be enforced.

Question 6

To create a parameter query,you would put the desired text in parenthesis in the criterion row of the desired field.

Accepted Answer

To create a parameter query, you would put the desired text in square brackets, not parenthesis, in the criterion row of the desired field.

Question 7

In a parameter query,if you do not specify a comparison operator,Access will assume equal to.

Accepted Answer

This statement is true. If you do not specify a comparison operator in a parameter query in Access, it will assume that you are looking for exact matches or values equal to the parameter.

Question 8

You can use the word Like in a data validation rule.

Accepted Answer

The word "Like" can be used in a data validation rule in Excel to specify a pattern or set of characters that must be present in the user's input. For example, a rule using "Like ??-####" would only accept input that has two letters followed by a hyphen and four numbers.

Question 9

Storing the characters in an input mask requires more disk space,so it is not recommended.

Accepted Answer

Storing characters in an input mask does not require significant extra disk space, so it is still a commonly used practice.

Question 10

You cannot change the Required field property after data has been entered.

Accepted Answer

The Required field property in databases can be changed even after data has been entered; however, setting a field to Required after data exists may require ensuring all records meet the new requirement.

Question 11

Reports cannot be based on parameter queries.

Accepted Answer

Reports can be based on parameter queries. Parameter queries allow the user to enter specific criteria that will be used to generate the report.

Question 12

When you change the lookup field's source table,the options will be updated when the user tries to change data in the future.

Accepted Answer

When the lookup field's source table is changed, the options will be updated dynamically when the user tries to change data in the future.

Question 13

Tables are a good source for data in a lookup field.

Accepted Answer

Tables can be a great source for a lookup field as they provide a structured and organized way to store data that can easily be referenced in the lookup field.

Question 14

You must set the Required field property to Yes for any field used as a Primary Key unless it has an AutoNumber data type.

Accepted Answer

The Required field property does not need to be set to Yes for a Primary Key field, regardless of its data type, because a Primary Key inherently requires a value and cannot be null.

Question 15

Access allows for the creation of custom input masks.

Accepted Answer

Access does allow for the creation of custom input masks, which can help to ensure that data is entered in a consistent and accurate format.

Question 16

Between [Enter Start Date] And [Enter End Date] is a valid statement to use in a parameter query.

Accepted Answer

This statement is a valid syntax to use in a parameter query for selecting records with a date field falling between a specified start and end date.

Question 17

An input mask is used to consistently format data.

Accepted Answer

An input mask is used to guide users to enter data in a specific format, which helps to ensure consistency in data entry. It can be used for various types of data such as phone numbers, dates, social security numbers, and more.

Question 18

The Date function is entered as Date().

Accepted Answer

The Date function in JavaScript is entered as Date(). It creates a new Date object with the current date and time.

Question 19

Input masks can restrict the number of characters allowed in a field.

Accepted Answer

The answer of Input masks can restrict the number of...

Question 20

If you used a lookup field for a field named State,the book recommends that you have fifty menu options available to anyone doing data entry.

Accepted Answer

The book likely recommends limiting the number of menu options to improve usability and efficiency during data entry, rather than having as many as fifty options.

Quiz 6: Data Validation and Data Analysis