Query below lists all tables in MS Access database ordered by descending creation date.

Query

select MSysObjects.name,
   MSysObjects.DateCreate,
   MSysObjects.DateUpdate
from MSysObjects
where
   MSysObjects.type In (1,4,6)
   and MSysObjects.name not like '~*'   
   and MSysObjects.name not like 'MSys*'
order by   MSysObjects.DateCreate desc

Columns

• name - table name
• DateCreate - creation date
• DateUpdate - last upate (DDL) date

Rows

• One row represents one table in the database
• Scope of rows: all tables in the database
• Ordered by creation date (newest first)

Notes

Note that we have excluded system tables (names starting with ~ or Msys).

Sample results

Query result shows names of all tables in the database (newest first)