access+training - security

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Access Training and help » access+training - Security

access+training - Security

resolvedResolved · Low Priority · Version Standard

Angela has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Security

Other than Shift Enter, is there another way to secure Access. Sample question only to register on forum.

RE: Security

Hi Angela Thanks for your post, I understand that you just want to register but for others who might like to know there is another method to add a password to your database, follow these steps:
1 Open Access, Navigate to the folder where your database is located, and select the file.
2, click the drop down arrow on the Open button and choose Open Exclusive.
3. On the Tools menu select Security, Choose Set Database Password and apply a password of your choice, you will be asked to confirm it.
4. To remove the password, you once again need to Open the database in Exclusive mode, then from the Tools menu follow the steps in Security to cancel the password requirement.


 

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


Server loaded in 0.08 secs.