Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2007

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Access 2007

Resolved · Medium Priority · Version 2007

Reply Tue 24 Jun 2008, 16:17Delegate Jan said...

Jan has attended:
Access Intermediate course
Access Advanced course

Access 2007

In Office 2007 how do I make the database to open on the form only therefore not allowing data inputters access to queries and tables

For upcoming training course dates see: Pricing & availability

Reply Wed 25 Jun 2008, 10:38Trainer Stephen said...

RE: Access 2007

Hi Jan

Thank you for your question

If you click on the "Office" button (located in the top left hand corner). You can then click on the Access Options button

Choose the "Current database" option and remove the following selections

Remove "display navigation"
Remove ticks from "display full menus" and "Allow default shortcut menus

Hope this is useful. Let me know if you need further clarification

Regards

Stephen

Access articles

· How much time could you save with Access?
· Data validation in MS Access
· Microsoft Access and Customer Surveys
· Innovation with Microsoft Access
· Find Microsoft Access Templates For Any Task

Please browse our web site to find out more about
ms+access+courses and other Microsoft training courses.

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown

View all Access hints and tips