Moving from MS Access to SQL Server 2012, need help with column history

I'm moving an access database from all the data being in MS Access to MS Access being just a frontend, but I'm having trouble figuring out how to do a sort of column history. I have a tasks.description column, and in another table descriptionLog, I have ID, Description, DateTime, and Task. Task is the ID of the task from the Task table. I was able to do this using data macros, but I need it to be agnostic from MS Access. I've read a few guides on change tracking but I'm not sure how to get the data out. Detail on column history: column history is a functionality of MS Access databases 2007 and up where you can set a memo column to be append only, keeping a log of what was entered or removed from the column.