Opening databases
CTRL+N | To open a new database |
CTRL+O | To open an existing database |
ALT+F4 | To quit Microsoft Access |
Printing and saving
CTRL+P | To print the current or selected object |
P or CTRL+P | To open the Print dialog box |
S | To open the Page Setup dialog box |
C or ESC | To cancel Print Preview or Layout Preview |
CTRL+S or SHIFT+F12 or ALT+SHIFT+F2 | To save a database object |
F12 or ALT+F2 | To open the Save As dialog box |
Using a combo box or list box
F4 or ALT+DOWN ARROW | To open a combo box |
F9 | To refresh the contents of a Lookup field list box or combo box |
DOWN ARROW | To move down one line |
PAGE DOWN | To move down one page |
UP ARROW | To move up one line |
PAGE UP | To move up one page |
TAB | To exit the combo box or list box |
Finding and replacing text or data
CTRL+F
| To open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only) |
CTRL+H
| To open the Replace tab in the Find and Replace dialog box (Datasheet view and Form view only) |
SHIFT+F4
| To find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed (Datasheet view and Form view only) |
Working in Design view
F2 | To switch between Edit mode (with insertion point displayed) and Navigation mode |
F4
| To switch to the property sheet (Design view in forms and reports in databases and Access projects) |
F5 | To switch to Form view from form Design view |
F7
| To switch to the Code Builder from form or report Design view (Design view window or property sheet) |
SHIFT+F7 | To switch from the Visual Basic Editor to form or report Design view |
ALT+V+P | To open property sheet for a selected object |
Editing controls in form and report Design view
SHIFT+ENTER | To add a control to a section |
CTRL+C | To copy the selected control to the Clipboard |
CTRL+X | To cut the selected control and copy it to the Clipboard |
CTRL+V | To paste the contents of the Clipboard in the upper-left corner of the selected section |
CTRL+RIGHT ARROW | To move the selected control to the right |
CTRL+LEFT ARROW | To move the selected control to the left |
CTRL+UP ARROW | To move the selected control up |
CTRL+DOWN ARROW | To move the selected control down |
SHIFT+DOWN ARROW | To increase the height of the selected control |
SHIFT+RIGHT ARROW | To increase the width of the selected control |
SHIFT+UP ARROW | To reduce the height of the selected control |
SHIFT+LEFT ARROW | To reduce the width of the selected control |
Window operations
F11 | To bring the Database window to the front |
CTRL+F6 | To cycle between open windows |
ENTER | To restore the selected minimized window when all windows are minimized |
ALT+SPACEBAR | To display the Control menu |
SHIFT+F10 | To display the shortcut menu |
CTRL+W or CTRL+F4 | To close the active window |
ALT+F11 | To switch between the Visual Basic Editor and the previous active window |
ALT+SHIFT+F11 | To switch to the Microsoft Script Editor from the previous active window |
CTRL+F8 | To turn on Resize mode for the active window when it’s not maximized; press the arrow keys to resize the window |
Working with Wizards
TAB | Move to the Help Button image button in the wizard |
ALT+N | To move to the next window in the wizard |
ALT+B | To move to the previous window in the wizard |
ALT+F | To close the wizard window |
Note: You cannot use CTRL+TAB to navigate from one wizard window to another. CTRL+TAB will move the cursor between dialog boxes and controls on the wizard window.
Miscellaneous
F2 | To display the complete hyperlink address for a selected hyperlink |
F7 | To check spelling |
ALT+ENTER | To display a property sheet in Design view |
ALT+F4 | To quit Microsoft Access, close a dialog box, or close a property sheet |
CTRL+F2 | To invoke a Builder |
CTRL+F11 | To toggle between a custom menu bar and a built-in menu bar |
CTRL+RIGHT ARROW or CRTL+COMMA (,)
| To toggle forward between views when in a table, query, form, report, page, view , PivotTable list, PivotChart report, stored procedure, or Access project (.adp) function. If there are additional views available, successive keystrokes will move to the next available view. |
CTRL+LEFT ARROW or CRTL+PERIOD (.)
| To toggle back between views when in a table, query, form, report, page, view, PivotTable list, PivotChart report, stored procedure, or .adp function. If there are additional views available, successive keystrokes will move to the previous view |
SHIFT+F2 | To open the Zoom box to conveniently enter expressions and other text in small input areas |
Leave Comment