Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface(GUI) and software-development tools.
With Microsoft Access one can create custom apps fast without being a developer.
MS Access is now much more than a way to create desktop databases. It’s an easy-to-use tool for quickly creating browser-based database applications that help you run your business. Your data is automatically stored in a SQL database, so it’s more secure than ever, and you can easily share your applications with colleagues.
Here is a list of 50 Most Useful MS Access shortcut keys for working at lightening speed.
| To do this | Press |
| Select the active tab of the ribbon and activate KeyTips | Alt or F10 (to move to a different tab, use KeyTips or the arrow keys) |
| Open the Home tab | Alt+H |
| Open the Tell me box on the ribbon | Alt+Q, and then enter the search term Shift+F10 |
| Display the shortcut menu for the selected item | Shift+F10 |
| Move the focus to a different pane of the window | F6 |
| Open an existing database | Ctrl+O or Ctrl+F12 |
| Show or hide the Navigation Pane | F11 |
| Show or hide a property sheet | F4 |
| Switch between Edit mode (with insertion point displayed) and Navigation mode in a datasheet or design view | F2 |
| Switch to Form view from form Design view | F5 |
| Move to the next or previous field in a Datasheet view | The Tab key or Shift+Tab |
| Go to a specific record in a Datasheet view | F5 (then, in the record number box, type the record number and press Enter) |
| Open the Print dialog box from Print (for datasheets, forms, and reports) | Ctrl+P |
| Open the Page Setup dialog box (for forms and reports) | S |
| Zoom in or out on a part of the page | Z |
| Open the Find tab in the Find and Replace dialog box in the Datasheet view or Form view | Ctrl+F |
| Open the Replace tab in the Find and Replace dialog box in the Datasheet view or Form view | Ctrl+H |
| Add a new record in Datasheet view or Form view | Ctrl+Plus Sign (+) |
| Open the Help window | F1 |
| Exit Access | Alt+F4 |
| Open the File page | Alt+F |
| Open the Home tab | Alt+H |
| Open the Create tab | Alt+C |
| Open the External Data tab | Alt+X or Alt+X,1 |
| Open the Database Tools tab | Alt+Y |
| Open the Fields tab | Alt+J, B |
| Open the Table tab | Alt+J, T |
| Open the Add-ins tab, if present | Alt+X, 2 |
| Open the Tell me box on the ribbon | Alt+Q, and then enter the search term |
| Open a new database | Ctrl+N |
| Open an existing database | Ctrl+O or Ctrl+F12 |
| Open the selected folder or file | Enter |
| Open the folder one level above the selected folder | Backspace |
| Delete the selected folder or file | Delete |
| Display a shortcut menu for a selected item such as a folder or file | Shift+F10 |
| Move forward through options | Tab |
| Move backward through options | Shift+Tab |
| Open the Look in list | F4 or Alt+I |
| Save a database object | Ctrl+S or Shift+F12 |
| Open the Save As dialog box | F12 or Alt+F+S |
| Open the Help window | F1 |
| Go back to Access Help Home | Alt+Home |
| Select the next item in the Help window | The Tab key |
| Select the previous item in the Help window | Shift+Tab |
| Perform the action for the selected item | Enter |
| In the AccessHelp topics list, expand or collapse the selected item | Enter |
| Select the next hidden text or hyperlink, including Show All or Hide All at the top of a topic | The Tab key |
| Select the previous hidden text or hyperlink | Shift+Tab |
| Perform the action for the selected Show All, Hide All, hidden text, or hyperlink | Enter |
| Move back to the previous Help topic (Back button) | Alt+Left Arrow or Backspace |
Hope this keyboard shortcut is useful for you.
