acess
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Acess

resolvedResolved · Low Priority · Version 2003

replyReply Mon 28 Apr 2008, 15:48Delegate Darren said...

Darren has attended:
Access Introduction course

Acess

How do you lock down the data from other users

For upcoming training course dates see: Pricing & availability

replyReply Tue 6 May 2008, 16:54Trainer Pete said...

RE: Acess

Hi Darren, Thank you for your post, welcome to the forum, in answer to your question, this subject is covered in our Access Advanced course; But to give you a little insight;
To set user rights you can use the Security Wizard which you will find by opening the Database window and at the Menu command Tools choose the option Security> User-Level Security Wizard.
Follow the steps to set user rights as required for your network.
Note: These operations should be carried out for the first time on a copy of your database, as incorrect operation could cause the database to become totally locked against all users.
I hope that has set you in the right direction, best regards Pete Emmerson; Microsoft Office Specialist Master Instructor

 

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

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard