Because I code professionally, I'm not a big fan of using and Access query for data access, I'd prefer to code it manually. It's easier to read the code and see what's going on.
So, here's an insert statement using DBEngine