You can use the switchboard wizard to create a switchboard or create your own menu form to give the user access to the forms and reports, but before you go to that trouble, do a simple test.
Create a form with a button that will quit the application (docmd.quit).
Create a macro that will open that form.
Call that macro Autoexec
Make the mde and run it
If that form does not come up, then you have a problem