Access 2010 has both stored procedures, and also has table triggers. And, both features are available even when you not using a server (so, in 100% file based mode).
If you using SQL server with access, then of course the stored produces are built using SQL server and not access.
For access 2010, you open up the table (non design view), and then choose the table tab. You see options there to create store procedures and table triggers.