This page keyboard shortcuts for Microsoft Access will provide an overview of the different shortcuts that I use regularly. I have broken them into two areas: Data Entry and Microsoft Access Development.
Previous Value of Field
When you move to a new record and the value of the field that you have to complete is the same value as the previous record, by pressing the Ctrl key and the ‘ (single talking mark) key, the value of the previous field will automatically be entered into the new field.
Today's date (Current date)
To automatically add today's date in Microsoft Access when doing data entry
Ctrl & ; (Semi colon)
Undo what you have just written
Ctrl and Esc
When developing in Microsoft Access, all the usual Microsoft keyboard shortcuts are available i.e.
Ctrl & C - Copy
Ctrl & V - Paste
Ctrl & X - Cut
Also the F keys have a variety of functions as per below:
Shift & F2 - Automatically opens the 'Zoom' window. Great if you are working in a very small area, and wish to see all of your text. A lot easier than making the text box or similar bigger, just to see the text, then having to shrink it again to its original size.
F4 - Opens the property sheet
Alt & Enter - If you are in deisign view of a form or a report, these keys will also open the property sheet
F5 - Takes the view of the form from design view to form view (but not back the other way.
F7 - To check your spelling
Alt & F4 - Exit Microsoft Access
Alt & F11 - Opens the Visual Basic Editor Window. It also takes you back to the form or report you were originally on if you press Alt & F11 again.
Left, Right, Up & Down arrows - If you just want to shift a control a little bit up or down, or the right or left, use your arrow keys to nudge them.
This page on keyboard shortcuts for Microsoft Access, will continue to grow as I come accross other shortcuts.
If you have a keyboard shortcut, that you wish to share and have added to this page, then just complete the feedback/suggestion form below. Thanks.