Access Chapter 3 Quiz
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 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 wildcard characters matches any number of characters?
*
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
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 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 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 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 keyboard shortcuts opens the Save As dialog box?
F12
Which of the following keys opens or closes the Property Sheet?
F4
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 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 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 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 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 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
How does Access evaluate a criterion expression that just includes a criteria value?
equal to
What should you use to write criterion into a query?
expressions
Which of the following functions performs a comparison and does one of two alternatives?
iif
Which of the following requires you to enter the specific criteria value when you run the query?
parameter query
Which of the following finds data in your database by enabling you to ask a question?
query
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
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
