Page 9 of 10PREVNEXT

Queries VI: Use wildcards in queries and parameters

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.

A common use for wildcards is to:

Combine criteria values.

Enter data.

Retrieve data that matches a pattern.

Will the query 'Like "*Engineer"' retrieve the job title "Engineering Manager" from your database?



Which query below would find companies whose name starts with A, B, C, or D?

Like "[a-d]*"

Like "a to d"

From "[a to d]*"

You use the question mark wildcard (?) to _____.

Match a range of characters

Match a character in a specific position in your data

Find other wildcard characters that reside in your data

You use the number or pound sign to match text characters.



Page 9 of 10PREVNEXT