Query below lists all tables in MS Access database.
select MSysObjects.name from MSysObjects where MSysObjects.type In (1,4,6) and MSysObjects.name not like '~*' and MSysObjects.name not like 'MSys*' order by MSysObjects.name
Note that we have excluded system tables (names starting with ~ or Msys).
Query result shows names of all tables in the database.
Get this interactive HTML data dictionary in minutes with Dataedo.