How do I get access logs from SQL Server database
At least, you can create table with fields for username, date and time and information about transaction. Secondly, you should create trigger functions for your tables, function should write logs into you log table, this allow you to access your logs quite simply.