Date entry short cuts
Did you know that you can enter just the day and month, with spaces between the two, and Access will add the year and insert the slashes. (Or whatever your separator character between the dates is?) Of course you really want to be careful on this tip when you are in the first day of the new year entering transactions from the last working day of the previous year.
Or you can enter just the year, with all four digits, and the month and Access will add the 01 for the first day of the month?
Note that I never use input masks and my machine has the date format in the regional settings set to yyyy-mm-dd. So I can always see the century as well. Just in case.
A client likes displaying his dates in dd-mmm-yy format, ie 31-Jan-07. I prefer to always display the full century as in one situation 12 records in a table with 100,000 records had the wrong century. Just due to fat fingers.