Query below finds tables which names start with specific prefix, e.g. tables with names starting with 'hr'.
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 'hr*' 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 starts with "hr"