You can use a old trick from ms-access that allows you to drag a form to a
your desktop.
While looking at the forms tab, just drag the form to your desktop. You get
a shortcut.
The user can click on that shortcut, and go direct to the form.
You of course still need ms-access on the computer.
On the other hand, you are also free to complete hide the ms-access
interface, but that certainly a separate question from having a form start
when ms-access starts.
If you want an example of the ms-access interface hidden, then grad the 3rd
example at the following web page:
http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm