Access Chapter 5
When creating a parameter query, the text phrase should be enclosed in which of the following?
Brackets [ ]
Which data validation method enables you to execute programming tasks whenever data in a table is changed?
Data macro
________ is similar to a validation rule except the logic is more complex and the actions taken are more powerful when table data is changed.
Data macro
A(n) ________ is a set of constraints or rules that help control how data is entered into a field.
Data validation
An Access function that examines a date and returns a portion of the date is:
DatePart function.
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?
DatePart("w",[HireDate])
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?
DatePart("yyyy",[HireDate])
Which data validation property specifies a value that is automatically entered into a field?
Default value
Which of the following enables you to create mathematical functions in Access?
Expression builder
________ affects the display of the date without affecting the underlying value.
Formatting
The ________ function evaluates an expression and displays one value when the expression is true and another when the expression is false.
IIF
Which data validation method forces users to conform to a specific data-entry format for a given field?
Input mask
Which of the following forces you to enter the phone number in a consistent manner in the database table?
Input mask
Which of the following function checks to see if a field has no value?
IsNull
________ function checks to see if a field does not contain a value.
IsNull
When you use the ________ operator, each criterion must be true for the compound criterion to be true.
Like
The ________ creates a menu of finite values by asking you questions and using your answers to create the options list.
Lookup Wizard
A field with a number of repeated values may be better suited as what kind of field?
Lookup field
When two functions are not sufficient to evaluate an expression, you may need to use a(n):
Nested function.
________ functions refers to using one formula within another one.
Nesting
Which data validation method forces data entry in a field?
Required
________ is the correct syntax for the Round function.
Round(expression, precision)
________ is the first method for controlling data input in a field of a table.
Selecting an appropriate data type
What data validation method is designed to restrict the data values entered into a field?
Validation rule
Which data validation method provides an error message when a validation rule has been broken?
Validation text
A(n) ________ helps to reduce editing time when there is a common value in a field.
default value
A lookup list accepts multiple values in a single field.
false
A parameter query prompt is enclosed in parentheses.
false
A required field can be left blank when entering a record.
false
An input mask can be used when there is a common value in many records.
false
In the criteria of a query, Access encloses date fields with & symbols.
false
The default Required setting for all fields except the primary key field is Yes.
false
The user provides the criterion at run time when using a lookup list.
false
Validation text restricts the data value that can be entered into a field.
false
When using an input mask, data is still not necessarily consistent.
false
When using an input mask, parentheses and hyphens are automatically stored with the data.
false
When you violate a validation rule, Access allows you to continue entering the record.
false
A(n) ________ forces users to conform to a specific data entry format for a given field.
input mask
The data validation method that causes fields to be limited to predefined list of values is a:
lookup list.
A(n) ________ accepts two or more options in a lookup field.
multiple-value field
A(n) ________ sets the property of a field to force data entry.
required
A field that cannot be left blank when you create a new record is a:
required field.
A Multivalued Lookup field accepts numerous options instead of just one field choice.
true
A lookup field can be used when there is repetitive data in a field.
true
A parameter query is similar to creating most other query types.
true
A required field indicates that a value for the field must be entered.
true
A required field is one that cannot be left blank when you create a new record.
true
An input mask forces users to conform to a specific data-entry format for a given field.
true
By creating an input mask you can further restrict the data being input into a field by specifying the exact format of the data entry.
true
For phone numbers, the input mask helps ensure consistency in data entry.
true
If you add a validation rule to a table with existing records, some data in those records may violate the rule.
true
If you want to see records with a field within a certain date range, you could use the Between operator.
true
Instead of modifying the query grid each time a new criteria is needed, a parameter query can be created to enter the criteria.
true
Like any other field, a calculated field using DatePart can have criteria applied to it.
true
Reports can be created based on the results of a parameter query.
true
The Date function calculates the current date.
true
The Date function is commonly used as a default value for a date field.
true
The options for a lookup field can be stored in a separate table.
true
To ensure the integrity of records in a table, you should set the required property to Yes for critical fields.
true
Validation rules limit the type or range of data a user can enter into a field.
true
Validation rules prevent invalid data from being entered into a field.
true
When a report has been created and used in Access, it can be formatted and laid out differently than the original design.
true
When creating a lookup field, it is important to only allow options from the lookup table.
true
When there is more than one parameter in a query, Access asks for the information starting from the left and moving to the right.
true
When using the Lookup Wizard to create a lookup field, Access creates a hidden relationship between two tables-the table that contains the lookup field and the table that holds the options.
true
You can use Date() in the default value property to insert the current date when a new record is added.
true
[Enter city] on the criteria line of a query is an example of the criteria in a parameter query.
true
A ________ rule limits the type of data a user can enter into a field.
validation
Which fields in a table are required fields by definition?
A field with a primary key
A(n) ________ performs calculations on an entire column of data and returns a single value.
Aggregate function