Queries VI: Use wildcards in queries and parameters

Use wildcards in your queries

Learn how to use wildcards in your queries. Wildcards can make your queries more flexible and powerful, and help you find data in less time.

Start course button

About this course

This course includes:

  • One practice session for hands-on experience. The practice requires Access 2007.

  • A Quick Reference Card you can take away from the course.


After completing this course you will be able to:

  • Use the asterisk wildcard.

  • Find characters in specific positions in your data.

  • Find ranges of characters in your data.

  • Find wildcard characters contained in your data.

Before you begin

Topics in this course

  1. Learn how to go wild

  2. Start by knowing your data

  3. Use the asterisk

  4. Match a character in a specific position within your data

  5. Match a range of characters

  6. Find wildcards in your data

  7. Practice

  8. Quick reference card

Applies To: Access 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language