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 » Limited access to database

	98.1 % recommend us
	More live stats...

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

Training information:

Limited access to database

Resolved · Medium Priority · Version 2007

Reply Wed 25 Jun 2008, 15:55Delegate Jan said...

Jan has attended:
Access Intermediate course
Access Advanced course

Limited access to database

Create a full page form for users which fills complete page and does not allow access to tables, queries etc

For upcoming training course dates see: Pricing & availability

Reply Sun 6 Jul 2008, 20:15Delegate Mark said...

RE: Limited access to database

Hello Jan,

If you go to Tools, Start-Up, you will see options including unchecking Display Database Window and also unchecking the menus (so that they cannot go via different routes to queries etc). Just make sure you have your own same copy or two which does have access to these first otherwise you might lock yourself out. This will mean they will only see the forms you allow commencing with the form you select to open with in the Start-up option and buttons to any others from that form. If the form doesn't open to fill the window they can maximise it, but I think there is a way to ensure it opens maximised. In any case in doing the above the database window will not be present in the background.

Regards, Mark

Access articles

· Learn The Secrets About Splitting An Access Database
· An Introduction To Queries In Access
· Use Microsoft Access to manage your work/life balance
· How To Create Your Own Access 2007/2010 Navigation Pane
· How To Find Good Access Database Courses In London

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

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips