access+training - Security

Resolved · Low Priority · Version Standard

Security

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

by - delegate Angela [2 posts] (2007 Oct 10 Wed, 09:53) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Southwark	5	book now	£219	£235
2003	2008 Dec 19 Fri	Bloomsbury	5	book now	£219	£235
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
2003	2009 Jan 14 Wed	Bloomsbury	8	book now	£187	£224
2003	2009 Jan 23 Fri	Bloomsbury	7	book now	£203	£230
Full Schedule: See all 45 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Security

by - trainer Pete platinum contributer [801 posts] (2007 Oct 11 Thu, 14:23) Reply

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.

· Convert a Paper Trail to a DBMS
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Innovation with Microsoft Access
· Microsoft Access and Customer Surveys

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips

Rate this page: