Page 1 of 10PREVNEXT

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.

About this course

This course includes:

  • One self-paced lesson and one practice session for hands-on experience. The practice requires Access 2007.
  • A short test at the end of the lesson; the test is not scored.
  • 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

The fifth course in this series explained how to set multiple conditions and use logical operators in queries. This course explains how to use wildcard characters in your queries.

Have you ever tried to find data, only to be stymied because you don't know the complete value you're searching for? For example, you're trying to find a part number, but you can't because you need to know the whole thing. What can you do?

You can use wildcards in your queries. With wildcards, you can match patterns, find specific letters or numbers, or match ranges of characters such as A through H or 25 through 70.

Wildcards can add a lot of power to your queries, and help you get answers faster.

To learn more about this course, read the text in Goals and About this course, or look at the table of contents. Then click Next to start the first lesson.

Page 1 of 10PREVNEXT