Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.
    • Access 2013

      Use query criteria in Access 2013

    • Access 2013

      Using AND and OR with multiple criteria

    • Access 2013

      Using the NOT, IN, LIKE, and BETWEEN operators

    • Access 2013

      Using wildcards in query criteria

Learn how to use criteria to filter your Access data. This course covers adding criteria to queries, using AND and OR logic, logical operators such as IN and BETWEEN, and how to use wildcards. You need a basic understanding of queries to complete this course.

Inside this course:

Use query criteria in Access 2013 (3:46)
The basics of adding criteria to queries, and rules for staying out of trouble.

Using AND and OR with multiple criteria (3:53)
The basics of using AND and OR logic in your criteria.

Using the NOT, IN, LIKE, and BETWEEN operators (3:27)
Using logical operators to include and exclude data, and find ranges of data.

Using wildcards in query criteria (3:06)
Using wildcard characters to help find data when you don't know all of a value.

Course summary
A brief reminder of the key points in this course.

More courses available at Microsoft 365 Training Center.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×