Use parameter queries to filter query results

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Learn how to add parameters to your queries so they ask for your input, such as a date or a name, before they run. Parameters are a powerful way to filter your query results.

Inside this course:

Use parameter queries to filter your results (4:30)
The basics of adding parameters to queries.

Use logical operators and wildcards in parameter queries (2:59)
Adding flexibility to parameter queries.

Parameter queries in Access Apps, part 1: Create and test the query (2:26)
Building a parameter query for an Access App.

Parameter queries in Access Apps, part 2: Create the views needed to run the query (4:56)
Building the views to run a parameter query in an Access App.

Use logical operators and wildcards in an Access App (4:57)
Using logical operators and wildcards in a parameter query in an Access App.

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

More courses available at Microsoft Office Training.

Applies To: Access 2013



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!

Support resources

Change language