This article applies only to a Microsoft Access database (.mdb).
Shortcut |
Command |
|
ALT |
Close the visible menu and submenu at the same time;
works with menu commands. |
|
ALT+ letter key, where key is the underlined
letter in the field or menu cmnd |
Select a menu or select or clear the check box by the letter
underlined in the menu command; works within windows and dialog boxes. |
|
ALT 1 |
Go to previous folder; use within the Open, File New
Database and Export dialog boxes in Microsoft Access. |
|
ALT+2 |
Open the folder one level up from the open folder (Up One Level
button); use within the Open, File New Database and Export dialog boxes. |
|
ALT+3 |
Close the open dialog box and opens your World Wide
Web search page (Search the Web button); use when working in the Open, File
New Database and Export dialog boxes. |
|
ALT+4 |
Delete the selected folder or file; use within the Open, File New
Database and Export dialog boxes. |
|
ALT+5 |
Create a new subfolder in the open folder; use
within the Open, File New Database and Export dialog boxes. |
|
ALT+6 |
Switch between List, Details, Properties, and Preview views (click
the arrow next to Views); use within the Open, File New Database and Export
dialog boxes. |
|
ALT 7 |
Display the Tools menu; use within the Open, File
New Database and Export dialog boxes in Microsoft Access. |
|
ALT+A |
Open Answer Wizard (In Help menu); use within Help menu. |
|
ALT+A and ENTER |
Use from the field list to add table and fields to
the data access page when working in Design view. |
|
CTRL+SHFT+RIGHT ARROW |
Select or unselect one word to the right of the cursor. |
|
CTRL SHFT TAB |
Exit the subform and move
to the previous field in the main form or previous record in Microsoft
Access. |
|
CTRL+SHFT+F8+LEFT ARROW |
Activate Move mode; then press the LEFT ARROW key to move selected
columns to the left. |
|
CTRL SHFT TAB |
Go to the previous tab when working in Help dialog
box in Microsoft Access. |
|
CTRL+SHFT+TAB |
Exit the subdatasheet and move to the first
field of the following record in the datasheet. |
|
CTRL+SHFT+TAB or CTRL+PAGE UP |
Go to the previous tab when working in a tabbed
dialog box. |
|
CTRL SHFT UP ARROW |
Collapse the subdatasheet in Microsoft
Access. |
|
ALT+C |
Display Contents dialog box; use within Help menu. |
|
ALT+DOWN ARROW |
Display more Help topics; works when using Office
Assistant. |
|
ALT+DOWN ARROW |
Expand a list inside a table while working in a Database Diagram. |
|
ALT+DOWN ARROW |
Open a selected drop-down menu; works within a
dialog box. |
|
ALT+ENTER |
Display the properties of a selected item while working in a window. |
|
ALT ENTER |
Display the PivotTable Property Toolbar in Microsoft
Access. |
|
ALT+F+D+A |
Send the active database object as an E-Mail message. |
|
ALT+F11 |
Switch between the Visual Basic Editor and the
previous window; works within a window. |
|
ALT+F4 |
Quit Microsoft Access, close a dialog box, or close a property sheet;
works within an open window. |
|
ALT F4 |
Close the active Help window in Microsoft Access. |
|
ALT+F4 |
Close the PivotTable Property Toolbar. |
|
ALT I |
Switch to Index tab while working in Help menu in
Microsoft Access. |
|
ALT+K |
Check the names in the To, Cc and Bcc fields against the Address Book
while sending an E-Mail. |
|
ALT LEFT ARROW |
Go to a previously viewed Help topic in Microsoft
Access. |
|
ALT+N |
Create a new table, query, form, report, data access page, macro, or
module when working with a database or spreadsheet. |
|
ALT+number |
Select a Help topic while using Office Assistant.
(where hitting key for 1 selects the leftmost option, 2 the next, and so on) |
|
ALT+O |
Display Options dialog box (in Help menu). |
|
ALT+PAGE DOWN |
Display the next screen to the right while working
within Pivot Table Wizard. |
|
ALT+PAGE UP |
Display the previous screen to the left while working within Pivot
Table Wizard. |
|
ALT RIGHT ARROW |
Go to a previously viewed a Help topic while in the
Help dialog box in Microsoft Access. |
|
ALT+SHFT+F11 |
Move between the Microsoft Script Editor window and the previous
window. |
|
ALT+SHFT+TAB |
Move from active application window to previously
active application window. |
|
ALT+SPACEBAR |
Open the menu of the leftmost icon on the main toolbar bar of the
active window; this menu typically contains the following commands: Restore,
Move, Size, Minimize, Maximize and Close. |
|
ALT+SPACEBAR |
Display the Control menu while working from Help
menu. |
|
ALT SPACEBAR |
Display the Control menu while working from Help menu in Microsoft
Access. |
|
ALT+TAB |
Move from active application window to the
previously used application window; to select an application from a list of
the open applications, hold ALT down and press TAB more than once to move
through the list. |
|
ALT+UP ARROW |
Display previously viewed Help topics while using Office Assistant. |
|
CTRL+SHFT+B |
Open the Address Book when sending an E-Mail. |
|
CTRL SHFT DOWN ARROW |
Expand a record's subdatasheet from the
datasheet in Microsoft Access. |
|
CTRL+SHFT+F6 |
Go to the previous database window. |
|
CTRL+SHFT+F8+RIGHT ARROW |
Activate Move mode; then press the RIGHT ARROW key to move selected
columns to the right. |
|
CTRL+SHFT+LEFT ARROW |
Select or unselect one word to the left of the
cursor. |
|
CTRL+SHFT+LEFT ARROW |
To extend selection one word to the left. |
|
CTRL+SPACEBAR |
Select or unselect the active column, in Navigation
mode only. |
|
CTRL+SPACEBAR |
Select an entire grid column while navigating in the Query Designer -
Grid Panes mode. |
|
CTRL SPACEBAR |
Select the field for the currently selected item of
data, total or detail cell when working in a Pivot Table list in Microsoft
Access. |
|
CTRL+TAB |
Move through the tabs of each object's type when navigating and
opening objects in Access. |
|
CTRL+TAB |
Exit the subform and move
to the next field in the master form or next record when working in Form
view. |
|
CTRL+TAB |
Move to the next tab on a tabbed, Help dialog box. |
|
CTRL+TAB |
Exit the subdatasheet and
move to the last field of the previous record in the datasheet. |
|
CTRL+TAB or CTRL+PAGE DOWN |
Move to the next tab on a tabbed dialog box. |
|
CTRL TAB or CTRL SHFT TAB |
Select the next or previous toolbar in Microsoft
Access. |
|
CTRL+UP ARROW |
Move to the current field in the first record, in Navigation mode. |
|
CTRL+UP ARROW |
Move to the top of the active page when working in
Access Print Preview and Layout Preview mode. |
|
CTRL+UP ARROW |
Move the selected control up when working in Access Form and Report
Design view. |
|
CTRL+UP ARROW |
Move to the first row in the current column when
working in Access Query Designer -Grid Panes mode. |
|
CTRL+UP ARROW |
Move the selected control up by a pixel (regardless of the page's
grid) when working in Access Design view. |
|
CTRL+V |
Paste a copied item(s) from the Clipboard into a
selected location (You also can choose Paste from the Edit menu.). |
|
CTRL V |
Paste the contents of the Clipboard in the upper-left corner of the
selected section when working in Form and Report Design view in Microsoft
Access. |
|
CTRL+V |
Paste a copied item(s) from the Clipboard into a
selected location when working in Query Designer-Grid Panes (You also can
choose Paste from the Edit menu.). |
|
CTRL+V |
Paste a copied item(s) from the Clipboard into a selected location
when working in dat access page Design view (You
also can choose Paste from the Edit menu). |
|
CTRL+W or CTRL+F4 |
Close the active datasheet window. |
|
CTRL+X |
Copy and remove the selected item(s) from their original location to
the Clipboard. (You also can choose the Cut command from the Edit menu.). |
|
CTRL+Z or ALT+BACKSPACE |
Undo the last action; note: some actions, like
Shutdown, cannot be undone (You also can choose Undo from the Edit menu.). |
|
DELETE |
Delete the selected item(s), or to delete the character to the right
of the cursor; if items are files they will be moved to the Recycle Bin. |
|
DELETE |
Delete the selected item(s), or to delete the
character to the right of the cursor; if items are files they will be moved
to the Recycle Bin. |
|
DOWN ARROW |
To move down one line in a Combo box, list box or Database window in
Microsoft Access. |
|
DOWN ARROW |
Move to the same field in the next record when
navigating in Access Datasheet view. |
|
DOWN ARROW |
Scroll down a window or document in small increments when working in
Access Print Preview or Layout Preview. |
|
DOWN ARROW |
Select the next book or Help topic in Microsoft
Access. |
|
DOWN ARROW |
Scroll toward the end of a Help topic. |
|
DOWN ARROW |
Scroll through the items in a drop-down list, moving
from top to bottom. |
|
DOWN ARROW |
Use when starting from the datasheet in order to bypass the subdatasheet and move to the next record in the
datasheet. |
|
DOWN ARROW or UP ARROW (with the menu or submenu
displayed) |
Select the next or previous command on the menu or
submenu. |
|
END |
Go to the end of the entry when editing a text box. |
|
END |
Go to the last object in database window in
Microsoft Access. |
|
END |
Go to the end of the field, in single-line fields. |
|
END |
Go to the last field in the current record, when
working in Access Navigation mode. |
|
END |
Go to the end of a Help topic. |
|
END |
Go to the last cell in the row or to the end of the
active cell. |
|
END OR CTRL+RIGHT ARROW |
Move to the right edge of the page when working in Access Print
Preview and Layout Preview. |
|
ENTER |
Perform the action assigned to the selected default
button in a dialog box. |
|
ENTER |
Restore a selected minimized program window when all windows are minimized.
|
|
ENTER |
Open the selected table or query in Datasheet view,
or form in Form view. |
|
ENTER |
Open the selected report in Print Preview in Microsoft Access. |
|
ENTER |
Run a selected macro. |
|
ENTER |
Open the selected data access page in Page Preview. |
|
ENTER |
Open or close a selected book, or open a selected
Help topic. |
|
ENTER |
Activate a selected hyperlink in Microsoft Access. |
|
ENTER |
Move from a table's title bar to the last cell
edited in a Database Diagram. |
|
ENTER |
Select an item in a list and move to the next cell in a Database
Diagram. |
|
ENTER |
Perform the action assigned to a selected button on
a toolbar. |
|
ENTER |
Open a selected menu on a toolbar. |
|
ENTER |
Enter text in a selected text box. |
|
ENTER or ALT+O |
Open the selected table or query in Datasheet view, or form in Form
view. |
|
ESC |
Close the visible menu; or, with a submenu visible,
close the submenu only. |
|
ESC |
Cancel a command and close the dialog box in Microsoft Access. |
|
ESC |
Close an Office Assistant message or tip. |
|
ESC |
Cancel Extend mode command. |
|
ESC |
Undo changes in the current field or current record;
if both have been changed, press ESC twice to undo changes first in the
current field and then in the current record. |
|
ESC |
Close a pop-up window in Help in Microsoft Access. |
|
ESC |
Move from a table cell to the table's title bar when
working in database Diagram. |
|
ESC |
Close a shortcut menu without carrying out a command when working in
a Pivot Table. |
|
ESC |
Cancel a Refresh command in progress when working in
a Pivot Table. |
|
ESC (when a drop-down list box is selected) |
Close a selected drop-down list in a dialog box. |
|
F1 |
Display Help or the Office Assistant in Microsoft
Access. |
|
F1 |
Display the Office Assistant or Microsoft Access Contents and Index;
context-sensitive help about the selected property, control, macro action, or
Visual Basic keyword; or alerts with a Help button. |
|
F1 |
Display Help topics when working in a Pivot Table. |
|
F10 |
Activate, or select, the main toolbar beginning with the first
toolbar option on the left, usually File; after the first option is activated
you can navigate through toolbar and menu options using the appropriate ARROW
keys; press F10 or ALT again |
|
F11 or ALT+F1 |
Bring the Database window to the front. |
|
F12 or ALT+F2 |
Display Save As dialog box (file menu). |
|
F2 |
Display the complete hyperlink address for a
selected hyperlink. |
|
F2 |
Rename a selected object when working in Database window. |
|
F2 |
Move between Edit mode (with insertion point
displayed) and Navigation mode when working in Design view. |
|
F2 |
Move between Edit mode and Cell Selection mode when navigating in the
Query Designer -Grid Panes. |
|
F4 or ALT+DOWN ARROW |
Open a combo box. |
|
F5 |
Update the files visible in the Open or Save As dialog box (File
menu). |
|
F5 |
Move to Form view from Form design or a Form module
when working in Access Design view. |
|
F5 |
Navigate through records by moving cursor to the record number box,
typing the record number and pressing ENTER when working in Datasheet view. |
|
F5 |
Navigate through records by moving cursor to the
record number box, typing the record number and pressing ENTER when working
in Form view. |
|
F5 |
Navigate through pages by moving cursor to the page number box,
typing the page number and pressing ENTER when working in Print Preview and
Layout. |
|
F5 |
Refresh the current window (You also can choose
Refresh from the View menu.). |
|
F5 |
Navigate in subdatasheet records by moving
to the record number box, typing the record number and pressing ENTER. |
|
F6 |
Move between the upper and lower portions of a
window when working in Design view of tables, macros, and queries and the
Advanced Filter/Sort window only. |
|
F6 |
Move between the navigation pane and topic pane when working with
Help menu in Microsoft Access. |
|
F6,SHFT+F6 |
Use by pressing and then clicking anywhere in the
target pane when navigating the Query Designer - Any Pane. |
|
F7 |
Display Spelling and Grammar dialog box (Tools Menu). |
|
F8 |
Activate Extend mode; EXT appears in the lower right
corner of the window; pressing F8 repeatedly extends the selection to the
word, the field, the record (in Datasheet view only), and all records; press
ESC to cancel. |
|
F9 |
Refresh the contents of a Lookup field list box or combo box. |
|
F9 |
Recalculate the fields in the window in Microsoft
Access. |
|
F9 |
Refresh the PivotTable list from the source data. |
|
HOME |
Go to the beginning of the current entry. |
|
HOME |
Go to the first object. |
|
HOME |
Go to the beginning of the current field, in single-line
fields. |
|
HOME |
Go to the first field in the current record, when in Access
Navigation mode. |
|
HOME |
Go to the beginning of a Help topic, with Help
dialog box open. |
|
HOME |
Go to the first cell in the row, or to the beginning of the current
cell. |
|
HOME or CTRL LEFT ARROW |
Go to the left edge of the current page in Microsoft
Access. |
|
HOME or END |
Select the first or last command on the menu or submenu. |
|
INSERT |
Toggle between insert and overstrike mode while
editing a cell. |
|
INSERT after you select any Or... column |
Insert an Or... column when navigating the Access Query Designer -
Grid Panes mode. |
|
INSERT after you select grid row |
Insert a row between existing rows when navigating
the Access Query Designer - Grid Panes mode. |
|
LEFT ARROW |
Go one character to the left of the cursor's current position in the
field. |
|
LEFT ARROW |
Scroll to the left of the cursor's current position
in small increments when working in Print Preview and Layout Preview. |
|
LEFT ARROW or RIGHT ARROW |
With a menu open, select the menu to the left or right of the
original, or, with a submenu visible, switch between the main menu and the
submenu. |
|
LEFT ARROW or RIGHT ARROW |
Move one character to the left or right in a text
box. |
|
LEFT ARROW, or RIGHT ARROW |
Extend a selection to adjacent fields in the same row in Microsoft
Access Datasheet view. |
|
LEFT or RIGHT ARROW |
Select a button on the record navigation toolbar
when working in Access Page View. |
|
Letter key, where the letter is the same as the
first letter in optn you want on a selected menu, |
Choose a selected menu, drop-down list, or dialog box option by
typing the first letter in the option name. |
|
P or CTRL+P |
To open the Print dialog box from Print Preview or
Layout Preview. |
|
PAGE DOWN |
Move down one page when using a Combo box or list box. |
|
PAGE DOWN |
Move down one window when working in Database view
in Microsoft Access. |
|
PAGE DOWN |
Scroll down one full screen when working in Print Preview and Layout
Preview. |
|
PAGE DOWN |
Scroll toward the end of a Help topic in larger
increments. |
|
PAGE DOWN |
When navigating a Database Diagram, scroll to the next page inside a
table or the next page of the diagram. |
|
PAGE DOWN |
When working in a Pivot Table list, display the next
screen. |
|
PAGE DOWN |
When navigating in Form view, go down one page; at the end of the
record, moves to the equivalent page on the next record. |
|
PAGE DOWN or DOWN ARROW |
In Print Preview and Layout Preview, view the next
page (when Fit To Window is selected). |
|
PAGE UP |
Move up one page when using a combo box or list box. |
|
PAGE UP |
Move up one window when working in Database. |
|
PAGE UP |
Go up one screen when working in Datasheet view in Microsoft Access. |
|
PAGE UP |
Go up one page when working in Form view; at the end
of the record, use to move to the equivalent page on the previous record. |
|
PAGE UP |
Scroll up one full screen when working in Print Preview and Layout
Preview. |
|
PAGE UP |
Scroll toward the beginning of a Help topic in
larger increments. |
|
PAGE UP |
When navigating a Database diagram, scroll to the previous page
inside a table or the previous page of the diagram. |
|
PAGE UP |
Display the previous screen when working with a
Pivot Table list in Microsoft Access. |
|
PAGE UP or UP ARROW |
In Print Preview and Layout Preview, view the previous page (when Fit
To Window is selected). |
|
RIGHT ARROW |
Move one character to the right of the cursor's
current position in a field. |
|
RIGHT ARROW |
In Print Preview and Layout Preview, scroll to the right in small
increments. |
|
S |
In Print Preview and Layout Preview, open the Page
Setup dialog box. |
|
SHFT+ARROW KEY |
Extend or reduce a selection in a Pivot Table list, depending on the
direction of the arrow key chosen. |
|
SHFT+CTRL+TAB |
Cycle through the tab of each object's type moving
right to left. |
|
SHFT DOWN ARROW |
Extend selection to the next record, if the current record is
selected in Microsoft Access. |
|
SHFT+DOWN ARROW |
Increase the height of the selected control when
working in Form and Report Design view. |
|
SHFT+END |
Select from the insertion point to the end of the text box entry. |
|
SHFT+ENTER |
Add a control to a section when working in Form and
Report Design view only. |
|
SHFT+ENTER |
Save changes to the current record when entering data in the
Datasheet or Form view. |
|
SHFT ENTER |
Add a control to a section when working in data
access page Design view in Microsoft Access. |
|
SHFT+F1 |
Display What's This? help; after pressing
SHFT+F1, move the pointer to the menu command, toolbar button, dialog box
option, or screen region to see definitions. |
|
SHFT+F10 |
Display a shortcut menu that shows a list of
commands relevant to the selected object. |
|
SHFT+F10 |
Display a shortcut menu that shows a list of commands relevant to the
selected object. |
|
SHFT+F10 |
Display the shortcut menu for the selected element
of the PivotTable list. |
|
SHFT+F2 |
Open the Zoom box to conveniently enter expressions and other text in
small input areas. |
|
SHFT+F4 |
Find the previous occurrence of the text specified
in the Find or Replace dialog box when the dialog box is closed. |
|
SHFT F8 |
Undo a previous selection extension in Microsoft Access. |
|
SHFT+F9 |
Requery the underlying
tables; in a subform, this requeries
the underlying table for the subform only. |
|
SHFT+HOME |
Select from the insertion point in the text box to the beginning of
the text box entry. |
|
SHFT+LEFT ARROW |
Select or unselect one character to the left of the
cursor's position. |
|
SHFT+LEFT ARROW |
Reduce the width of the selected control when working in Form an Report Design view. |
|
SHFT+LEFT ARROW |
Select the column to the left, if the current column
is selected, when working in Datasheet view. |
|
SHFT+PAGE DOWN |
Extend the selection one screen down. |
|
SHFT PAGE UP |
Reduce a selection by one screen when working with a
Pivot Table list in Microsoft Access. |
|
SHFT+RIGHT ARROW |
Select or unselect by one character to the right of the cursor's
current position. |
|
SHFT+RIGHT ARROW |
Increase the width of the selected control when
working in Form and Report Design view. |
|
SHFT+RIGHT ARROW |
Select the column to the right, if the current column is selected,
when working in Datasheet view. |
|
SHFT+SPACEBAR |
Switch between selecting the current record and the
first field of the current record, when working in Navigation mode. |
|
SHFT+SPACEBAR |
Select the entire row containing the currently selected cell when
working in a Pivot Table list. |
|
SHFT TAB |
Move to the previous option or option group in a
dialog box in Microsoft Access. |
|
SHFT+TAB |
Move to the previous field when navigating in Form view. |
|
SHFT+TAB |
Enter the subform from the
following field in the main form when navigating in Form view. |
|
SHFT+TAB |
Go to the last or previous hyperlink in Help. |
|
SHFT+TAB |
Select the previous field or button in the E-Mail
header. |
|
SHFT+TAB |
Enter the subdatasheet from the first field
of the following record in the datasheet. |
|
SHFT+TAB |
Select the previous field or the entire Pivot Table
list. |
|
SHFT+TAB, or LEFT ARROW |
Move to the previous field when navigating in Datasheet view. |
|
SHFT UP ARROW |
Extend selection to the previous record, if the
current record is selected in Microsoft Access. |
|
SHFT+UP ARROW |
Reduce the height of the selected control when working in Form and
Report Design view. |
|
SPACE or ENTER |
Expand or collapse a group of records corresponding
to the expand indicator in a grouped data access page. |
|
SPACE or ENTER |
Activate the selected button on the record navigation toolbar when
working in Page view. |
|
SPACEBAR |
Perform the action assigned to the active button, or
select or clear the active check box in the dialog box. |
|
SPACEBAR |
Switch between the values in a check box or option button. |
|
SPACEBAR |
Change the setting in a check box when navigating a
Database Diagram in Microsoft Access. |
|
SPACEBAR |
Toggle the check box in the Output column when navigating the Query
Designer-Grid Panes. |
|
SPACEBAR or MINUS SIGN |
Remove the selected data column form the query
output when navigating the Query Designer-Diagram Pane. |
|
SPACEBAR or PLUS SIGN |
Choose the selected data column form the query output when navigating
the Query Designer-Diagram Pane. |
|
TAB |
Move to the next option or option group in a dialog
box. |
|
TAB |
Exit the combo box or list box. |
|
TAB |
Select the next field in Microsoft Access. |
|
TAB |
Move to the next field when working in Form view. |
|
TAB |
To enter the subform from
the preceding field in the main form when working in Form view. |
|
TAB |
Go to the first or next hyperlink in Help. |
|
TAB |
Select the next box in the E-Mail header, or the
body of the message when the last box in the E-Mail header is active. |
|
TAB |
Move from table title bar to table title bar, or from cell to cell
inside a table, when navigating a Database Diagram. |
|
TAB |
Enter the subdatasheet
from the last field of the previous record in the datasheet in Microsoft
Access. |
|
TAB |
Move from the last field in the subdatasheet
to the next field in the datasheet. |
|
TAB |
Select each field and then the entire Pivot Table
list, going through these selections in sequence. |
|
TAB or SHFT+TAB (when a toolbar is active) |
When a toolbar is active, select the next or previous button or menu
on the toolbar. |
|
TAB, ENTER, or RIGHT ARROW |
Move to the next field when navigating in Datasheet
view in Microsoft Access. |
|
TAB, SHFT+TAB |
Move between input source windows (and to join lines, if available)
when navigating the Query Designer-Diagram Pane. |
|
LETTER KEY, where the key corresponds with the
underlined letter in an optn name |
Select and choose a command on the shortcut menu
when working in a Pivot table. |
|
UP ARROW |
Move up one line in a combo box or list box. |
|
UP ARROW |
Move up one line in a database window. |
|
UP ARROW |
Move to the current field in the previous record when navigating in
Datasheet view. |
|
UP ARROW |
Scroll up in small increments when working in Print
Preview and Layout Preview. |
|
UP ARROW |
Select the previous book or topic in Help in Microsoft Access. |
|
UP ARROW |
Scroll toward the beginning of a Help topic. |
|
UP ARROW |
Move to the previous item in a list when navigating in a Database
Diagram. |
|
UP ARROW |
Use from the datasheet to bypass the subdatasheet and move to the previous record in the
datasheet. |
|
UP ARROW or DOWN ARROW |
Move up or down in a drop-down list when navigating the Query
Designer - Grid Panes in Microsoft Access. |
|
UP ARROW, DOWN ARROW |
Extend a selection to adjacent rows in Datasheet
view. |
|
Z |
Zoom in or out on a part of the page when working in Print Preview
and Layout Preview. |
|
ARROW KEY |
Move between options in a selected drop-down menu or
dialog box or between some options in a group of options. |
|
ARROW KEY |
Move between columns in an input source window when working in the
Query Designer-Diagram Pane. |
|
ARROW KEY |
Move selected elements in the given direction of the
arrow key while working within a Pivot Table. |
|
ARROW KEYS or TAB or SHFT TAB |
Move between cells when working in the Query Designer-Diagram Pane in
Microsoft Access. |
|
ARROW KEY |
Move between options in a selected drop-down menu or
dialog box or between some options in a group of options; add ENTER to select
an option. |
|
BACKSPACE |
Delete selected text or to delete the character to the left of where
the cursor is positioned within a document while editing. |
|
C or ESC |
Cancel Print Preview or Layout Preview and return to
Normal view. |
|
CTRL+7 |
Display or hide the main toolbar of the active window. |
|
CTRL+A |
Select the entire Help topic when working in the
Help menu or dialog box. |
|
CTRL A |
Select the entire active Pivot Table list in Microsoft Access. |
|
CTRL+A or CTRL+SHFT+SPACEBAR |
Select all records in an active database. |
|
CTRL+ALT+SPACEBAR |
Insert the default value for a selected field when entering data in a
Datasheet or Form view. |
|
CTRL+APOSTROPHE (') |
Insert the value from the same field in the previous
record to the selected field in the current record within a database. |
|
CTRL C |
Copy selection to the Windows Clipboard in Microsoft Access. |
|
CTRL+C |
Copy the selected control to the Windows Clipboard. |
|
CTRL+C |
Copy the selected Help items to the Windows Clipboard when working in
Help menu. |
|
CTRL+C |
Copy selected text to the Windows Clipboard when
working in the Query Designer - Grid Panes. |
|
CTRL C |
Copy selected text to the Windows Clipboard when working in Design
View in Microsoft Access. |
|
CTRL+C |
Copy selected data from the Pivot Table list to the
Windows Clipboard when working in a Pivot Table. |
|
CTRL+COLON (:) |
Insert the current time at the cursor's current position. |
|
CTRL+DELETE |
Delete text to the end of the line in which the
cursor is positioned. |
|
CTRL+DOWN ARROW |
Move to the same field in the last record while in Navigation mode in
Datasheet view. |
|
CTRL+DOWN ARROW |
Move to the bottom of current page in which you are
working while in Print Preview and Layout Preview. |
|
CTRL DOWN ARROW |
Move the selected control down in the presentation while in Form and
Report Design view in Microsoft Access. |
|
CTRL+DOWN ARROW |
Move to the last row in the current column while
working in Query Designer-Grid Panes mode. |
|
CTRL+DOWN ARROW |
Move the selected control down by a pixel (irrespective of the page's
grid) while working in Data Access page in Design View. |
|
CTRL E |
Export the selected Pivot Table list to a Microsoft
Excel document in Microsoft Access. |
|
CTRL+END |
Move to the end of the active field, while working working with multiple-line fields in Access. |
|
CTRL+END |
Move to the last field in the last record while in
Navigation mode in Access. |
|
CTRL+END |
To move to the last field in the last record while in Navigation mode
and Form view in Access. |
|
CTRL+END |
Move to the lower-right corner of the page while
working in Print Preview and Layout Preview. |
|
CTRL+END |
Move to the last position in the current cell or the last column in
the active window while in Query Designer - Grid Panes view in Access. |
|
CTRL ENTER |
Insert a new line when entering data in Datasheet or
Form view in Microsoft Access. |
|
CTRL+ENTER or ALT+D |
To open the selected table, query, form, report, macro, or module
while working in Design view in Access. |
|
CTRL+ESC |
Display Windows Start menu. |
|
CTRL+F |
Display the Find dialog box while working in Access Datasheet view,
Form view or Module Window only. |
|
CTRL+F11 |
Toggle between a custom menu bar and a built-in menu
bar while working in Access. |
|
CTRL F2 |
Invoke a Builder while working in Microsoft Access. |
|
CTRL+F6 |
Go to the next database window in the active
application. |
|
CTRL F6 |
Move between open windows in Microsoft Access. |
|
CTRL+F8 |
Activate Resize mode for the active window when it
is not maximized; press the arrow keys ro resize
the window. |
|
CTRL+G |
Display the Immediate window in the Visual Basic Editor. |
|
CTRL+H |
To open the Replace dialog box (while in Datasheet
view, Form view, and Module Window only). |
|
CTRL+HOME |
Go to the beginning of the field, in multiple-line fields, when workin in Access. |
|
CTRL+HOME |
Go to the first field in the first record when
working in Navigation mode in Datasheet view. |
|
CTRL+HOME |
Go to the first field in the first record when working in Navigation
mode in Form view. |
|
CTRL+HOME |
Go to the upper-left corner of the page when in
Print Preview and layout Preview mode. |
|
CTRL+HOME |
Go to the first position in the active cell or the first column in
the active window when working in the Query Designer -Grid Panes. |
|
CTRL LEFT ARROW |
Move cursor's position one word to the left in
Microsoft Access. |
|
CTRL+LEFT ARROW |
Move the selected control to the left when working in Form and Report
Design view. |
|
CTRL+LEFT ARROW |
Move the selected control to the left by one pixel
(irrespective of the page's grid) when working in data access page Design
view. |
|
CTRL+LEFT ARROW or CTRL+RIGHT ARROW |
Move cursor's position one word to the left or right. |
|
CTRL+MINUS SIGN (-) |
Delete the current record when working in Datasheet
or Form view. |
|
CTRL N |
Open a new, blank, database in Microsoft Access. |
|
CTRL+O |
Display the Open dialog box in order to find and
open an existing database. |
|
CTRL+P |
Display the Print dialog box in order to print the active selection. |
|
CTRL+P |
Print the active Help topic. |
|
CTRL+PAGE DOWN |
Go right one screen. |
|
CTRL PAGE DOWN |
Go to the same field in the next record in Microsoft
Access. |
|
CTRL+PAGE UP |
Go left one screen when working in datasheet view in Access. |
|
CTRL+PAGE UP |
Go to the same field in the previous record. |
|
CTRL+PLUS SIGN (+) |
Add a new record while working in Datasheet or Form view in Access. |
|
CTRL+RIGHT ARROW |
Move cursor one word to the right. |
|
CTRL+RIGHT ARROW |
Move the selected control to the right when editing controls in Form
and Report Design view. |
|
CTRL+RIGHT ARROW |
Move the selected control to the right by a pixel
(irrespective of the page's grid) when working in data access page Design
view. |
|
CTRL S or SHFT F12 or ALT SHFT F2 |
Save a database object in Microsoft Access. |
|
CTRL+SEMICOLON (;) |
Insert the current date into active Datasheet or
Form view. |
No comments: