Some Data Entry Tricks

You can enter all your data with nothing more than the Tab key and some typing, but here are a few keyboard tricks that will make the job easier:

  • To insert the current date, press Ctrl+; (semicolon). To insert the current time, press Ctrl+: (colon).

  • If you have defined a default value for a field (in Table Design view), you can insert it by pressing Ctrl+Alt+Spacebar.

  • To repeat the value from the same field in the previous record, press Ctrl+' (apostrophe).

Get Ten Minute Guide to Access 97 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.