In SQL Server 2008 this can be done Server Auditing for finding database access through login activity or u can use some stored procedure to track user access.

If we talk about SQL Server 2005 then use DMV sys.dm_db_index_usage_stats which identifies last read and write to a table. For this to happen use aggregate data in DMV with database level.