Can someone show me how I can hide the main console that opens in MS Access and just open only the specific form the user will be working on. I saw this done once but I have not found a way to achieve it on my database.
Actually Boyd I believe they are referring to the Access App window.
You can do this by setting your forms to POPUP and then using
DoCmd.RunCommand acCmdAppMinimize
to minimize the window. However, it is not a very fun thing to try to manage because there are times where you need to display the window so a report will show, and you need to open forms and such in a specific order so that things will show up. There have been several threads around that posted here.
I was not sure exactly what they wanted. I went with the way I was hoping they wanted. If they wanted to "hide the Access shell", while possible, it has many issue as you have pointed out. I have found it is just not safe/reliable to "hide the Access shell" except for very simple apps with limited functionality needed.