Access' version of SQL doesn't support triggers like MS SQL Server's T-SQL, but that might be above your experience level to figure it out. However, if don't need anything in Access besides table view ...
Lesson about SQL. Contains elements of component 1.3.2 (d) from OCR A-Level Computer Science spec. Lesson has exam style questions with mark scheme. Contains explanations of SQL, how to query a ...