How to Create Wildcard Queries MS Access

‍

‍

In Microsoft Access, wildcard queries are used to find records that match a pattern or partial data in a field. Wildcards are especially useful when working with the ‘Like’ operator in queries. Here’s how to do it:

‍

1. Go to the 'Create' tab.
2. Click 'Query Design'.
3. Add the table you want to search. Click 'Add Selected Tables'.
4. Drag the field you want to search into the query grid.
5. In the 'Criteria' row of the field, enter your 'Like' statement with wildcards.
6. Click 'Run' on the ribbon to see the results.