ACCESS 97 - 229 Keyboard Shortcuts
Close the visible menu and submenu at the same time; works with menu commands.
ALT
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+ letter key, where key
is the underlined letter in the field or menu command
Select an option in the Open or Save As dialog boxes (in File menu); works
within windows and dialog boxes. ALT+ number (where hitting key for 1 selects
the leftmost option, 2 the next, and so on)
Select the folder list in the Open and Save As dialog boxes (in File menu); use
within a dialog box; use arrow keys to select a folder in the list. ALT+0(ZERO)
Display the previous tip; use with Office Assistant. ALT+B
Display more Help topics; works when using Office Assistant. ALT+DOWN ARROW
Open a selected drop-down menu; works within a dialog box. ALT+DOWN ARROW
Display the properties of a selected item while working in a window. ALT+ENTER
Quit Microsoft Access, close a dialog box, or close a property sheet; works
within an open window. ALT+F4
Toggle between breaking and not breaking on unhandled errors and then step to
the next statement. ALT+F5
Activate Office Assistant while working in a document. ALT+F6; repeat until the
balloon is active
Toggle between breaking and not breaking in class modules and then continue
execution. ALT+F8
Display the next tip when working with Office Assistant. ALT+N
Select a Help topic while using Office Assistant. ALT+number (where hitting key
for 1 selects the leftmost option, 2 the next, and so on)
Move from active application window to previously active application window.
ALT+SHIFT+TAB
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
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+TAB
Display previously viewed Help topics while using Office Assistant. ALT+UP ARROW
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 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. ARROW KEY
Delete selected text or to delete the character to the left of where the cursor
is positioned within a document while editing. BACKSPACE
Cancel Print Preview or Layout Preview and return to Normal view. C or ESC
So select all visible code in the Module window when editing with Visual Basic
code. CTRL+A
Select all records in an active database. CTRL+A or CTRL+SHIFT+SPACEBAR
Insert the default value for a selected field when entering data in a Datasheet
or Form view. CTRL+ALT+SPACEBAR
Insert the value from the same field in the previous record to the selected
field in the current record within a database. CTRL+APOSTROPHE (')
Halt the execution of code or a macro requested when running or debugging Visual
Basic code. CTRL+BREAK
Copy selection to the Windows Clipboard. CTRL+C
Insert the current time at the cursor's current position. CTRL+COLON (:)
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
Display the next procedure while viewing Visual Basic code. CTRL+DOWN ARROW
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
Insert a new line when entering data in Datasheet or Form view in Access.
CTRL+ENTER
To open the selected table, query, form, report, macro, or module while working
in Design view in Access. CTRL+ENTER or ALT+D
Display Windows Start menu. CTRL+ESC
Display the Find dialog box while working in Access Datasheet view, Form view or
Module Window only. CTRL+F
Toggle between a custom menu bar and a built-in menu bar while working in
Access. CTRL+F11
Invoke a Builder while working in Access. CTRL+F2
Put focus on the Object Box while working in Visual Basic code view. CTRL+F2
Put focus on the Procedure Box while working in Visual Basic code view. CTRL+F2
(then press TAB)
Find the next occurrence of selected text while working in Visual Basic code
view. CTRL+F3
Go to the next database window in the active application. CTRL+F6
Move between open windows. CTRL+F6
Activate Move mode for active window (MOV appears in the lower right corner of
the window) while in Datasheet view. CTRL+F8
Run Visual Basic code to the cursor's current point and halt execution. CTRL+F8
Set the next statement while working with Visual Basic code. CTRL+F9
To display the Debug dialog box while working with Visual Basic code. CTRL+G
To open the Replace dialog box (while in Datasheet view, Form view, and Module
Window only). CTRL+H
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
To display Quick Information when working in Visual Basic code. CTRL+I
List Properties and Methods when working in Visual Basic code. CTRL+J
Display the Calls dialog box when working in Visual Basic code. CTRL+L
Move cursor's position one word to the left. CTRL+LEFT ARROW
Move cursor's position one word to the left or right. CTRL+LEFT ARROW or
CTRL+RIGHT ARROW
Delete the current record when working in Datasheet or Form view. CTRL+MINUS
SIGN (-)
Open a new, blank, database. CTRL+N
Display the Open dialog box in order to find and open an existing database.
CTRL+O
Display the Print dialog box in order to print the active selection. CTRL+P
Go right one screen. CTRL+PAGE DOWN
Go to the same field in the next record. CTRL+PAGE DOWN
Go left one screen when working in datasheet view in Access. CTRL+PAGE UP
Go to the same field in the previous record. CTRL+PAGE UP
Add a new record while working in Datasheet or Form view in Access. CTRL+PLUS
SIGN (+)
Select a form or report. CTRL+R
Move cursor one word to the right. CTRL+RIGHT ARROW
Save a database object. CTRL+S or SHIFT+F12 or ALT+SHIFT+F2
Insert the current date into active Datasheet or Form view. CTRL+SEMICOLON (;)
Return to the last line position in the previously viewed procedure when working
in View Visual Basic code. CTRL+SHIFT+F2
Go to the previous database window. CTRL+SHIFT+F6
Exit a procedure while working in Visual Basic code. CTRL+SHIFT+F8
Clear all breakpoints when working in Visual Basic code. CTRL+SHIFT+F9
Display parameter information on a selection when working in Visual Basic code.
CTRL+SHIFT+I
List all constants when viewing Visual Basic code. CTRL+SHIFT+J
Select or unselect one word to the left of the cursor. CTRL+SHIFT+LEFT ARROW
To extend selection one word to the left. CTRL+SHIFT+LEFT ARROW
Select or unselect one word to the right of the cursor. CTRL+SHIFT+RIGHT ARROW
Exit the subform and move to the previous field in the main form or previous
record in Access. CTRL+SHIFT+TAB
Go to the previous tab when working in a tabbed dialog box. CTRL+SHIFT+TAB or
CTRL+PAGE UP
Select or unselect the active column, in Navigation mode only. CTRL+SPACEBAR
Complete the Visual Basic keyword. CTRL+SPACEBAR
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 dialog box. CTRL+TAB or CTRL+PAGE DOWN
Select the next or previous toolbar. CTRL+TAB or CTRL+SHIFT+TAB
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
Display the previous procedure when working in Visual Basic code. CTRL+UP ARROW
Paste a copied item(s) from the Clipboard into a selected location (You also can
choose Paste from the Edit menu.). CTRL+V
Close the active datasheet window. CTRL+W or CTRL+F4
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+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+Y
Undo the last action; note: some actions, like Shutdown, cannot be undone (You
also can choose Undo from the Edit menu.). CTRL+Z or ALT+BACKSPACE
Enter a selected item into a list when working with Visual Basic code.
CTRL-ENTER or TAB
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
To move down one line in a Combo box, list box or Database window. 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 or previous command on the menu or submenu. DOWN ARROW or UP
ARROW (with the menu or submenu displayed)
Go to the end of the entry when editing a text box. END
Go to the last object in database window. 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
Move to the right edge of the page when working in Access Print Preview and
Layout Preview. END OR CTRL+RIGHT ARROW
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. ENTER
Run a selected macro. ENTER
Enter the selected item and move the cursor to the next line when viewing Visual
Basic code. 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
Close the visible menu; or, with a submenu visible, close the submenu only. ESC
Cancel a command and close the dialog box. 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
Turn off Move mode when working in Access Datasheet view. ESC
Make a list disappear when working in Visual Basic code. ESC
Close a selected drop-down list in a dialog box. ESC (when a drop-down list box
is selected)
Display Help or the Office Assistant. 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 context-sensitive Help about selected keyword when viewing Visual Basic
Code. F1
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 F10
Bring the Database window to the front. F11 or ALT+F1
Display Save As dialog box (file menu). F12 or ALT+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
Display the Object Browser when working with Visual Basic code. F2
Find the next occurrence of the text specified in the Find or Replace dialog box
when the dialog box is closed when editing Visual Basic code. F3
Open a combo box. F4 or ALT+DOWN ARROW
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
Run a parameterless subprocedure containing the insertion point, from the Module
window when working with Visual Basic code. F5
Continue execution of code or macro when working with Visual Basic code. F5
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
Cycle through all the panes in the active window when working in Form view. F6
Move between the upper and lower portions of a window when working with Visual
Basic code. F6
Display Spelling and Grammar dialog box (Tools Menu). F7
Step into a procedure (single step) when working with Visual Basic code. 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. F8
Refresh the contents of a Lookup field list box or combo box. F9
Recalculate the fields in the window. F9
Toggle a breakpoint at the selected line when working with Visual Basic code. F9
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 left edge of the current page. HOME or CTRL+LEFT ARROW
Select the first or last command on the menu or submenu. HOME or END
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
Select the column to the left, of the current column, if the current column is
selected. LEFT ARROW
Move the selected column to the left one column in Move mode. LEFT 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 Access Datasheet view.
LEFT ARROW, or RIGHT ARROW
Choose a selected menu, drop-down list, or dialog box option by typing the first
letter in the option name. Letter key, where the letter is the same as the first
letter in option you want on a selected menu,
To open the Print dialog box from Print Preview or Layout Preview. P or CTRL+P
Move down one page when using a Combo box or list box. PAGE DOWN
Move down one window when working in Database view. PAGE DOWN
Scroll down one full screen when working in Print Preview and Layout Preview.
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
In Print Preview and Layout Preview, view the next page (when Fit To Window is
selected). PAGE DOWN or DOWN ARROW
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. 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
In Print Preview and Layout Preview, view the previous page (when Fit To Window
is selected). PAGE UP or UP 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.
RIGHT ARROW
in Datasheet view, select the column to the right, if the current column is
selected. RIGHT ARROW
in Datasheet view and Move Mode, move the selected column to the right one
column. RIGHT ARROW
In Print Preview and Layout Preview, open the Page Setup dialog box. S
Cycle through the tab of each object's type moving right to left. SHIFT+CTRL+TAB
Extend selection to the next record, if the current record is selected.
SHIFT+DOWN ARROW
Select from the insertion point to the end of the text box entry. SHIFT+END
Add a control to a section when working in Form and Report Design view only.
SHIFT+ENTER
Save changes to the current record when entering data in the Datasheet or Form
view. SHIFT+ENTER
Display What's This? help; after pressing SHIFT+F1, move the pointer to the menu
command, toolbar button, dialog box option, or screen region to see definitions.
SHIFT+F1
Display a shortcut menu that shows a list of commands relevant to the selected
object. SHIFT+F10
Open the Zoom box to conveniently enter expressions and other text in small
input areas. SHIFT+F2
View a procedure definition, variable, or keyword when working with Visual Basic
code. SHIFT+F2
In Visual Basic code, find the previous occurrence of the text specified in the
Find or Replace dialog box when the dialog box is closed. SHIFT+F3
Find the previous occurrence of the text specified in the Find or Replace dialog
box when the dialog box is closed. SHIFT+F4
Reset the execution of a code or macro when working with Visual Basic code.
SHIFT+F5
Cycle back through sections when navigating in Form view. SHIFT+F6
Undo a previous selection extension. SHIFT+F8
Step over a procedure when working with Visual Basic code. SHIFT+F8
Requery the underlying tables; in a subform, this requeries the underlying table
for the subform only. SHIFT+F9
Create an instant watch for a selected expression when working with Visual Basic
code. SHIFT+F9
Select from the insertion point in the text box to the beginning of the text box
entry. SHIFT+HOME
Select or unselect one character to the left of the cursor's position.
SHIFT+LEFT ARROW
Select or unselect by one character to the right of the cursor's current
position. SHIFT+RIGHT ARROW
Switch between selecting the current record and the first field of the current
record, when working in Navigation mode. SHIFT+SPACEBAR
Move to the previous option or option group in a dialog box. SHIFT+TAB
Move to the previous field when navigating in Form view. SHIFT+TAB
Enter the subform from the following field in the main form when navigating in
Form view. SHIFT+TAB
Remove indentation from selected lines when working in Visual Basic code.
SHIFT+TAB or CTRL+SHIFT+M
Move to the previous field when navigating in Datasheet view. SHIFT+TAB, or LEFT
ARROW
Extend selection to the previous record, if the current record is selected.
SHIFT+UP ARROW
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
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. 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
Indent selected lines when working with Visual Basic code. TAB or CTRL+M
When a toolbar is active, select the next or previous button or menu on the
toolbar. TAB or SHIFT+TAB (when a toolbar is active)
Move to the next field when navigating in Datasheet view. TAB, ENTER, or RIGHT
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
Extend a selection to adjacent rows in Datasheet view. UP ARROW, DOWN ARROW
Zoom in or out on a part of the page when working in Print Preview and Layout
Preview. Z