FREE TRAINING!!!

Are you taking advantage of all the free training provided by Microsoft.com? The best lesson I ever learned was to look for the answer myself before asking for help. Seems that the answer is usually already there. According the the Crabby Office Lady, it's a lesson others need to learn, too. Read about Crabby's underused feature of the week: Office Training.

Whats New In Excel 2010 webinar

Thanks to @MrExcel for sharing! View recording of Whats New In Excel 2010 webinar at http://www.safaribooksonline.com/Corporate/DownloadAndResources/webcasts.php.

Access: Automatically enter today's date in a field

For some records, you enter today's date for a particular field. When a date is to be the current date, you can eliminate entering any value at all. Set the field’s Default Value property to Now() or Date(). When you enter a new record, the property will enter the system’s current date (and time). If for some reason it is not today's date, you can still type over the default value with the correct date (and time).If you only occassionaly enter the current date, you can use the shortcut CTRL+; (semicolon) instead.

Now() versus Date()

The Now() function returns the system’s current date and time. It’s a package deal–you always get both. If all you need is the current date and not the time, use the Date() function instead. On the other hand, if all you want is the current time, use the Time() function. Don’t use Now() unless you really mean to store both the date and time.