Query below finds tables which names end with specific sufix, e.g. tables with names ending with 'tab'.
Note that you can also do it in VBA
select MSysObjects.name from MSysObjects where MSysObjects.type In (1,4,6) and MSysObjects.name like '*tab' order by MSysObjects.name
- name - name of found table
- One row represents a table
- Scope of rows: all found tables
- Ordered by table name
Query returns names of all tables that ends with "tab"