Yes, you can attached a infopath form to an access database. Keep in mind
your audience, Access is not meant to be a shared database structure, more
than 20 people in it can cause failures. Access is not as stable as SQL
either.
With that said, I have two forms attached to Access databases, you set it up
in your data connections. I found mapping out the database structure prior
to building the form is most helpful in having to reconnect the data
connection.