advanced microsoft access training courses in london - Work Groups views

Access allows you to specify many settings, depending on your experience and skill level. Simple solutions are sometimes the best, until you can figure out a way to do it more effectively with deeper understanding.

Withuout using Groups:
Without using security, you could have a standard switchboard that appears for all users on loading the database. You could then have a separate switchboard that you need to activate manually as the administrator. (By hiding the database window - Tools > Startup). F11 shows the window.


With using groups:
You can specifiy object level security if you have the time and knoweldge to implement effectively without compromising the rest of your database. Essentially the switchboard is just another form, so you could allow users to interact with the basic form, and then have a secodary switchbaord linked to the primary that has administrator functions, but is locked out to normal users.