microsoft+access+training - Microsoft Access Database Macro

The UK's most regular instructor-led training courses.
Training information: microsoft+access+training · Access course microsoft training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Microsoft Access Database Macro

Dave has attended:
No courses

by - delegate Dave bronze contributer [32 posts] (2007 Jul 27 Fri, 15:06) Reply

Hi,

How can a Microsoft Access Database Macro help me whilst using a Microsoft Access Database?

Thanks
David

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 3 Wed	Southwark	0	FULL
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£190	£224
2003	2008 Oct 29 Wed	Bayswater	7	book now	£190	£224
2003	2008 Nov 5 Wed	Southwark	7	book now	£190	£224
Full Schedule: See all 54 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Microsoft Access Database Macro

by - trainer David gold contributer [428 posts] (2007 Jul 27 Fri, 16:02) Reply

Hi Dave

A Microsoft Access Database Macro can help you whilst Microsoft Access Database as it will automate manual tasks and thus save you a lot of time.

Hope this helps

David

· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Access Database Optimization: First Normal Form
· Microsoft Access Courses
· Microsoft Access Training Unleashes the Power of the Pivot Table
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps

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