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.