Don’t Type When Access Does it For You
[Ctrl]+[;] inserts the current date.
This is invaluable if you keep historical records, or include the date in any notes or other fields in your database. It not only saves time, but ensures data accuracy and keeps you from having to remember the date.
[Ctrl]+[:] inserts the current time.
Like the Insert Date shortcut, this feature can save more time than you realize, and it also helps to keep your data accurate.
[Ctrl]+['] inserts the value from the same field in the previous record.
When you need to enter several records consecutively, you probably find that many of the fields are the same from record to record. Using the clipboard to copy data can help, but you may need to enter several fields of duplicate information (your name in one field, the date in another field, and some generic comments in a third). Use this shortcut to insert the same field’s value from the previous record.
[Ctrl]+[Alt]+[Spacebar] inserts the default value for the current field.
This comes in handy when you start typing, and then realize that you should have kept the default.