1
Manage Databases
6
 |
 Shortcut Key |
 Description |
|---|---|---|
| 1 | Ctrl+N | Open / create new database |
| 2 | Ctrl+O | Open existing database |
| 3 | Alt+F4 | Quit / exit Access |
| 4 | Ctrl+P | Print the current or selected object |
| 5 | Ctrl+N or Shift+F12 | Save a database object |
| 6 | F12 | Open the Save As dialog box |
2
Form Controls
6
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Ctrl+X | Cut |
| 2 | Ctrl+C | Copy |
| 3 | Ctrl+V | Paste |
| 4 | Arrow keys | Move Selected control up / down / left / right |
| 5 | Shift+↑ | Increase width of the selected control |
| 6 | Shift+↓ | Decrease width of the selected control |
3
Find & Replace
4
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Ctrl+F | Find dialog box |
| 2 | Ctrl+H | Find and replace dialog box |
| 3 | Shift+F4 | Find next |
| 4 | Alt+Ctrl+F | Go to the Navigation Pane search box from anywhere in the database |
4
Wizards
4
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Tab | Toogle the focus forward between controls in the wizard |
| 2 | Alt+N | Move to the next page of the wizard |
| 3 | Alt+B | Move to the previous page of the wizard |
| 4 | Alt+F | Complete the wizard |
5
Menus
7
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Shift+F10 | Show the shortcut menu |
| 2 | Alt+Space | Show the program icon menu |
| 3 | Arrow Down / Arrow Up | Select the next / select previous command in menu |
| 4 | Arrow Left / Arrow Right | Select the menu to the left / menu to the right |
| 5 | Home / End | Select first / select last command in menu |
| 6 | Esc | Close the visible menu |
| 7 | Alt | Show the access keys |
6
Text Boxes
7
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Home / End | Move beginning / move to end of an entry |
| 2 | Ctrl+→ | Move one word to the right |
| 3 | Ctrl+← | Move one word to the left |
| 4 | Shift+Home | Select from cursor to beginning |
| 5 | Shift+End | Select from cursor to End |
| 6 | Shift+← | Extend selection one character to the left |
| 7 | Shift+→ | Extend selection one character to the right |
7
Dialog Boxes
10
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Ctrl+Tab | Switch to next tab |
| 2 | Ctrl+Shift+Tab | Switch to previous tab |
| 3 | Tab | Move to next option |
| 4 | Shift+Tab | Switch to previous option |
| 5 | Arrow Keys | Move between options |
| 6 | Space | Select current button |
| 7 | Alt+↓ | Open the selected drop-down list box |
| 8 | Esc | Close the selected drop-down list box |
| 9 | Enter | Perform the action assigned to the default button in the dialog box |
| 10 | Alt+F4 | Close a dialog box |
8
Edit Text & Data
10
|
Shortcut Key |
Description |
|---|---|---|
| 1 | ←+→ | Move cursor one character to the left / right |
| 2 | Ctrl+→ | Move cursor one word to the right |
| 3 | Ctrl+← | Move cursor one word to the left |
| 4 | Home / End | Move cursor to the beginning / to the end of the field |
| 5 | Ctrl+Home | Move cursor to the beginning of the line in multi-line fields |
| 6 | Ctrl+End | Move cursor to the End of the line in multi-line fields |
| 7 | Ctrl+End | Delete all characters to the right of the insertion point |
| 8 | Ctrl+Z | Undo Changes |
| 9 | Ctrl+Y | Redo Changes |
| 10 | Esc | Cancel / undo changes in the current field or current record |
9
Field List Pane
6
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Alt+F8 | Toggle the field list pane |
| 2 | Enter | Add the selected field to the form or report detail section |
| 3 | ↑ | Move Up the field list pane |
| 4 | ↓ | Move Down the field list pane |
| 5 | Shift+Tab | Move to the upper field list pane from the lower pane |
| 6 | Tab | Move to the lower field list pane from the upper pane |
10
Design View
8
|
Shortcut Key |
Description |
|---|---|---|
| 1 | F2 | Switch between Edit and Navigation mode |
| 2 | F4 | Toggle the property Sheet |
| 3 | F5 | Switch to Form view from form Design view |
| 4 | F6 | Switch between the windows, or between design panes / properties / etc |
| 5 | F7 | Open the Visual Basic Editor from a selected property in the property sheet for a form or report |
| 6 | Alt+F8 | Invokes the Field List pane in a form, report, or data access page. If the Field List pane is alredy open, focus moves to Field List pane. |
| 7 | Shift+F7 | Switch to Form or Report Design View |
| 8 | Alt+Enter | Display a property sheet |
11
Select & move Fields or Columns
16
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Tab | Select next field |
| 2 | Shift+Tab | Select previous field |
| 3 | F2 | Switch between Edit mode and Navigation mode in a datasheet or design view |
| 4 | Shift+Space | Switch between selecting the current record and the first field of the current record |
| 5 | Shift+↑ | Extend selection to next record |
| 6 | Shift+↓ | Extend selection to previous record |
| 7 | Ctrl+A | Select all records |
| 8 | F8 | Turn on Extend mode |
| 9 | ←+→ | Extend a selection to adjacent field in the same row in Datasheet view |
| 10 | ↑+↓ | Extend a selection to adjacent rows in Datasheet view |
| 11 | Shift+F8 | Undo the previous extension |
| 12 | Esc | Cancel Extend mode |
| 13 | Ctrl+Space | Select the current column |
| 14 | Shift+→ | Select the column to the right |
| 15 | Shift+← | Select the column to the left |
| 16 | Ctrl+Shift+F8 | Turn on Move mode |
12
Insert Data
9
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Ctrl+; | Insert the current date |
| 2 | Ctrl+: | Insert the current time |
| 3 | Ctrl+Alt+Space | Insert the default value for a field |
| 4 | Ctrl+' | Insert the value from the same field in the previous record |
| 5 | Ctrl++ | Add a new record |
| 6 | Ctrl+- | In a datasheet, delete the current record |
| 7 | Shift+Enter | Save changes to the current record |
| 8 | Space | Switch between the values in a check box or option button |
| 9 | Ctrl+Enter | Insert a new line |
13
Refresh Fields
2
|
Shortcut Key |
Description |
|---|---|---|
| 1 | F9 | Recalculate the fields in the window or the contents of a lookup field |
| 2 | Shift+F9 | Requery the undelying tables |
14
Form View
3
|
Shortcut Key |
Description |
|---|---|---|
| 1 | F5 | Move the record number box, type in number and press enter |
| 2 | Tab | Move to next Field in current record |
| 3 | Shift+Tab | Move to last Field in current record |