The following two minute video demonstrates the advanced parameter query in Microsoft Access using a text (string) data type as the example by extending the criteria parameters.

Microsoft Access Database: Advanced Parameter Query In Microsoft Access

The narrator doesn’t really expand too much how advanced this can really get when using the advanced parameter query in Microsoft Access but it puts the foundation down for using the more flexible criteria for a string value by using the & operator (which means concatenate).

Microsoft Access Database Tutorial: Two more things to say here!

I apologise for the dryness of the narrators delivery (it’s only 2 minutes!) and to explain the definition of the word ‘concatenate‘ meaning ‘the joining of...’. Now you can continue to experiment with an advanced parameter query in Microsoft Access .

To learn more about parameter queries and other types of Microsoft Access queries including formula query, summary and crosstabs, take a look at my eBook offer; More Access Database Queries; which is one of a six series set of eBooks available to you.

Tags: advanced parameter query in microsoft access, how to use a parameter query, MS Access, ms access queries, parameter queries