This is a T-SQL that will show all the last access date and time for Select, tables in a database.
select t.name ,user_seeks ,user_scans ,user_lookups ,user_updates ,last_user_seek ,last_user_scan ,last_user_lookup ,last_user_update from sys.dm_db_index_usage_stats i JOIN sys.tables t ON (t.object_id = i.object_id) where database_id = db_id()
Source: SQL Authority
Additional Information/Links: SQL Blog
Wow, Very nice Script Hero
Thanks, Mohamed. The credit definitely goes to SQL Blog for this script!