I was as well.
But I think the OP is trying to equate a stored query in Access with a View in SQL.
So, I think it's not possible to have an 'Action View' like you would have an 'Action Query' in Access.
Yes, a Stored Procedure can be used in T-SQL for the purpose.
Or just use a Pass-through query with the UPDATE/INSERT/DELETE SQL statement.