If you want to access the records that are Updated or deleted or inserted you can create the triggers on the table you want to track this and you can access the records from special tables INSERTED, DELETED.
If you want to know the last modified date of a table you use the query like this:
SELECT OBJECT_NAME(OBJECT_ID) As DbName, Last_User_Update,
WHERE database_id = DB_ID('<your database="" name="">')
I hope I have answered your question.