access+course+training - Access

The UK's most regular instructor-led training courses.
Training information: access+course+training · Microsoft access courses · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Access

Adam has attended:
Excel Intermediate course
Excel Advanced course
Access Introduction course

by - delegate Adam [3 posts] (2007 Aug 22 Wed, 10:03) Reply

Within Access, is it possible to have have levels of access to certain tables so that you can incorporate say.... salaries with in the database, but still allow staff to use the database without being able to see the salaries.

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	7	book now	£345	£399
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: Access

by - trainer David gold contributer [428 posts] (2007 Sep 5 Wed, 10:50) Reply

Hi Adam

Yes this is possible. I have done this using Microsoft Access 2002. Basically every user has a log-in and password and you are able to set up which users have access to which tables.

Hope this helps
David

· Want to Become the Office Hero? MS Project Training Could be the Answer
· Material covered on a Microsoft Access Course
· MS Access: Access your Personal Information with Ease
· Tips for designing databases in Microsoft Access
· Microsoft Access Training Unleashes the Power of the Pivot Table

Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips