Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Access

Resolved · Medium Priority · Version 2007

Reply Tue 25 Jan 2011, 15:49Delegate Tracy said...

Tracy has attended:
Access Introduction course
Access Intermediate course

Access

The best way to lock a database so that I am the only person inputting data.

For upcoming training course dates see: Pricing & availability

Reply Mon 31 Jan 2011, 10:36Trainer Andrew said...

RE: Access

Hi Tracy

I am sorry that we have not been able to get back to you as soon as we would have liked. We will be in touch shortly to progress your question.

Thank you for your patience.

Kind regards,

Andrew

Reply Tue 1 Feb 2011, 14:16Trainer Anthony said...

RE: Access

Hi Tracy, thanks for your query. While there are many ways to ensure exclusive access to a database, I'd recommend you start off by password protecting it. A walkthrough of this
is point 8 in the list linked to here:

http://www.techrepublic.com/blog/10things/10-tips-for-securing-a-microsoft-access-database/552

Hope this helps,

Anthony

Access articles

· A Quick Intro On How Access Uses SQL
· How To Use A Parameter Query In Access
· How to Find a Third-Party Venue for Microsoft Access Training
· A Place Of Trust: How Microsoft Have Made Access 2010 Even More Secure
· What Is The Database Documenter And How Is It Used?

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

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds

View all Access hints and tips