Access 2007 Keyboard Shortcuts

Here are the Access 2007 Keyboard Shortcuts

Using the Navigation Pane

Down arrow	Move to the next object.
Up arrow	Move the previous object.
End	Move to the last object.
Home	Move to the first object.
Enter	Open the selected object.
Ctrl+Enter	Open the selected object in Design view.
F2	Rename the selected object.
F11	Hide or show the Navigation pane.

Navigating in Datasheet View

Tab or right arrow	Move to the next field to the right, or to the first field of the next record if you’re in the last field of a record.
Shift+Tab or left arrow	Move to the previous field to the left, or to the last field (the Add New Field column) of the previous record if you’re in the first field of a record.
Ctrl+Right arrow	Move to the next word in the current field if the cursor is in the field.
Ctrl+Left arrow	Move to the previous word in the current field if the cursor is in the field.
Home	Move to the first field or move to the beginning of the current field if the cursor is in the field.
End	Move to the last field (Add New Field) or move to the end of the current field if the cursor is in the field.
Up arrow	Move to the current field in the previous record.
Down arrow	Move to the current field in the next record.
Ctrl+Up arrow	Move to the current field in the first record.
Ctrl+Down arrow	Move to the current field in the last record.
Ctrl+Home	Move to the first field of the first record.
Ctrl+End	Move to the last field of the last record.
Alt+F5	Activate the Record Number box. To navigate to a specific record, type the record number and press Enter.
Ctrl+Shift+Down arrow	Display the subdatasheet associated with the current record.
Ctrl+Shift+Up arrow	Hide the subdatasheet associated with the current record.

Selecting Data in Datasheet View

F8	Extend the selection to the current word, all the text in the current field, the current field, the current record, and then all records.
Shift+F8	Collapse the selection to the current record, the text in the current records, and then the current word.
Shift+arrow keys	Extend the current selection in the arrow key direction.
Shift+Spacebar	Select the current record. (Press Shift+Spacebar again to select the first field in the current record.)
Ctrl+Spacebar	Select the current field. (Press Ctrl+Spacebar again to select the first item in the current field.)
Ctrl+Shift+F8 Enter	Move mode, which enables you to move the selected column left or right by pressing left arrow or right arrow. Press Esc to exit Move mode.
Ctrl+A	Select all records.

Editing Data in Datasheet View

F2	Edit the current cell.
Shift+F2	Display the contents of the current field in the Zoom dialog box.
F9	Refresh the contents of a lookup field.
Ctrl+Alt+Spacebar	Insert the default value for the field.
Ctrl+;	Insert the current date.
Ctrl+:	Insert the current time.
Ctrl+’	Copy the contents from the field directly above the current field.
Ctrl++	Add a new record.
Ctrl+-	Delete the current record.
Ctrl+Enter	Start a new line in a multiline field.
Shift+Enter	Save changes to the current record.
Esc	Undo the changes in the current field. Press Esc again to undo all changes to the current record.

Navigating in Form View

Tab or right arrow	Move to the next field to the right or to the first field of the next record if you’re in the last field of a record.
Shift+Tab or left arrow	Move to the previous field to the left or to the last field of the previous record if you’re in the first field of a record.
Ctrl+Right arrow	Move to the next word in the current field if the cursor is in the field.
Ctrl+Left arrow	Move to the previous word in the current field if the cursor is in the field.
Home	Move to the first field or move to the beginning of the current field if the cursor is in the field.
End	Move to the last field or move to the end of the current field if the cursor is in the field.
Ctrl+Up arrow	Move to the current field in the first record.
Ctrl+Down arrow	Move to the current field in the last record.
Ctrl+Page Up	Move to the current field in the previous record.
Ctrl+Page Down	Move to the current field in the next record.
Ctrl+Home	Move to the first field of the first record.
Ctrl+End	Move to the last field of the last record.
Alt+F5	Activate the Record Number box. To navigate to a specific record, type the record number and press Enter.

Working in Design View

F4 or Alt+Enter	Toggle the Property Sheet pane for the current object on and off.
F5	Switch to Form view (from the form Design view).
F7	Display the Choose Builder dialog box. If the object already has code associated with it, pressing F7 displays the code.
Alt+F8	Toggle the Field List pane on and off.
Arrow keys	Move the selected control in the arrow key direction.
Ctrl+arrow keys	Move the selected control one pixel in the arrow key direction.
Shift+right arrow	Increase the width of the selected control.
Shift+down arrow	Increase the height of the selected control.
Shift+left arrow	Decrease the width of the selected control.
Shift+up arrow	Decrease the height of the selected control.

Source:
Tricks of the Microsoft Office 2007 Gurus by Paul McFedries