| To do this | Press |
Open a new database |
CTRL+N |
Open an existing database |
CTRL+O |
Exit Office Access 2007Access |
ALT+F4 |
To do this |
Press |
Print the current or selected object |
CTRL+P |
Open the Print dialog box from Print Preview |
P or CTRL+P |
Open the Page Setup dialog box from Print Preview |
S |
Cancel Print Preview or Layout Preview |
C or ESC |
Save a database object |
CTRL+S or SHIFT+F12 |
Open the Save As dialog box |
F12 |
To do this |
Press |
Open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only) |
CTRL+F |
Open the Replace tab in the Find and Replace dialog box (Datasheet view and Form view only) |
CTRL+H |
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) |
SHIFT+F4 |
To do this |
Press |
Switch between Edit mode (with insertion point displayed) and Navigation mode (Navigation mode: The mode in Microsoft Access in which an entire field is selected and the insertion point is not visible. In Navigation mode, you can move between fields by using the arrow keys.) in a datasheet. When working in a form or report, press ESC to leave Navigation mode. |
F2 |
Switch to the property sheet (Design view in forms and reports in both Access databases and Access projects) |
F4 |
Switch to Form view from form Design view |
F5 |
Switch between the upper and lower portions of a window (Design view of queries, and the Advanced Filter/Sort window) |
F6 |
Cycle through the field grid, field properties, Navigation Pane, access keys in the Keyboard Access System, Zoom controls, and the security bar (Design view of tables) |
F6 |
Open the Choose Builder dialog box (Design view window of forms and reports) |
F7 |
Open the Visual Basic Editor from a selected property in the property sheet for a form or report |
F7 |
Switch from the Visual Basic Editor back to form or report Design view |
SHIFT+F7 or ALT+F11 |
