Microsoft Access: 50 Most Useful Keyboard Shortcuts for All
Tips & Tricks 27-Jan-2017

Microsoft Access: 50 Most Useful Keyboard Shortcuts for All

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. </p>
											</div>
					<div class=

Share This