COM S 113 - Final Exam (Access Ch. 5)
Reports cannot be based on parameter queries.
False
Hour
"h"
Month
"m"
Minute
"n"
Day of the Week
"w"
Year
"yyyy"
In the Round function, if you leave the precision level blank, Access will default to how many decimal places?
0
=DatePart("m", #01/16/1959#)
1
How many arguments does the IIf function have?
3
Date function
A function that calculates and displays the current date.
IsNull function
A function that checks whether a field has no value when you need to see if a field was skipped in data entry
IIf function
A function that evaluates an expression and displays one value when the expression is true and another value when the expression is false.
DatePart function
A function that examines a date and displays a portion of the date.
Round function
A function that returns a number rounded to a specific number of decimal places.
Parameter query
A query where the user provides the criterion at run time.
Data Validation
A set of constraints or rules that help control data and accuracy of data entered into a field.
Input mask
A setting that restricts the data being input into a field by specifying the exact format of the date entry and guarantees consistent formatting of data in a field.
Lookup Wizard
A tool that helps you create a menu of predefined values by asking you questions and using your answers to create the options list.
Lookup field
A way to provide the user with a predefined list of values to choose from in a menu.
Default Value
A way to specify what value that is automatically entered into a field when a new record is added to a table.
What sort of validation rule would you add to a Salary field with a Number data type?
At the very least, a validation rule of >=0 would make sense since people cannot make a negative salary. If there is a maximum salary for the company (say, $150,000), you may want to consider Between 0 and 150000 to ensure it falls in the correct range.
What data type allows you to change the Required field property?
AutoNumber
How does the precision argument change the way the Round function behaves?
By changing the precision of the Round function, you will change how the function rounds a number. For example, if the precision is left blank or set to zero, it will round to the nearest whole number. However, rounding the same number and changing the precision to 1 will round to the nearest tenth rather than to the nearest whole number.
How would you direct the DatePart function to display only the year of a field named BirthDate?
DatePart("yyyy", BirthDate)
A null value means that the value is zero for any type of a field
False
A parameter query is not a type of select query.
False
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.
False
To create a parameter query, you would put the desired text in parenthesis in the criterion row of the desired field.
False
To help limit the file size, the textbook recommends that all symbols in an input mask not be stored with the data.
False
In a parameter query, if you do not specify a comparison operator, Access will assume equal to.
True
The string of characters !\(999")"000\-0000;0;_ represents which of the following?
Input mask
What function evaluates whether a value has been entered into a field?
IsNull
Do you feel a LastName field would be a good candidate for a lookup field? Why or why not?
LastName would generally be a poor field to convert to a lookup field, given the large number of possible last names. If you had a customer with a new last name, they would first need to be added to the data source for the lookup before they could be added to a table.
A field with a limited number of values is well suited for what type of field?
Lookup field
What enables users to choose from a list of options while entering data?
Lookup field
You want to use the IIf function to display Yes for all applicants with a value of 700 or more in their CreditScore field, and No for all other applicants. What would be the value of the expression, truepart, and falsepart for this function?
The expression is CreditScore >= 700. The truepart is "Yes". The falsepart is "No".
In the Round function, the precision cannot be a negative number.
True
How does the person performing data entry benefit if you add an input mask to a field?
The input mask will make the format of the data a little more obvious. It can help avoid confusion and will lead to more consistent and faster data entry.
Access allows for the creation of custom input masks.
True
An input mask is used to consistently format data.
True
Between [Enter Start Date] AND [Enter End Date] is a valid statement to use in a parameter query.
True
How will the parameter query request display when the query is run?
Pop-up message
Give an example of a query you might want to convert to a parameter query.
Specifics will vary here, but any query that has a criteria that is being adjusted would be a good choice to be converted to a parameter query. For example, in class we have seen an example of a query where we want to see the results based on specific type of animals.
Storing the options used in a lookup field in a separate table makes adding options easier.
True
Tables are a good source for data in a lookup field.
True
The DatePart function always returns a number.
True
When you change the lookup field's source table, the options will be updated when the user tries to change data in the future.
True
Input Mask Wizard
Used to generate data restrictions for a field and help create consistent formatting of data in a field
Under what condition would you set a default values for a field?
You would set a default value if a field value appears commonly for a field. For example, if most of your customers are in the state of Florida, you could set a default value of FL for a State field.
You can restrict the data type that will be accepted in a parameter query by ...........................
choosing a data type for each parameter