How can we hide the left pane and make the tables, queries and reports password protected so that user is only able to work with forms? Moreover I want forms to be only used and be protected from being re-designed.
It depends on the version of Access you use, among other things.
1. Split the database on the Front-end/Back-end schema.
2. Password-protect the code.
3. Compile to an mde (or the equivalent for Access 2007-2010).
4. Disable several settings (use of the Shift key at startup, etc.)