There's no real easy way to do this. Of all the options here's what's best
in order of complexity:
1.) Create a simple XL spreadsheet that the person would fill out,
instructions on one tab, data entry on another. Easy to import back into
Access but no "formatting" like your form.
2.) Create a modestly complex XL spreadsheet by creating an image of your
form (screen shot), importing that into Excel and overlaying controls from
XL's tool box on the image (linking the controls to a separate worksheet
where the data is stored.) A bit of work, but not enormously complex, easy
to import into Access.
3.) Create a little database which includes your form and a single table and
send that out to folks, you get the db back. Major limitation is that not
everyone has Access and you don't want to distribute the run time.
4.) If you are doing this all internally on say an intranet, then you can
use a web server and ASP pages and forms or .Net forms to have the user's
input data directly into your db; on the internet, you'd have folks update
the data in a db on the server and then download that periodically and
import into your db.
4.a) You could also look at using something like Microsoft's Info Path from
Office 2003 to create similar form, and have the form output XML which is
sent to you via e-mail to import back into your db.
4b.) Create an Adobe PDF form and when you get the form back use the ADBC
connector to connect to your database and load up the data (see the adobe cd
for examples)
All items listed as 4, take you probably into new technology but each work
well for various situations.
