Security

Resolved · Low Priority · Version 2003

Security

Jamal has attended:
Access Intermediate course
Access Advanced course
Access VBA course

by - delegate Jamal [1 post] (2008 Apr 8 Tue, 15:46) Reply

How do I introduce user security/levels

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Security

by - trainer Pete platinum contributer [799 posts] (2008 Apr 24 Thu, 10:35) Reply

Hi Jamal, thanks for the post, welcome to the forum, in reply to your question, sorry its taken so long, but I've just noticed that it hasn't been replied to:
Security User levels can be applied to your database quite quickly if you are prepared to use the Database Security Wizard, in fact this is probably the best way of setting security levels in a small to medium sized user base.
Menu command Tools>Security>User-Level Security Wizard, you can then follow the setup steps as per your requirements to set user rights, following from this you might want to attempt the User and Group Permissions and the User and Group Accounts manually, make sure that you try this out in a Copy of your database, in a separate folder to the original as a small error or ommission can cause disastrous results. I wish you luck, best regards Pete

· Microsoft Access Cheat Sheet: Tips and Shortcuts
· MS Access and Database Normalisation
· Why Do I Need To Use Access?
· Access Database Optimization: First Normal Form
· Get More Out of MS Access Courses

Please browse our web site to find out more about
access+courses+in+london 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.