 |
|||
|
|
MS-Access Shortcut Keys - 3 |
||
|
|
Navigating in Datasheet View |
||
|
|
PAGE DOWN |
Display the next screen of data downward. |
|
|
|
PAGE UP |
Display the next screen of data upward. |
|
|
|
CTRL + PAGE DOWN |
Display the next screen of data to the right. |
|
|
|
CTRL + PAGE UP |
Display the next screen of data to the left. |
|
|
|
Working with Subdatasheets |
||
|
|
CTRL + SHIFT + ↓ |
Expand the sub datasheet. |
|
|
|
CTRL + SHIFT + ↑ |
Collapse the sub datasheet. |
|
|
|
TAB |
Move from the last field of the previous record to the sub datasheet. |
|
|
|
SHIFT + TAB |
Move from the first field of the following record to the sub datasheet. |
|
|
|
CTRL + TAB |
Move from the sub datasheet to the first field of the next record. |
|
|
|
CTRL + SHIFT + TAB |
Move from the sub datasheet to the last field of the previous record. |
|
|
|
Navigating in Print Preview |
||
|
|
F5 |
Select the page number box. |
|
 |
PAGE DOWN, ↓ |
Display the next page. |
|
|
PAGE UP, ↑ |
Display the previous page. |
||
|
←, →, ↑, ↓ |
Scroll in small increments. |
||
|
CTRL + ↑ |
Scroll to the top of the page. |
||
|
CTRL + ↓ |
Scroll to the bottom of the page. |
||
|
CTRL + →, END |
Scroll to the right side of the page. |
||
|
CTRL + ←, HOME |
Scroll to the left side of the page. |
||
|
CTRL + HOME |
Scroll to the upper-left corner of the page. |
||
|
CTRL + END |
Scroll to the lower-right corner of the page. |
||
|
Navigating in the Database Diagram Window |
|||
|
ESC |
Move to the table's title bar from a cell. |
||
|
ENTER |
Move back to the last cell edited from the table's title bar. |
||
|
PAGE UP |
Display the previous page of the table or diagram. |
||
|
PAGE DOWN |
Display the next page of the table or diagram. |
||
|
Moving Columns in Datasheet View |
|||
|
CTRL + SHIFT + F8 |
Switch on Move mode. |
||
|
←, → |
Move the selected Columns to the left and right in Move mode. |
||
|
Working in the Gird Pane |
|||
|
F2 |
Toggle between Edit mode and Navigation mode. |
||
|
Insert |
Toggle between Insert mode and Overstrike mode. |
||
|
PivotTable View |
|||
|
TAB |
Select the next element to the right or down. |
||
|
SHIFT + TAB |
Select the next element to the left or up. |
||
|
ENTER |
Select the next element or to the right. |
||
|
SHIFT + ENTER |
Select the next element up. |
||
|
CTRL + ENTER |
Select the detail cells for the next item in the row area. |
||
|
CTRL + SHIFT + ENTER |
Select the detail cells for the previous item in the row area. |
||
|
CTRL + SHIFT + END |
Extend the selection to the last cell in the last row. |
||
|
CTRL + SPACEBAR |
Select the field for the active data, total, or detail item. |
||
|
SHIFT + SPACEBAR |
Select the row containing the active cell. |
||
|
SHIFT + PAGE DOWN |
Extend the selection by one screen. |
||
|
SHIFT + PAGE UP |
Reduce the selection by one screen. |
||
|
ALT + PAGE DOWN |
Display the next screen to the right. |
||
|
ALT + PAGE UP |
Display the next screen to the left. |
||
|
ALT + SHIFT + PAGE DOWN |
Extend the selection by one page to the right. |
||
|
ALT + SHIFT + PAGE UP |
Extend the selection by one page to the left. |
||
|
CTRL + E |
Export the contents of the PivotTable or Excel. |
||
| Previous | |||
|
A Web Designed by M.Mohan Rao, E-mail:- cheers.mohan@gmail.com |
|||
|
Windows XP || MS-Notepad || MS-WordPad || MS-Paint || MS-Word || MS-Excel || MS-PowerPoint || MS-Access || MS-Outlook || MS-FrontPage || Adobe PhotoShop || Adobe Flash || Adobe PageMaker || Adobe CorelDraw || Internet Explorer || Mozilla Firefox || |
|||
|
Copyright 2010 © www.shortcutkeys.50webs.com |
|||
