Access Wildcards Quiz

What wildcard character matches zero or more characters?

• !

• *

• ?

• #

Which wildcard character matches any single alphabetic character?

• *

• !

• ?

• #

In Access, how can you find customers whose last name starts with A through H?

• Like "[i-z]*"

• Like "[a-h]*"

• Like "[m-z]*"

• Like "[a-m]*"

What is the wildcard character that matches any single numeric character?

• *

• ?

• #

• !

Which wildcard character matches any character not in the brackets?

• !

• ?

• *

• #

How can you use wildcards with a parameter query in Access?

• Like "[parameter]"

• Like "[parameter]*"

• Like "&[parameter]&"

• Like "*" & [parameter] & "*"

What is the syntax to retrieve the wildcard character asterisk (*) from your data?

• [?]

• [-]

• [*]

• [#]

Which wildcard character matches any number of characters in Access database engines (ANSI-89)?

• *

• !

• ?

• #

In SQL Server (ANSI-92), what wildcard character matches any number of characters?

• %

• ?

• _

• *

What is the wildcard character that matches any single alphabetic character in SQL Server (ANSI-92)?

• ?

• *

• _

• %