excel keyboard shortcuts cheat sheet 2007

Increase the height of the selected control Move the selected Microsoft Access control to the left (except controls that are part of a layout) Move the selected control to the right (except controls that are part of a layout) Paste the contents of the Clipboard in the upper-left corner of the selected section Switch from the Visual Basic Editor back to form or report Design viewĮditing controls in form and report Design viewĬopy the selected control to the ClipboardĬut the selected control and copy it to the Clipboard Open the Microsoft Access Visual Basic Editor from a selected property in the property sheet for a form or report Open the Choose Builder dialog box (Design view window of forms and reports) Switch between the upper and lower portions of a window (Design view of queries, and the Advanced Filter/Sort window)Ĭycle 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) Switch to Form view from form Design view in Microsoft Access Switch to the property sheet (Design view in forms and reports in both Access databases and Access projects) When working in a form or report, press ESC to leave Navigation mode. In Navigation mode, you can move between fields by using the arrow keys.) in a datasheet. 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.

Open the Replace tab in the Find and Replace dialog box (Datasheet view and Form view only)įind 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) Open the Find tab in the Find and Replace dialog box in Microsoft Access (Datasheet view and Form view only) Refresh the contents of a Lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.) list box or combo box Open the Page Setup dialog box from Print Preview Open the Print dialog box from Print Preview Open an existing Microsoft Access database Microsoft Access 2007 Keyboard Shortcuts - printable cheatsheet Microsoft Access 2007 Keyboard Shortcuts

Excel keyboard shortcuts cheat sheet 2007