Microsoft Access Keyboard shortcut

[mesterio]

Hi guys,, I need some knowledge about keyboard shortcuts for Microsoft Access. I need to work on Access and it takes long time working with mouse.Please let me know the shortcuts regarding:-

• Moving the insertion point in a field
• Formatting Elements in PivotTable View
• Working with the Field List
• Working in the Query Designer in an Access Project

Please to this favor soon. Thanks in advance.

[JonathanD]

For keyboard shortcuts in which you press two or more keys together, the keys to press are separated by a plus sign. A small tip for using shortcut is Press the ALT key. Badges showing the Key Tips appear. Now Press the key for the tab or Quick Access Toolbar command you want.If you then press a Quick Access Toolbar command Key Tip, the command is executed. If you press a tab Key Tip (e.g. H for Home), you see the Key Tips for every command on that tab.

1. Keyboard shortcut for moving the insertion point in a field in Access are as follow:-


RIGHT ARROW
Move one character to the right.

LEFT ARROW
Move one character to the left.

CTRL+RIGHT ARROW
Move one word to the right.

CTRL+LEFT ARROW
Move one word to the left.

END
Move to the end of the field, in a single-line field.

HOME
Move to the beginning of the field, in a single-line field.

CTRL+END
Move to the end of the field, in a multi-line field.

CTRL+HOME
Move to the beginning of the field, in a multi-line field.


2. Shortcuts for Formatting Elements in PivotTable View

CTRL+SHIFT+~ (tilde)
apply the general number format to values in the selected total or detail field

CTRL+SHIFT+$
apply the currency format, with two decimal places and negative numbers in parentheses, to values in the selected total or detail field

CTRL+SHIFT+%
apply the percentage format, with no decimal places, to values in the selected total or detail field

CTRL+SHIFT+^
apply the exponential number format, with two decimal places, to values in the selected total or detail field

CTRL+SHIFT+#
apply the date format, with the day, month, and year, to values in the selected total or detail field

CTRL+SHIFT+@
apply the time format, with the hour, minute, and AM or PM, to values in the selected total or detail field

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
To make text bold in the selected field of the PivotTable view.

CTRL+U
To make text underlined in the selected field of the PivotTable view

CTRL+I
To make text italic in the selected field of the PivotTable view

[JonathanD]

Shortcuts for Working with the Field List in MS Access:-

CTRL+L
To display the field list, or activate it if it's already displayed

Arrow keys
To move to the next item in the field list

SHIFT+UP ARROW
To move to the previous item and include it in the selection

SHIFT+DOWN ARROW
To move to the next item and include it in the selection

CTRL+UP ARROW
To move to the previous item, but don't include the item in the selection

CTRL+DOWN ARROW
To move to the next item, but don't include the item in the selection

CTRL+SPACEBAR
To remove the item from the selection if the item that has focus is included in the selection, and vice versa

PLUS SIGN (on the numeric keypad)
To expand the current item in the field list to display its contents, or expand Totals to display the available total fields

MINUS SIGN (on the numeric keypad)
To collapse the current item in the field list to hide its contents, or collapse Totals to hide the available total fields.

The TAB key
To move to the most recently selected item, the Add to button, and the list next to the Add to button in the field list

ALT+DOWN ARROW (use the arrow keys to move to the next item in the list; press ENTER to select the item)
To open the drop-down list next to the Add to button in the field list

ENTER
To add the highlighted field in the field list to the drop area that's displayed in the Add to list

ALT+F4
To close the field list


Working in the Query Designer in an Access Project

Navigating the Diagram Pane

TAB, or SHIFT+TAB
To move among tables, views, and functions (and to join lines, if available)

Arrow keys
To move between columns in a table, view, or function

SPACEBAR or PLUS key
To choose the selected data column for output

SPACEBAR or MINUS key
To remove the selected data column from the query output

DELETE
To remove the selected table, view, or function, or join line from the query


Navigating Page View

SPACE or ENTER
To expand or collapse a group of records corresponding to the expand indicator in a grouped data access page.

TAB or SHIFT+TAB
To select a button on the record navigation toolbar

SPACE or ENTER
To activate the selected button on the record navigation toolbar

[labman]

Really very useful info for the MS Access user. Shortcuts for the common task like copy, paste, find, etc.. are same as excel and word.

Thanks for sharing the this tutorial.