Microsoft Access Reference Card

Displaying Help
Display the Office Assistant and Microsoft Office help; context-sensitive Help about the selected property, CTRL, macro action, or Visual Basic keyword; or alerts with a Help button	F1
Display ScreenTips in a dialog box, after selecting the option by using the keyboard	SHIFT-F1

Opening Databases
Open a New Database	CTRL-N
Open an Existing Database	CTRL-O

Printing and Saving
Print the Current or Selected Object	CTRL-P
Save a Database Object	CTRL-S or SHIFT-F12 ALT-SHIFT-F2
Open the "Save As" Dialog Box	F12 or ALT-F2

Using a Combo Box or List Box
Open a Combo Box	ALT-DOWN ARROW or F4
Refresh the Contents of a lookup field list box or combo box	F9
Move down one line	DOWN ARROW
Move down one page	PAGE DOWN
Move up one line	UP ARROW
Move up one page	PAGE UP
Exit the List Box or Combo Box	TAB

Finding and Replacing Text or Data
Open the Find property sheet in the find and replace dialog (datasheet and form view only)	CTRL-F
Open the replace property sheet of the find and replace dialog (datasheet and form view only)	CTRL-H
Find the next occurance of the text specified in the find and replace dialog when the dialog box is closed (datasheet and form view only)

Working in Design View
Switch between edit and navigation mode (with insertion point displayed)	F2
Switch to form view from form design view	F5
Switch between the upper and lower portions of a window (Design view of tables, macros, and queries and the Advanced Filter/Sort window only)	F6

Editing Controls in Form and Report Design View
Add a CTRL to a Section	ALT-Enter
Copy the selected CTRL to the Clipboard	CTRL-C
Cut the selected CTRL and copy it to the Clipboard	CTRL-X
Paste the contents of the Clipboard in the upper-left corner of the selected section	CTRL-V
Move the selected CTRL to the right	CTRL-RIGHT ARROW
Move the selected CTRL to the left	CTRL-LEFT ARROW
Move the selected CTRL up	CTRL-UP ARROW
Move the selected CTRL down	CTRL-DOWN ARROW
Increase the height of the selected CTRL	SHIFT-DOWN ARROW
Increase the width of the selected CTRL	SHIFT-RIGHT ARROW
Reduce the height of the selected CTRL	SHIFT-UP ARROW
Reduce the width of the selected CTRL	SHIFT-LEFT ARROW

Window Operations
Bring the Database window to the front	F11 ALT-F1
Cycle Among open windows	CTRL-F6
Restore the selected minimized window when all windows are minimized	Enter
\	CTRL-F8
Display the CTRL menu	ALT-SPACEBAR
Display the shortcut menu	SHIFT-F10
Close the active window	CTRL-F4 CTRL-W
Switch between the Visual Basic Editor and the previous active window	ALT-F11
Switch between the Microsoft Script Editor and the previous active window	ALT-SHIFT-F11

Miscellaneous
Display the complete hyperlink address for a selected hyperlink	F2
Check spelling	F7
Open the Zoom box to conveniently enter expressions and other text in small input areas	SHIFT-F2
Display a property sheet in Design view	ALT-Enter
Quit Microsoft Access, close a dialog box, or close a property sheet	ALT-F4
Invoke a Builder	CTRL-F2
Toggle between a custom menu bar and a built-in menu bar	CTRL-F11

Editing and navigating the Object list in a Database Window
Rename a selected object	F2
Move down one line	DOWN ARROW
Move down one window	PAGE DOWN
Move to the last object	END
Move up one line	UP ARROW
Move up one window	PAGE UP
Move to the first object	HOME

Navigating and Opening Objects in a Database Window
Cycle through the Objects bar top to bottom	CTRL-TAB
Cycle through the Objects bar bottom to top	CTRL-SHIFT-TAB
Open the selected table or query in Datasheet view, or form in Form view	Enter or ALT-O
Open the selected report in Print Preview	Enter
Open the selected data access page in Page view	Enter
Run the selected macro	Enter
Open the selected table, query, form, report, data access page, macro, or module in Design view	CTRL-Enter ALT-D
Create a new table, query, form, report, data access page, macro, or module	ALT-N
Refresh the Database window	F5
Display the Immediate window in the Visual Basic Editor	CTRL-G

Using Menus
Show the shortcut menu	SHIFT-F10
Make the menu bar active	F10
Show the program icon menu (on the program title bar)	ALT-SPACEBAR
With the menu or submenu is visible, to select the next or previous command	UP ARROW DOWN ARROW
Select the menu to the left or right; or, when a submenu is visible, to switch between the main menu and the submenu	LEFT ARROW RIGHT ARROW
Select the first or last command on the menu or submenu	HOME END
Close the visible menu and submenu at the same time	ALT
Close the visible menu; or, with a submenu visible, to close the submenu only	Escape

Working in Toolbars
Make the menu bar active	F10
Select the next or previous toolbar	CTRL-TAB CTRL-SHIFT-TAB
When a toolbar is active, to select the next or previous button or menu on the toolbar	TAB SHIFT-TAB
When a menu on a toolbar is selected, to open the menu	Enter
When a button is selected, to perform the action assigned to a button	Enter
When the text box is selected, to enter text in a text box	Enter
When a drop-down list box or drop-down menu on a button is selected, to move through options in the list or menu; then press ENTER to select the option you want	Up DOWN ARROW

using a Window
Switch to the next program	ALT-TAB
Switch to the previous program	ALT-SHIFT-TAB
Show the Windows Start menu	CTRL-ESCAPE
Close the active database window	CTRL-W
Switch to the next database window	CTRL-F6
Switch to the previous database window	CTRL-SHIFT-F6

Using a dialog box
Switch to the next property sheet in a dialog box	CTRL-TAB CTRL-PAGE DOWN
Switch to the previous property sheet in a dialog box	CTRL-SHIFT-TAB CTRL-PAGE UP
Move to the next option or option group	TAB
Move to the previous option or option group	SHIFT-TAB
Move between options in the selected drop-down list box, or to move between some options in a group of options	Arrow Keys
Perform the action assigned to the selected button; select or clear the check box	SPACEBAR
The first letter in the option name you want (when a drop-down list box is selected) To move to the option by the first letter in the option name in a drop-down list box	Letter key
Select the option, or to select or clear the check box by the letter underlined in the option name	ALT-Letter Key
Open the selected drop-down list box	ALT-DOWN ARROW
Close the selected drop-down list box	ESCAPE
Perform the action assigned to the default button in the dialog box	ENTER
Cancel the command and close the dialog box	ESCAPE

Editing in a Text Box
Move to the beginning of the entry	HOME
Move to the end of the entry	END
Move one character to the left or right	LEFT OR RIGHT ARROW
Move one word to the left or right	CTRL-Left RIGHT ARROW
Select from the insertion point to the beginning of the entry	SHIFT-HOME
Select from the insertion point to the end of the entry	SHIFT-END
Select one character to the left	SHIFT-LEFT ARROW
Select one character to the right	SHIFT-RIGHT ARROW
Select one word to the left	CTRL-SHIFT-LEFT ARROW
Select one word to the right	CTRL-SHIFT-RIGHT ARROW

Keys for - Open, File New Database and Export Dialog Boxes
Go to the previous folder	ALT-1
Open the folder up one level from the open folder (Up One Level button )	ALT-2
Close the dialog box, and open your World Wide Web search page (Search the Web button )	ALT-3
Delete the selected folder or file	DELETE
Create a new subfolder in the open folder (Create New Folder button )	ALT-5
Switch between List, Details, Properties, and Preview views	ALT-6
Show the Tools menu (Tools button)	ALT-7

Get Help from the Office Assistant
In order to use these commands, the Office Assistant must be Enabled and Visible
if the Assistant is showing. Display the Assistant balloon	F1
Select a Help topic from the list the Assistant displays	ALT-number (ALT-1 is the first topic, ALT-2 is the second, and so on)
See more Help topics	ALT-DOWN ARROW
Previous Help topics	ALT-UP ARROW
Close an Assistant message	Escape

Working in the Help Window
Move between the navigation pane and topic pane	F6
Display the Options menu to access any Help toolbar command	ALT-O
Display the program control menu	ALT-SPACEBAR
Close the active Help window	ALT-F4

Move Around in the Navigation Pane of the Help Window
Switch to the next tab	Conrol-TAB
Switch to the previous tab	CTRL-SHIFT-TAB
Switch to the Contents tab	ALT-C
Switch to the Answer Wizard tab	ALT-A
Switch to the Index tab	ALT-I
Open or close a selected book, or open a selected Help topic	Enter
Select the next book or Help topic	DOWN ARROW
Select the previous book or Help topic	UP ARROW

Move Around in the Topic Pane of the Help Winodw
Go back to a Help topic you viewed previously	ALT-LEFT ARROW
Go forward to a Help topic you viewed previously	ALT-RIGHT ARROW
Go to the first or next hyperlink	TAB
Go to the last or previous hyperlink	SHIFT-TAB
Activate a selected hyperlink	Enter
Close a pop-up window	Escape
Scroll toward the beginning of a Help topic	UP ARROW
Scroll toward the end of a Help topic	DOWN ARROW
Scroll toward the beginning of a Help topic in larger increments	PAGE UP
Scroll toward the end of a Help topic in larger increments	PAGE DOWN
Move to the beginning of a Help topic	HOME
Move to the end of a Help topic	END
Print the active Help topic	CTRL-P
Select the entire Help topic	CTRL-A
Copy the selected items to the Clipboard	CTRL-C

Sending E-mail Messages
Send the active database object as an e-mail message	ALT-F-D-A
Open the Address Book	CTRL-SHIFT-B
Check the names in the To, Cc, and Bcc boxes against the Address Book	ALT-K
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
Select the previous field or button in the e-mail header	SHIFT-TAB

Select the next field	TAB
Switch between Edit mode (with insertion point displayed) and Navigation mode	F2
Switch between selecting the current record and the first field of the current record, in Navigation mode	SHIFT-SPACEBAR
Extend selection to the previous record, if the current record is selected	SHIFT-UP ARROW
Extend selection to the next record, if the current record is selected	SHIFT-DOWN ARROW
Select all records	CTRL-A CTRL-SHIFT-SPACEBAR

Turn on 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	F8
Extend a selection to adjacent fields in the same row in Datasheet view	LEFT ARROW RIGHT ARROW
Extend a selection to adjacent rows in Datasheet view	Up ARROW DOWN ARROW
Undo the previous extension	SHIFT-F8
Cancel Extend mode	ESCAPE

If the insertion point isn't visible, press F2 to display it.
Move it one character to the right	RIGHT ARROW
Move one word to the right	CTRL-RIGHT ARROW
Move one character to the left	LEFT ARROW
Move one word to the left	CTRL-LEFT ARROW
Move to the end of the field, in single-line fields	END
Move to the end of the field, in multiple-line fields	CTRL-END
Move to the beginning of the field, in single-line fields	HOME
Move to the beginning of the field, in multiple-line fields	CTRL-HOME

Copy the selection to the Clipboard	CTRL-C
Cut the selection and copy it to the Clipboard	CTRL-X
Paste the contents of the Clipboard at the insertion point	CTRL-V
Delete the selection or the character to the left of the insertion point	Backspace
Delete the selection or the character to the right of the insertion point	DELETE
Delete all characters to the right of the insertion point	CTRL-DELETE

Insert the current date	CTRL-SEMICOLON (;)
Insert the current time	CTRL-COLON (:)
Insert the default value for a field	CTRL-ALT-SPACEBAR
Insert the value from the same field in the previous record	CTRL-APOSTROPHE (')
Add a new record	CTRL-PLUS (+)
Delete the current record	CTRL-MINUS (-)
Save changes to the current record	SHIFT-ENTER
Switch between the values in a check box or option button	SPACEBAR
Insert a new line	CTRL-ENTER

Move to the record number box; then type the record number and press ENTER	F5
Move to the next field	TAB RIGHT ARROW
Move to the last field in the current record, in Navigation mode	END
Move to the previous field	SHIFT-TAB LEFT ARROW
Move to the first field in the current record, in Navigation mode	HOME
Move to the current field in the next record >	DOWN ARROW
Move to the current field in the last record, in Navigation mode	CTRL-DOWN ARROW
Move to the last field in the last record, in Navigation mode	CTRL-END
Move to the current field in the previous record	UP ARROW
Move to the current field in the first record, in Navigation mode	CTRL-UP ARROW
Move to the first field in the first record, in Navigation mode	CTRL-HOME

To select data within a field	Move the insertion point to the start of the text you want to select, and then hold down SHIFT and press the arrow keys to move to the END of the se
To select an entire field	Move the insertion point to the field, and press F2. Adjacent fields With a field selected, hold down SHIFT and press the appropriate arrow key.
To select the current column	Cntrol-SPACEBAR
To select the current record	SHIFT-SPACEBAR
To select multiple records	SHIFT-SPACEBAR, and then SHIFT-Up or DOWN ARROW.

Navigating in Subdatasheets
Move to a specific record	F5 from the subdatasheet to move to the record number box; then type the record number and press Enter
Expand the record’s subdatasheet	CTRL-SHIFT-DOWN ARROW from within the datasheet
Collapse the subdatasheet	CTRL-SHIFT-UP ARROW from within the datasheet
Enter the subdatasheet from the last field of the previous record in the datasheet	TAB
Enter the subdatasheet from the first field of the following record in the datasheet	SHIFT-TAB
Exit the subdatasheet and move to the first field of the next record in the datasheet	CTRL-TAB
Exit the subdatasheet and move to the last field of the previous record in the datasheet	CTRL-SHIFT-TAB
Enter the next field in the datasheet	TAB from the last field in the subdatasheet
Bypass the subdatasheet and move to the next record in the datasheet	DOWN ARROW
Bypass the subdatasheet and move to the previous record in the datasheet	UP ARROW
You can navigate between fields and records in a subdatasheet with the same shortcut keys used in Datasheet view.

navigating in Form View
Moving to a specific record	F5 To move to the record number box; then type the record number and press Enter
Move to the next field	TAB
Move to the previous field	SHIFT-TAB
Move to the last field in the current record, in Navigation mode	END
Move to the last field in the last record, in Navigation mode	CTRL-END
Move to the first field in the current record, in Navigation mode	HOME
Move to the first field in the first record, in Navigation mode	CTRL-HOME
Move to the current field in the next record	CTRL-PAGE DOWN
Move to the current field in the previous record	CTRL-PAGE UP

Navigating in Forms with More than One Page
Go down one page; at the end of the record, moves to the equivalent page on the next record	PAGE DOWN
Go up one page; at the end of the record, moves to the equivalent page on the previous record	PAGE UP

Navigating between the Main Form and Subform
Enter the subform from the preceding field in the main form	TAB
Enter the subform from the following field in the main form	SHIFT-TAB
Exit the subform and move to the next field in the master form or next record	CTRL-TAB
Exit the subform and move to the previous field in the main form or previous record	CTRL-SHIFT-TAB

Dialog Box and Window Operations in Print Preview and Layout Preview
Use shortcut keys in Print Preview and Layout Preview
Open the Print dialog box	P CTRL-P
Open the Page Setup dialog box	S
Zoom in or out on a part of the page	Z
Cancel Print Preview or Layout Preview	C ESCAPE
Move to the page number box; then type the page number and press ENTER	F5
View the next page (when Fit To Window is selected)	PAGE DOWN DOWN ARROW
View the previous page (when Fit To Window is selected)	PAGE UP UP ARROW

Navigating a Database Diagram
Move from a table cell to the table’s title bar	ESCAPE
Move from a table’s title bar to the last cell you edited	ENTER
Move from table title bar to table title bar, or from cell to cell inside a table	TAB
Expand a list inside a table	ALT-DOWN ARROW
Scroll through the items in a drop-down list from top to bottom	DOWN ARROW
Move to the previous item in a list	UP ARROW
Select an item in a list and move to the next cell	ENTER
Change the setting in a check box	SPACEBAR
Go to the first cell in the row, or to the beginning of the current cell	HOME
Go to the last cell in the row, or to the END of the current cell	END
Scroll to the next "page" inside a table, or to the next "page" of the diagram	PAGE DOWN
Scroll to the previous "page" inside a table, or to the previous "page" of the diagram	PAGE UP

Navigating in the Query Designer
Move Among the Query Designer Panes	F6 SHIFT-F6

Diagram Pane
Move between input source windows (and to join lines if available)	TAB SHIFT-TAB
Move between columns in an input source window	ARROW KEYS
Choose the selected data column for output	SPACEBAR or PLUS (If multiple items are selected, pressing the SPACEBAR affects all selected items. Select multiple items by holding down the SHIFT key while clicking them. Toggle the selected state of a single item by holding down CTRL while clicking it.)
Remove the selected data query column from the query output	SPACEBAR or Minus Key (If multiple items are selected, pressing the SPACEBAR affects all selected items. Select multiple items by holding down the SHIFT key while clicking them. Toggle the selected state of a single item by holding down CTRL while clicking it.)
Remove the selected input source or join the line from the query	DELETE

Cut selected text in a cell to the Clipboard (in edit mode)

Grid Pane
Move among cells	ARROW KEYS TAB SHIFT-TAB
Move to the last row in the current column	CTRL-DOWN ARROW
Move to the first row in the current column	CTRL-UP ARROW
Move to the first postion in the current cell or the first column in the input source window	CTRL-HOME
Move to the last position in the current cell or the lst column in the input source window	CTRL-END
Move in a drop-down list	Up ARROW DOWN ARROW
Select an entire grid column	CTRL-SPACEBAR
Toggle between edit mode and cell selection mode	F2
Copy selected text in a cell to the Clipboard (in edit mode)	CTRL-C
Cut selected text in a cell to the Clipboard (in edit mode)	CTRL-X
Paste text from Clipboard (in edit mode)	CTRL-V
Toggle between insert and overstrike mode while editing within a cell	INSERT
Toggle the checkbox in the output columns	SPACEBAR
Clear the selected contents of a cell	DELETE
Remove row containing selected data from the query	DELETE
Cleear all values for a selected grid column	DELETE
Insert row between existing row	INSERT after you select grid row

Shortcut Keys for Page View
To use the following keys, press the TAB key repeatedly until the expand indicator or record navigation toolbar has focus. If a PivotTable list or spreadsheet control currently has focus, press CTRL-TAB
Expand or collapse a group of records corresponding to the expand indicator in a grouped data access page.	SPACEBAR ENTER
Select a button on the record navigation toolbar.	LEFT ARROW RIGHT ARROW
Activate the selected button on the record navigation toolbar.	SPACEBAR or Enter

Data Access Page Design View
Add a control to a section	SHIFT-Enter
Copy the selected control to the Clipboard	CTRL-C
Cut the selected control and copy it to the Clipboard	CTRL-X
Paste the contents of the Clipboard in the upper-left corner of the selected section	CTRL-V
Move the selected control to the right by a pixel (irrespective of the page’s grid)	CTRL-RIGHT ARROW
Move the selected control to the left by a pixel (irrespective of the page’s grid)	CTRL-LEFT ARROW
Move the selected control up by a pixel (irrespective of the page’s grid)	CTRL-UP ARROW
Move the selected control down by a pixel (irrespective of the page’s grid)	CTRL-DOWN ARROW

Select Elements within a PivotTable List
Select each field and then the entire PivotTable list, going through these selections in sequence.	TAB
Select the previous field or the entire PivotTable list. detail area or data area.	SHIFT-TAB
Move the selection in the direction of the arrow key. If a row or column field is selected, press DOWN ARROW to move to the first item of data in the field, and then press an arrow key to move to the next or previous item or back to the field. If a detail field or an item of data is selected, press DOWN ARROW OR RIGHT ARROW to move to the first cell in the	ARROW KEYS
Extend or reduce the selection in the direction of the arrow key. You can extend a selection down and to the right.	SHIFT-RIGHT ARROW
Extend a selection down one screen. A screen is all of the data currently displayed in the PivotTable list.	SHIFT-PAGE DOWN
Reduce a selection by one screen.	SHIFT-PAGE UP
Select the field for the currently selected item of data, total, or detail cell.	CTRL-SPACEBAR
Select the entire row containing the currently selected cell.	SHIFT-SPACEBAR
Select the entire PivotTable list.	CTRL-A
Display the next screen. A screen is all of the data currently displayed in the PivotTable list.	PAGE DOWN
Display the previous screen.	PAGE UP
Display the next screen to the right.	ALT-PAGE UP
Display the previous screen to the left.	ALT-PAGE DOWN
Display the shortcut menu for the selected element of the PivotTable list. Use the shortcut menus to carry out commands in the PivotTable list.	SHIFT-F10
Carry out a command on the shortcut menu. See ALT+ENTER for information about the PivotTable Property Toolbox.	UNDERLINED LETTER
Close the shortcut menu without carrying out a command.	ESCAPE
Display or hide the toolbar.	CTRL-7
Display the PivotTable Property Toolbox. No keyboard shortcuts are available to carry out commands or set properties from the toolbox.	ALT-ENTER
Close the PivotTable Property Toolbox.	ALT-F4
Refresh the PivotTable list from the source data.	F9
Cancel a refresh in progress.	ESCAPE
Copy the selected data from the PivotTable list to the Clipboard.	CTRL-C
Export the PivotTable list to Microsoft Excel.	CTRL-E

Display, Hide, Filter, and Sort Data in a PivotTable List
Display or hide the and expand indicators beside items.	CTRL-8
Display detail for the currently selected item.	CTRL-Plus Sign
Hide detail for the currently selected item.	CTRL-Minus Sign
Open the drop-down list for the currently selected field.	ALT-DOWN ARROW
Alternately move to the most recently selected item, the OK button, and the Cancel button in the drop-down list for a field.	TAB
Move to the next item in the drop-down list for a field.	ARROW KEYS
Select or clear the check box for the current item in the drop-down list for a field.	SPACEBAR
Display lower levels of detail, if available, for the current item in the drop-down list for a field.	PLUS SIGN (numeric keypad)
Hide lower levels of detail for the current item in the drop-down list for a field.	MINUS SIGN (numeric keypad)
Close the drop-down list for a field, and apply any changes you made.	ENTER
Close the drop-down list for a field without applying your changes.	ESCAPE
Turn AutoFilter on or off.	CTRL-T
Sort data in the selected field or total in ascending order (A – Z 0 – 9).	CTRL-SHIFT-A
Sort data in the selected field or total in descending order (Z – A 9 – 0).	CTRL-SHIFT-Z

Keys for Adding Fields and Totals
Add a new total field for the selected field in the PivotTable list by using the Sum summary function.	CTRL-SHIFT-S
Add a new total field for the selected field in the PivotTable list by using the Count summary function.	CTRL-SHIFT-C
Add a new total field for the selected field in the PivotTable list by using the Min summary function.	CTRL-SHIFT-H
Add a new total field for the selected field in the PivotTable list by using the Max summary function.	CTRL-SHIFT-X
Turn subtotals and grand totals on or off for the selected field in the PivotTable list.	CTRL-SHIFT-B

Changing a Pivot Table Layout
Move the selected field in the PivotTable list to the row area.	CTRL-1
Move the selected field in the PivotTable list to the column area.	CTRL-2
Move the selected field in the PivotTable list to the filter area.	CTRL-3
Move the selected field in the PivotTable list to the detail area.	CTRL-4
Move the selected row or column field in the PivotTable list to a higher level.	CTRL-LEFT ARROW
Move the selected row or column field in the PivotTable list to a lower level.	CTRL-RIGHT ARROW

Format a PivotTable List
The first seven keyboard shortcuts in the following table change the number format of the selected element.
Apply the general number format to values in the selected total or detail field.	CTRL-SHIFT-Tilde (~)
Apply the currency format, with two decimal places and negative numbers in parentheses, to values in the selected total or detail field.	CTRL-SHIFT-5
Apply the percentage format, with no decimal places, to values in the selected total or detail field.	CTRL-SHIFT-4
Apply the exponential number format, with two decimal places, to values in the selected total or detail field.	CTRL-SHIFT-Carat (^)
Apply the date format, with the day, month, and year, to values in the selected total or detail field.	CTRL-SHIFT-#3
Apply the time format, with the hour, minute, and AM or PM, to values in the selected total or detail field.	CTRL-SHIFT-2
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-SHIFT-!
Make text bold in the selected element of the PivotTable list.	CTRL-B
Make text underlined in the selected element of the PivotTable list.	CTRL+ U
Make text italic in the selected element of the PivotTable list.	CTRL-I

Activating, Moving Around, and Selecting in Spreadsheets
Selects cells in the spreadsheet.	TAB
Select the previous cell in the spreadsheet.	SHIFT-TAB
Move the selection in the direction of the arrow key.	ARROW KEYS
Extend the selection in the direction of the arrow key.	SHIFT-ARROW KEYS
Select the current column.	CTRL-SPACEBAR
Select the current row.	SHIFT-SPACEBAR
Extend a selection down one screen. A screen is all of the data currently displayed in the spreadsheet.	SHIFT-PAGE DOWN
Extend a selection up one screen. A screen is all of the data currently displayed in the spreadsheet.	SHIFT-PAGE UP
Move the selection to the first cell in the current row.	HOME
Move the selection to cell A1 or the upper-left cell of the visible range.	CTRL-HOME
Move the selection to the last cell in the spreadsheet that contains data and is not hidden by filtering.	CTRL-END
Move the selection to the last cell in that direction of the current area containing data (the area of data bounded by blank rows and columns).	CTRL-ARROW KEYS
Scroll in the direction of the arrow key.	SCROLL LOCK-ARROW KEYS
Scroll down one screen. A screen is all of the data currently displayed in the spreadsheet.	PAGE DOWN
Scroll up one screen. A screen is all of the data currently displayed in the spreadsheet.	PAGE UP
Select all cells in the spreadsheet.	CTRL-A

Carrying out Commands in a Spreadsheet
Display Help topics.	F1
Display the shortcut menu for the spreadsheet.	Shhift-F10
Carry out a command on the shortcut menu when the menu is displayed. See	UNDERLINED LETTER
Information about the Spreadsheet Property Toolbox.	ALT-ENTER
Close the shortcut menu without carrying out a command.	ESCAPE
Display the Spreadsheet Property Toolbox. No keyboard shortcuts are available to carry out commands or set properties from the Spreadsheet Property Toolbox.	ALT-ENTER
Close the Spreadsheet Property Toolbox.	ALT-F4
Display or hide the toolbar for the spreadsheet.	CTRL-7
Undo. Reverse the last command or DELETE the last entry you typed.	CTRL-Z
Add numbers automatically with the SUM function.	ALT-EQUAL
Turn AutoFilter on or off.	CTRL-T
Export the spreadsheet to Microsoft Excel.	CTRL-E
Recalculate the spreadsheet.	F9

Entering, Editing, and Copying data in Spreadsheets
Edit the contents of the selected cell.	F2
Enter data in the current cell.	ENTER
Enter data in multiple selected cells.	CTRL-ENTER
Cancel entering or changing data in a cell.	ESCAPE
Clear the contents of the current cell.	BACKSPACE
Clear the contents of the selected cells.	DELETE
Remove the selected data from the spreadsheet and place the data on the Clipboard.	CTRL-X
Copy the selected data from the spreadsheet to the Clipboard.	CTRL-C
Insert the contents of the Clipboard at the insertion point, and replace any selected data.	CTRL-V
Make text in the selected cells bold.	CTRL-B
Make text in the selected cells underlined.	CTRL-U
Make text in the selected cells italic.	CTRL-I
Enter the euro currency symbol .	ALT-0128 on the numeric keypad (NUM LOCK must be turned on)

Working with AutoFilter Drop-Down :Lsts in a Spreadsheet
Open the AutoFilter drop-down list for the selected cell.	ALT-DOWN ARROW
Alternately move to the most recently selected item, the OK button, and the Cancel button in an AutoFilter drop-down list.	TAB
Move to the next item in an AutoFilter drop-down list.	ARROW KEYS
Move to the first item that starts with that letter or number in an AutoFilter drop-down list.	LETTER or NUMBER KEYS
Extend the selection in an AutoFilter drop-down list.	SHIFT-ARROW KEYS
Select or clear the check boxes for the selected items in an AutoFilter drop-down list.	SPACEBAR
Close an AutoFilter drop-down list and apply any changes you made.	ENTER
Close an AutoFilter drop-down list without applying your changes.	ESCAPE

Place a Text Box or Another CTRL on a Form or Report
Press ALT Press CTRL+TAB twice to put focus on the toolbox. (If the toolbox is not displayed, press CTRL-SHIFT-F10 to display the toolbar shortcut menu. Use the DOWN ARROW key to select Toolbox, and then press Enter. ) Press TAB repeatedly until you select the desired CTRL. Press SHIFT-Enter to add the CTRL to the upper-left corner of the form or report detail section. Make sure the CTRL is still selected, and press ALT-V-F to display the control's property sheet. Then, press CTRL-TAB to select the All TAB. Adjust the Left and Top property settings to move the control to the desired location on the form or report, and then press ALT-F4 to close the property sheet. Alternatively, press CTRL-Any Arrow Key to manually move the CTRL and SHIFT-ANY ARROW KEY to resize the control as needed. Learn about

Copy a Text Box or another CTRL on a Form or Report
Press ALT Press CTRL-TAB until the Object combo box on the Formatting (Form/Report) toolbar has the focus, and then press Enter. Press F4 to open the Object combo box. Press the DOWN ARROW key to select the control, and then press Enter. Press Conrol-C to copy the control to the Clipboard. Repeat steps 1 through 3 to open the Object combo box. Press the DOWN ARROW key to select the section, and then press Enter. Press CTRL-V to paste the control in the upper-left corner of the section. To paste multiple copies, press CTRL+V repeatedly. To adjust the location of the control by using property settings, select the CTRL and press ALT-V-F to display the control's property sheet. Press CTRL-TAB to select the All TAB. Adjust the Left and Top property settings to move the control to the desired location on the form or report, and then press ALT+F4 to close the property sheet. Alternatively, press CTRL-ANY ARROW KEY to manually move the CTRL and SHIFT-ANY ARROW KEY to resize the control as needed. Learn about

Send a Data Access Page as the Body of an E-mail Message
A data access page is connected to an OLE DB data source, either a Microsoft Access database or Microsoft SQL Server database. For the data access page to work properly, the database must be available to users of the page. Learn about sharing the OLE DB data source of a page. In the Database window, click Pages under Objects, and then the name of the page you want to send as the body of an e-mail message. On the File menu, click Send To and then choose Mail Recipient. Access opens the data access page in Page Design view so that you can make changes, such as adding text or notes to the data access page for the mail recipient, before you send the data access page. Enter recipient names in the To and Cc boxes. Separate names with a semicolon (;) To select recipient names from a list, click To or Cc. The name of the object is displayed in the Subject box by default, but you can type your own subject name. You can manually check names before sending the message. You can also set additional options for the e-mail message. Click Send on the message header.

Rearrange Columns in Datasheet View
Move the insertion point to a field in the column of the datasheet or subdatasheet you want to move. Learn about navigating in a datasheet or navigating between a datasheet and subdatasheet. If the entire field is not already highlighted, press F2. To select the entire column, press CTRL-SPACEBAR. You can select more than one column by pressing SHIFT-LEFT ARROW or SHIFT-RIGHT ARROW . (This has to be done before you enter Move mode.) To turn on Move mode, press CTRL-SHIFT-F8 To move the column to the right, press the RIGHT ARROW. . To move the column to the left, press the LEFT ARROW. To turn off Move mode, press ESCAPE

Extend one character to the right	SHIFT-RIGHT ARROW
Extend one word to the right	CTRL-SHIFT-RIGHT ARROW
Extend one character to the left	SHIFT-LEFT ARROW
Extend one word to the left	CTRL-SHIFT-LEFT ARROW
To cancel a selection, use the opposite arrow key.

Undo typing	CTRL-Z ALT-Backspace
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	Escape

Recalculate the fields in the window	F9
Requery the underlying tables; in a subform, this requeries the underlying table for the subform only	SHIFT-F9
Refresh the contents of a Lookup field list box or combo box	F9

Select the current column or cancel the column selection, in Navigation mode only	CTRL-SPACEBAR
Select the column to the right, if the current column is selected	SHIFT-RIGHT ARROW
Select the column to the left, if the current column is selected	SHIFT-LEFT ARROW
Turn on move mode; then press the RIGHT ARROW or LEFT ARROW key to move selected column(s) to the right or left	CTRL-SHIFT-F8

Go down one screen	PAGE DOWN
Go up one screen	PAGE UP
Go right one screen	CTRL-PAGE DOWN
Go left one screen	CTRL-PAGE UP