Exam 3: Multiple Choice
When using wildcards in validation rules, which of the following must surround the criteria of your expression?
" "
Which of the following field validation rules requires the user to fill in a field?
"Not Null"
Which of the following is a valid criterion for the Long Text data type?
"hello"
Which of the following is a valid criterion for the Short Text data type?
"hello"
Which of the following wildcard characters does Access use in validation rules to match any single numeric digit?
#
Which of the following wildcard characters matches any single numeric digit?
#
Which symbol must be used to specify criterion for the Date/Time data type?
#
Which of the following represents the correct order of operations?
(), ^, *, /, +, -
Which of the following record validation rules requires the user to enter a value into either Field1 or Field2, but not into both fields?
([Field1] is Null) XOR ([Field2] is Null)
Which of the following wildcard characters matches any number of characters?
*
How does Access store a Yes response for the Yes/No data type?
-1
How many criteria would you need in a query in order to find all the employees who work as insurance agents in the Cameron Park branch of a company who were hired after January 1, 2019?
3
How many parts are there in an input mask?
3
Which of the following is a valid criterion for the AutoNumber data type?
5
Which of the following is a valid criterion for the Currency data type?
5
Which of the following is a valid criterion for the Number data type?
5
Which symbol separates the two parts of a formula in a query field?
:
Which of the following characters separates the parts of an input mask?
;
Which of the following formatting symbols displays characters in lowercase in a short text and long text field?
<
Which of the following field validation rules prevents the user from typing 0 into a field?
<> 0
Which of the following criterion expressions searches for a State field that is equal to Ca?
="Ca"
Which of the following criterion expressions searches for a ShippingDate field that is greater than January 1, 2019?
>#1/1/19#
Which of the following wildcard characters matches any single character in a specific position?
?
Which of the following logical operators requires that a record meet all the individual conditions specified in order to be included in the results?
AND
Which of the following prints a table in a database?
Backstage view
Which of the following comparison operators means "Between these two values"?
Between
Which of the following criterion expressions searches for a YearsWorked field that is between 10 and 20?
Between 10 and 20
Which of the following number data types stores numbers from 0 to 255?
Byte
Which of the following properties contains the text that displays in the column header to identify a field in Datasheet view?
Caption property
Which of the following data integrity rules ensures that a field contains a value if it is required?
Completeness
Which of the following data integrity rules ensures that a value entered into a field is consistent with a value in another field?
Consistency
Which of the following functions counts the number of records that have a value in the field?
Count
Which of the following Ribbon tabs do you use to create a query?
Create
Which of the following keyboard shortcuts opens the Expression Builder dialog box?
Ctrl+F2
In what view do query results display?
Datasheet view
Which of the following is used to enter records into a table?
Datasheet view
Which of the following number data types stores numbers from -1028 to 1028 with a precision of 28 significant digits?
Decimal
Which of the following properties automatically inserts a specified value into a new record in a table?
Default Value property
Which of the following keyboard shortcuts opens the Save As dialog box?
F12
Which of the following opens the Save As dialog box?
F12
Which of the following keys opens or closes the Property Sheet?
F4
Which of the following properties controls the way a field displays in a table?
Format property
Which of the following comparison operators means "contained in this list of values"?
In
When entering an expression, which of the following tools may suggest a list of possible values?
IntelliSense
Which of the following is true about the Simple Query Wizard?
It doesn't enable you to take advantage of all the options available when creating a query
Which of the following functions finds a specific number of characters from the left of the field?
Left
Which of the following comparison operators means "similar to this value"?
Like
Which of the following criterion will search for songs that contain the word "love" somewhere in the middle of the song title?
Like "**love**"
Which of the following criterion expressions searches for PhoneNumber records where the phone number contains 10 characters and starts with a 9?
Like "9?????????"
Which of the following criterion will search for songs with the title of "Love for All Seasons", "Love This Pain", and "Love Will Find a Way"?
Like "love *"
Which of the following displays a list of data values from which the user can choose?
Lookup field
Which of the following logical operators requires a record to meet at least one of the individual conditions specified to be included in the results?
OR
Which of the following print options enables you to select different print options before sending the contents of the current object immediately to the printer?
Which of the following print options enables you to check that formatting is appropriate and to make changes to any settings before printing?
Print Preview
Which of the following contains the fields which have been included in the query?
Query Design grid
Which of the following groups of commands includes buttons to insert and delete fields in the design grid?
Query Setup
What name does Access assign to new queries?
Query1
Which of the following print options bypasses the Print dialog box?
Quick Print
Which of the following print options sends the contents of the current object immediately to the printer?
Quick Print
Which of the following functions rounds a value?
Round
After you create a query in Design view, what do you need to do in order to see the results?
Run the query
Which of the following functions finds the total value of a field?
Sum
Which of the following is a true statement about foreign keys?
The foreign key field is always the primary key of another table
Which of the following is added to the design grid of a summary query?
Total row
Which of the following functions converts a value to uppercase?
UCase
Which of the following properties directs Access to display records that don't include duplicated values?
Unique Values
Which of the following symbols are used when defining a parameter query?
[ ]
Which of the following parameters is an example of the most user-friendly?
[Enter the Music Genre]
In the query design grid, what do you delete to delete a field from a query?
a column
Which of the following cannot be changed in Datasheet view of a query?
alignment
What is created when values are entered on the same Criteria row of the query design grid?
an AND condition
When structuring a criteria expression with a parameter that includes one or more wildcards, where can the wildcards be positioned?
any of the above
How many fields can you add to the query design grid?
as many as you like
Which of the following gets its value from a calculation instead of a value that is entered into the field?
calculated field
What is a primary key called that is made up of more than one field?
concatenated key
What is the name for hardcoded values entered into a formula?
constant
Which of the following should you add into a query to search for records that meet a specific value?
criterion
What determines the type of criterion you enter, along with the way you enter the criterion?
data type of the field
Which of the following refers to the process of verifying the accuracy, or integrity, of data?
data validation
What can you do if you create a relationship in error?
delete it
How does Access evaluate a criterion expression that just includes a criteria value?
equal to
In Access, what are field validation rules called?
expressions
What should you use to write criterion into a query?
expressions
In Access, which of the following is used to relate, or connect, tables?
field
Which of the following functions performs a comparison and does one of two alternatives?
iif
In Access, which of the following indicates the many sides of a relationship?
infinity symbol
Which of the following options forces a user to enter data using a specific format?
input mask
Which of the following must you do before adding a field between existing fields?
insert a new row
What is a table called that matches up the records across two tables?
junction table
Which of the following relationships describes many rows of data in Table A associated with many rows of data in Table B?
many-to-many
Which of the following relationships describes one row of data in Table A associated with many rows of data in Table B?
one-to-many
Which of the following relationships describes one row of data in Table A being associated with only one row of data in Table B?
one-to-one
Which of the following requires you to enter the specific criteria value when you run the query?
parameter query
Which of the following contains a unique value for each record?
primary key
Which of the following finds data in your database by enabling you to ask a question?
query
Which of the following ensures that records in associated tables have consistent data?
referential integrity
Which of the following is the most common type of query?
select query
Which of the following is used to locate data in a database?
select query
Which of the following display control options displays the contents of a field and enables the user to type a value into that field?
text box
You will most likely use the Zoom box or Expression Builder to enter a parameter query that contains wildcards due to the length of the expression.
true
