Week 8 Quiz

1) A _____ is used as a placeholder for an unknown part of a value or to match a certain pattern in a value

Wildcard character
Replace command
Find command
Find & Replace command

2) To search for a word that begins with “ar” you would enter ____

ar!
ar*
ar?
ar#

3) To search for a word anywhere in a field that contains “night” you would enter ____
*night*
#night#
!night!
?night?
4) To search for a three-letter word that begins with “m” and ends with with “t” you would enter ___

m[?]t
m?t
m-t
m!t

5) To search for a four-digit number that starts with “75” you would enter ____

75?
75##
75#
75!

6) The ____ Query Wizard is used to display fields from one or more tables or queries with the option to choose a detailed or summary if working with more than one table.

Find Unmatched
Simple
Crosstab
Find Duplicates

7) A ____ Query Wizard is used when you want to find the rows in one table that do not have a match with the other table

Find Unmatched
Simple
Crosstab
Find Duplicates

8) If two tables do not have a common field, Access will join the two tables by combining records, regardless of whether they have a matching field. This is called ___ effect

Relationship
Multiplier
Query
Join

9) _____ equates the values in a table or another query to the criteria value you set up in a query

Search criteria
Is Null criteria
Comparison operators
Query operators

10) In a query, you can select any records that have no value in a field using the ______ criteria.

Comparison
Is Null
Search
Query