Microsoft Access Keyboard Shortcut Keys. - Hindi Bloggers.
MS Access Shortcut Keys.
MS Access Shortcuts |
Manage Databases :
Shortcut Key | Task |
---|---|
Ctrl+ N | Create New Database |
Ctl+ O | Open Existing Database |
Alt+ F4 | Exit Access |
Ctrl+ P | Print the Current Object |
Ctrl+ S | Sav a Databas Object |
F12 | Open the Save As Dialog Box |
Read: James Watt Biography and Watt Steam Engine in Hindi.
Read: Worlds first Steam Engine.
Read : Sublime Text 3 all Keyboard Shortcuts.
Read : Elon Musk Biography in Hindi.
Read : What is Computer ? Full Explanation in Hindi.
Navigate the Ribbon:
Shortcut Key | Task |
---|---|
Alt+ F | Go to the File Menu |
Alt+ H | Go to Home Tab |
Alt+ C | Go to the Create Tab |
Alt+ J, T | Go to the Table Tab |
Alt+ X, 1 | Go to the External Data Tab |
Alt+ X, 2 | Go to the Add-ins Tab, if present |
Alt+ Y, 2 | Go to the Database Tools Tab |
Alt+ Q | Go to the Tell me Box on the Ribbon |
Read : Sublime Text 3 all Keyboard Shortcuts.
Read : Computer Shortcut Keys.
Find and Replace :
Shortcut Key | Task |
---|---|
Ctrl+ F | Find Dialog Box |
Ctrl+ H | Find and Replace Tool |
Shift+ F4 | Find Next |
Alt+ Ctrl+ F | Go to the Navigation Pane Search Box from Anywhere in the Database |
Controls :
Shortcut Key | Task |
---|---|
Ctrl+ C | Copy |
Ctrl+ X | Cut |
Ctrl+ V | Paste |
→ | Move the Selected Control to the Right by a pixel along the page's grid |
← | Move the Selected Control to the Left by a pixel along the page's grid |
↑ | Move the Selected Control to the Up by a pixel along the page's grid |
↓ | Move the Selected Control to the Down by a pixel along the page's grid |
Ctrl+ → | Move the Selected Control to the Right by a pixel (irrespective of the page's grid) |
Ctrl+ ← | Move the Selected Control to the Left by a pixel (irrespective of the page's grid) |
Ctrl+ ↓ | Move the Selected Control to the Down by a pixel (irrespective of the page's grid) |
Ctrl+ ↑ | Move the Selected Control to the Up by a pixel (irrespective of the page's grid) |
Shift+ → | Increase the width of the Selected Control to the Right by a pixel |
Shift+ ← | Increase the width of the Selected Control to the Left by a pixel |
Shift+ ↓ | Increase the Height of the Selected Control from the bottom by a pixel |
Shift+ ↑ | Decrease the Height of the Selected Control from the bottom by a pixel |
Menu :
Shortcut Key | Task |
---|---|
Shift+ F10 | Show the Shortcut Menu |
Alt | Show the Access Keys |
Alt+ Space bar | Show the Program Icon Menu |
↓ | Select the Previous Command in Menu |
↑; | Select the Next Command in Menu |
→ | Select the Menu to the Right |
← | Select the Menu to the Left |
Home | Select the first Command in Menu |
End | Select the Last Command in Menu |
Esc | Cancel |
Open and Save database:
Shortcut Key | Task |
---|---|
Ctrl+ N | Open a New database |
Ctrl+ O | Open an Existing database |
Enter | Open the selected Folder or File |
Backspace | Open the Folder one level above the selected folder |
Delete | Delete the selected Folder or File |
Shift+ F10 | Display a Shortcut menu for a Selected item such as a Folder or File |
Tab | Move Forward through Option |
shift+ Tab | move backwards through Options |
Alt+ I or F4 | Open the Look in list |
Ctrl+ S / Shift+ F12 | Save a database Object |
Alt+ F, S | Open the Save As Dialog Box |
Wizards :
Shortcut Key | Task |
---|---|
Tab | Toggle the Focus Forward between Controls in the Wizard |
Alt+ N | Move to the Next page of the Wizard |
Alt+ B | Move to the Previous Page of the Wizard |
Alt+ F | Complete the Wizard |
Dialog Box :
Shortcut Key | Task |
---|---|
Tab | Move to the Next |
Shift+ Tab | Move to Previous Option or Option Group |
Ctrl+ Tab | Switch to Next Tab |
Ctrl+ Shift+ Tab | Switch to Previous Tab |
Arrow Keys | Move between Options in the Selected Drop-down list box or Move between Options in a Group of Options |
Spacebar | Select Current Button |
Alt+ ↓ | Open the selected Drop-down List Box |
Esc | Close the Selected Drop-down List Box |
Enter | Perform the action assigned to the default button in the Dialog Box |
Alt+ F4 | Close a Dialog Box |
Text Box :
Shortcut Key | Task |
---|---|
Home | Move to beginning of an Entry |
End | Move to End of an Entry |
Ctrl+ → | Move to One Word Right |
Ctrl+ ← | Move to One Word Left |
Shift+ ← | Extend Selection One character to the Left |
Shift+ → | Extend Selection One character to the Right |
Shift+ Home | Select from cursor to beginning |
Shift+ End | Select from cursor to End |
Field List Pane :
Shortcut Key | Task |
---|---|
Alt+ F8 | Toggle the Field List Pane |
Enter | Add the selected Field to the form or Report detail section |
Shift+ Tab | Move to the upper Field List pane from the Lower pane |
Tab | Move to the Lower Field List pane from the upper Pane |
Read : Elon Musk Biography in Hindi.
Read : Virat Kohli Biography in Hindi.
Select and move Fields or Columns :
Shortcut Key | Task |
---|---|
F2 | Switch between Edit mode (with insertion point displayed) and Navigation mode in a datasheet or design View |
Shift+ Spacebar | Switch between selecting the Current record and the First Field of the Current record |
Ctrl+ A | Select All |
F8 | Turn on Extend Mode |
← / → | Extend a selection to adjacent fields in the same row in Datasheet view |
↑ / ↓ | Extend a selection to adjacent rows in Datasheet view |
Shift+ F8 | Undo the Previous Extension |
Esc | Cancel Extend Mode |
Ctrl+ Spacebar | Select the Current Column |
Shift+ → | Select the Column to the Right (if the current column is selected) |
Shift+ ← | Select the Column to the Left (if the current column is selected) |
Ctrl+ Shift+ F8 | Turn on Move Mode |
Edit Text and Data :
Shortcut Key | Task |
---|---|
→ | Move the insertion point one character to the Right |
← | Move the insertion point one character to the Left |
Ctrl+ → | Move the insertion point one word to the Right |
Ctrl+ ← | Move the insertion point one word to the Left |
End | Move the insertion point to the end of the field |
Ctrl+ End | Move the insertion point to the end of the field, in multiline fields |
Home | Move the insertion point to the beginning of the field |
Ctrl+ Home | Move the insertion point to the beginning of the field, in multiline fields |
Insert Data :
Shortcut Key | Task | |
---|---|---|
Ctrl+ ; | Insert the Current Date | |
Ctrl+ : | Insert the Current time | |
Ctrl+ Alt+ Spacebar | Insert the Default Value for a Field | |
Ctrl+ ' | Insert the Value from the ame field in the Previous record | |
Ctrl+ Plus(+) | Add a new record | |
Ctrl+ Minus(-) | Insert a Datasheet, Delete the Current record | |
Shift+ Enter | Save Changes to the Current record | |
Spacebar | Switch between the values in the check box or option button | |
Ctrl+ Enter | Insert a new Line |
Refresh Fields :
Shortcut Key | Task |
---|---|
F9 | Recalculate the fields in the window or the contents of a Lookup Field |
Shift+ F9 | Require the underlying Tables |
Copy, Cut, Undo, Redo and Delete Text :
Shortcut Key | Task |
---|---|
Ctrl+ C | Copy the Selection to the Clipboard |
Ctrl+ X | Cut the selection and Copy it to the Clipboard |
Ctrl+ V | Paste the Contents of the clipboard at the insertion point |
Backspace | Delete the Selection or the character to the left of the insertion point |
Delete | Delete the Selection or the character to the Right of the insertion point |
Ctrl+ Delete | Delete all characters to the Right of the insertion point |
Ctrl+ Z or Alt+ Backspace | Undo |
Ctrl+ Y | Redo |
Design View :
Shortcut Key | Task |
---|---|
F2 | Switch between Edit and Navigation mode |
F4 | Toggle the property sheet |
F5 | Switch to Form view to from Form Design view |
F6 | Switch between the Windows, or between Design Panes / Properties / etc |
F7 | Open the Visual Basic Editor from a selected property in the property sheet for a form or report |
Alt+ F8 | Invokes the Field List pane in a form, report, or data access page. If the Field List pane is already open, focus moves to the Field List pane. |
Shift+ F7 | Switch to Form or Report Design View (from Visual Basic Editor with code module open) |
Alt+ Enter | Display a Property sheet |
Navigate in Datasheet, Subdatasheet, and Form View :
Shortcut Key | Task |
---|---|
F5 | Move to the Record Number Box |
Tab | Move to Next |
Shift+ Tab | Move to Previous Field in Current record |
Home | Move to First field in Current record |
End | Move to Last field in Current record |
↑ | Move to Next record |
↑ | Move to Previous record |
Ctrl+ ↓ | Move to Last record |
Ctrl+ ↑ | Move to First record |
Ctrl+ Home | Move to the First field in the First record |
Ctrl+ End | Move to the Last field in the Last record |
Page Up | Move Up One Screen |
Page Down | Move Down One Screen |
Ctrl+ Page Up | Move Left One Screen |
Ctrl+ Page Down | Move Right One Screen |
Ctrl+ Tab | In Subdatasheet: Exist to Next record |
Ctrl+ Shift+ Tab | In Subdatasheet: Exist to Previous record |
Ctrl+ Shift+ ↓ | Expand Subdatasheet |
Ctrl+ Shift+ ↑ | Collapse Subdatasheet |
Alt+ F5 | Move from Subdatasheet to record number box |
Database Diagram :
Shortcut Key | Task |
---|---|
Enter | Move from a Table's title bar to the Last cell you Edited |
Esc | Move from a Table cell to the Table's title bar |
Tab | Move from Table title bar to title bar, or from cell to cell inside a table |
Alt+ ↓ | Expand a list inside a Table |
↑ | Move Up in a List |
↓ | Move Down in a List |
Home | Go tothe First cell in a row |
End | Go to the Last cell in a row |
Spacebar | Change the Setting in a Check box |
Page Up | Go to Previous page of the Diagram |
Page Down | Go to Next page of the Diagram |
Query Designer :
Shortcut Key | Task |
---|---|
Tab | Move forward among Tables, Views, Functions, or Join Line |
Shift+ Tab | Move backwards among Tables, Views, Functions, or Join Line |
F6 | Move forward among the Query Designer Panes |
Shift+ F6 | Move backwards among the Query Designer Panes |
F2 | In grid pane: Toggle between Edit mode and cell selection mode |
Delete | remove the selected table, View, or Function, or Join Line |
Arrow Keys | Move between columns in a Table, View, or Function |
Spacebar | Close the selected data column for output |
Pivot Table :
Shortcut Key | Task |
---|---|
Shift+ Arrow Keys | Expand Selection |
Ctrl+ A | Select All |
Shift+ F10 | Display Context Menu |
Alt+ Enter | Display Property Dialog box |
Alt+ F4 | Close Property Dialog box |
Ctrl+ E | Export Contents to Excel |
Alt+ ↓ | Open list for Currently Selected item |
Ctrl+ T | Toggle AutoFilter |
Ctrl+ Shift+ A | Short Data ascending (A-Z) |
Ctrl+ Shift+ Z | Short Data descending (Z-A) |
Alt+ Shift+ ↑ | Move Selected member up |
Alt+ Shift+ Down | Move Selected member down |
Alt+ Shift+ ← | Move Selected member left |
Alt+ Shift+ → | Move Selected member right |
ctrl+ L | Display Field List Pane |
Ctrl+ Shift+ S | Add New Total Field using sum Summary |
Ctrl+ Shift+ C | Add New Total field using Count Summary |
Ctrl+ Shift+ M | Add New Total field using Minimum Summary |
Ctrl+ Shift+ X | Add New Total field using Maximum Summary |
Ctrl+ Shift+ E | Add New Total field using Average Summary |
Ctrl+ Shift+ D | Add New Total field using Standard Deviation Summary |
Ctrl+ Shift+ T | Add New Total field using standard Deviation population summary |
Ctrl+ Shift+ B | Turn Subtotals and Grand totals on or off for selected field |
Ctrl+ F | Add a Calculated Detail field |
Ctrl+ 1 | Move Selected field to row area |
Ctrl+ 2 | Move Selected field to column area |
Ctrl+ 3 | Move Selected field to filter area |
Ctrl+ 4 | Move Selected field to detail area |
Ctrl+ Shift+ ~ | Apply the General number format to values |
Ctrl+ Shift+ % | Apply the Percentage format to values |
Ctrl+ Shift+ # | Apply the Date format to values |
Ctrl+ Shift+ @ | Apply the Time format to values |
Ctrl+ Shift+ ^ | Apply the Exponential number format to values |
Ctrl+ Shift+ $ | Apply the Currency format to values |
Ctrl+ Shift+ ! | Apply the numeric format, with two decimal places, thousands separator, and a minus sign for negative values, to values in the selected total or detail field |
Ctrl+ B | Make Text Bold |
Ctrl+ U | Make Text Underline |
Ctrl+ I | Make Text Italic |
Read : What is Computer ? Full Explanation in Hindi.
Read : What is CPU ? Full Explanation in Hindi.
Manage Windows :
Shortcut Key | Task |
---|---|
F11 | Toggle the Navigation pane |
Enter | Restore the selected minimised window when all windows are minimised |
Ctrl+ F6 | Cycle between open window |
Ctrl+ F8 | Turn on Resize mode for the active window when it is not maximised LK; press the arrow keys to Resize the window |
Alt+ Spacebar | Display thye Control Menu |
Shift+ F10 | Display the Shortcut Menu |
Ctrl+ W | Close the Active window |
Ctrl+ F4 | Close the Active window |
Alt+ F11 | Switch between the Visual Basic Editor and the previous active window |
Help Window :
Shortcut Key | Task |
---|---|
Tab | Go to Next Text or Hyperlink |
Shift+ Tab | Go to Previous Text or Hyperlink |
Ctrl+ P | Open the Print Dialog Box |
Shift+ F10 | Show Context Menu |
Other Shortcuts :
Shortcut Key | Task |
---|---|
F7 | Check Spelling |
F2 | Display Hyperlink |
Shift+ F2 | Open the Zoom Box |
Ctrl+ F2 | Invoke a Builder |
Alt+ Enter | Display a Property Sheet in Design View |
Ctrl+ → | Toggle Forward betweeen Views when in a table, or Other Elements |
Ctrl+ ← | Toggle backwards betweeen Views when in a table, or Other Elements |
Post a Comment