Access

Resolved · Low Priority · Version 2003

Mon 2 Jun 2008, 16:32 Delegate Katherine said...

Katherine has attended:
Access Introduction course

Access

My comapny does not currently have access. Which version would you reccomend I buy? I was trained on 2000 but should it make much difference?

Fri 6 Jun 2008, 17:09 Trainer Pete said...

RE: Access

Hi Katherine, Thanks for the post, the majority of our training courses are run on Office 2003, we also run courses on Office 2007, (the latest version). Most users today have version 2003 with some now migrating to 2007. The diffference between 2000 and 2003 is minimal, however there is quite a difference between 2003 and 2007 although this is mainly in the user interface. There is some functionality difference but not much so if you are used to creating queries and tables you should not have too much problem changing to 2007. You should consider either 2003 and 2007 with a bias towards 2007 as it is the latest version and will be supported for longer by Microsoft. I hope that helps, regards Pete

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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