Tip: Use ADO wildcards in the Access Query Design Grid

In MS Access 2000 or later, if you're using ADO, there is a way to use ADO wildcards in the Access query design grid. Instead of using the Like operator, use ALike, which also works in SQL statements used in VBA code.