Microsoft Access Shortcut Keys
F11
Bring the database window to the front.
CTRL + F6
Select the next database window.
CTRL + SHIFT + F6
Select the previous database window.
ENTER
Restore the selected minimized window.
CTRL + F10 , then ENTER
Restore or maximize the selected minimized window.
Taking Widely Used Actions
F2
Display the full URL for the selected hyperlink.
SHIFT + F2
Display the Zoom dialog box.
CTRL + ,
Move forward to the next available view.
CTRL + .
Move backward to the next available view.
Both Datasheet View and Form View
F5
Select the Record Number box on the status bar.
TAB, →
Select the next field.
SHIFT + TAB + ←
Select the previous field.
↓
Select the next field.
↑
Select the previous field.
HOME
Select the first field in the active record.
END
Select the last field in the active record.
CTRL + ↓
Select the current field in the last record.
CTRL + ↑
Select the current field in the first record.
CTRL + END
Select the last field in the last record.
CTRL + HOME
Select the first field in the first record.
Entering Data in Datasheet View or Form View
CTRL + ;
Insert the current data in the default format.
CTRL + SHIFT + :
Insert the current time in the default format.
CTRL + ALT + SPACEBAR
Insert the default value for the active field.
CTRL + '
Copy the value form the same field in the previous record.
CTRL + SHIFT + +
Add a new record to the database.
CTRL + -
Delete the active record.
SHIFT + ENTER
Save changes to the active record.
CTRL + ENTER
Insert a line a multilane field.
Editing Text and Data
HOME
Move the insertion point to the beginning of a single-line field.
END
Move the insertion point to the end of a single-line field.
CTRL + HOME
Move the insertion point to the beginning of multilane field
CTRL + END
Move the insertion point to the end of multilane field.
CTRL + DELETE
Delete all character from the insertion point to the end of the field.
ESC
Undo changes in the current field or current record.
Saving Databases and Creating New Databases
F10, ALT + F10
Display the Save As dialog box.
CTRL + N
Create a new database.
Changing the Number Format of a Field
CTRL + SHIFT + ~
Apply the general number format.
CTRL + SHIFT + $
Apply the currency format.
CTRL + SHIFT + %
Apply the percentage format with no decimal places.
CTRL + SHIFT + ^
Apply the exponential number format with two decimal places.
CTRL + SHIFT + #
Apply the time format with day, month, and year.
CTRL + SHIFT + @
Apply the time format with hour, minute, and am/pm.
CTRL + SHIFT + !
Apply the numeric format with two decimal places.
ENTER
To restore the selected minimized window when all windows are minimized
CTRL+F6
To cycle between open windows
F11
To bring the Database window to the front
CTRL + N
To open a new database
CTRL + O
To open an existing database
ALT+F4
To quit Microsoft Access
CTRL + P
To print the current or selected object
S
To open the Page Setup dialog box from Print Preview
P
To open the Print dialog box from Print Preview
C or ESC
To cancel Print Preview or Layout Preview
CTRL +S or SHIFT+F12 or ALT+SHIFT+F2
To save a database object
F12 or ALT+F2
To open the Save As dialog box
F4 or ALT + DOWN ARROW
To open a combo box
F9
To refresh the contents of a Lookup field, list box, or combo box
DOWN ARROW
To move down one line
You may Also Like to Read: ▼
Microsoft Outlook Shortcut Keys
PAGE DOWN
To move down one page
UP ARROW
To move up one line
PAGE UP
To move up one page
TAB
To exit the combo box or list box
CTRL + F
To open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only)
CTRL + H
To open the Replace tab in the Find and Replace dialog box (Datasheet
SHIFT + F4
To find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed (Datasheet view and Form view only)
F2
To switch between Edit mode (with insertion point displayed)
F4
To switch to the property sheet (Design view in forms and reports in databases and Access projects)
F5
To switch to Form view from form Design view
F6
To switch between the upper and lower portions of a window
F7
To switch to the Code Builder from form or report Design view
SHIFT+F7
To switch from the Visual Basic Editor to form or report Design view
ALT + V, P
To open property sheet for a selected object
SHIFT + ENTER
To add a control to a section
CTRL + C
To copy the selected control to the Clipboard
You may Also Like to Read: ▼
Microsoft Excel Shortcut Keys
CTRL + X
To cut the selected control and copy it to the Clipboard
CTRL + V
To paste the contents of the Clipboard in the upper-left corner of the selected section
CTRL + RIGHT ARROW
To move the selected control to the right
CTRL + LEFT ARROW
To move the selected control to the left
CTRL + UP ARROW
To move the selected control up
CTRL + DOWN ARROW
To move the selected control down
SHIFT + DOWN ARROW
To increase the height of the selected control
SHIFT + RIGHT ARROW
To increase the width of the selected control
SHIFT + UP ARROW
To reduce the height of the selected control
SHIFT + LEFT ARROW
To reduce the width of the selected control
TAB
To move to the Help button in the wizard
ALT + N
To move to the next window in the wizard
ALT + B
To move to the previous window in the wizard
ALT + F
To close the wizard window
ALT + F, D, A
To send the active database object as an e-mail message
CTRL + SHIFT + B
To open the Address Book
ALT + K
To check the names in the To, Cc, and Bcc boxes against the Address Book
TAB
To 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 a
SHIFT + TAB
To select the previous field or button in the e-mail header
F2
To display the complete hyperlink address for a selected hyperlink
F7
To check spelling
SHIFT+F2
To open the Zoom box to conveniently enter expressions and other text in small input areas
ALT + ENTER
To display a property sheet in Design view
ALT+F4
To quit Microsoft Access, close a dialog box, or close a property sheet
CTRL+F2
To invoke a Builder
CTRL+F11
To toggle between a custom menu bar and a built-in menu bar
CTRL + RIGHT ARROW or CTRL +, (COMMA
To toggle forward between views when in a table, query, form, report, page, view, PivotTable list
CTRL + LEFT ARROW or CTRL+. (PERIOD)
To toggle back between views when in a table, query, form, report, page, view, PivotTable list, PivotChart report.
F6/Shift-F6
Cycle through sections
Ctrl-Tab
Cycle through tab of each object's type (forward)
F11
Database window
F2
Edit/Navigation mode (toggle)
Ctrl-Alt-spacebar
Insert default value
Ctrl-Home/End
Move to beginning/end of multiple-line field
Home/End
Move to first/last field in current record (Navigation mode)
End or Ctrl-Right
Move to right edge of page
Ctrl-Enter
Open in Design view
Alt-Enter
Property sheet
F9
Refresh combo box
Shift-Enter
Save current record
Ctrl-spacebar
Select/unselect column (Navigation mode)
Shift-F8
Undo previous extension
Shift-F2
Zoom box
Displaying, Hiding, Sorting, and Filtering Data
CTRL + 8
Toggle the display of the expand indicators beside items.
CTRL + =
Expand the selected item.
CTRL + -
Hide the current item.
CTRL + SHIFT + A
Sort the selected field's data in ascending order.
CTRL + SHIFT + Z
Sort the selected field's data in descending order.
ALT + SHIFT + ↑
Move the selected item up.
ALT + SHIFT + ←
Move the selected item to the left.
ALT + SHIFT + ↓
Move the selected item down.
ALT + SHIFT + →
Move the selected item to the right.
Recalculating and Refreshing Data
F9
Recalculating the fields in the window, or refresh a Lookup field or drop-down list.
SHIFT + F9
Require the data source to update records.
Find and Replacing Items
CTRL + F
Display the Find tab of the Find and Replace dialog box.
CTRL + H
Display the Replace tab of the Find and Replace dialog box.
SHIFT + F4
Find the next instance of the search text.
Extending the selection
F8
Turn on extend mode and extend the selection.
←, ↑, →, ↓
Extend the selection to the field to the left, Previous, right, Next row.
SHIFT + F8
Undo the previous extension.
SHIFT + →
Extend the selection to the column to the right.
Editing Controls in Design View
SHIFT + ENTER
Add a control to the active section.
CTRL + RIGHT ARROW
Move the selected control right one pixel, ignoring the grid.
CTRL + LEFT ARROW
Move the selected control left one pixel, ignoring the grid.
SHIFT + LEFT ARROW
Decrease the width of the selected control by one pixel.
SHIFT +RIGHT ARROW
Increase the width of the selected control by one pixel
SHIFT + UP ARROW
Decrease the height of the selected control by one pixel.
Selecting Fields and Records
TAB
Select the next field.
SHIFT + SPACEBAR
Toggle between selecting a record and selecting the first field of the record.
SHIFT + UP ARROW
Extend the selection from the current record to the previous record.
SHIFT + DOWN ARROW
Extend the selection from the record to the next record.
CTRL + A
Select all the records.
CTRL + SHIFT + SPACEBAR
Select all the records.
Working in the Gird Pane
F2
Toggle between Edit mode and Navigation mode.
Insert
Toggle between Insert mode and Overstrike mode.
Working with Subdatasheets
CTRL + SHIFT + ↓
Expand the sub datasheet.
CTRL + SHIFT + ↑
Collapse the sub datasheet.
You may also like to read.▼
Microsoft Word Shortcut Keys
TAB
Move from the last field of the previous record to the sub datasheet.
SHIFT + TAB
Move from the first field of the following record to the sub datasheet.
CTRL + TAB
Move from the sub datasheet to the first field of the next record.
CTRL + SHIFT + TAB
Move from the sub datasheet to the last field of the previous record.
Moving Columns in Datasheet View
CTRL + SHIFT + F8
Switch on Move mode.
←, →
Move the selected Columns to the left and right in Move mode.
PivotTable View
TAB
Select the next element to the right or down.
SHIFT + TAB
Select the next element to the left or up.
ENTER
Select the next element or to the right.
SHIFT + ENTER
Select the next element up.
CTRL + ENTER
Select the detail cells for the next item in the row area.
CTRL + SHIFT + ENTER
Select the detail cells for the previous item in the row area.
CTRL + SHIFT + END
Extend the selection to the last cell in the last row.
CTRL + SPACEBAR
Select the field for the active data, total, or detail item.
SHIFT + SPACEBAR
Select the row containing the active cell.
SHIFT + PAGE DOWN
Extend the selection by one screen.
SHIFT + PAGE UP
Reduce the selection by one screen.
ALT + PAGE DOWN
Display the next screen to the right.
ALT + PAGE UP
Display the next screen to the left.
ALT + SHIFT + PAGE DOWN
Extend the selection by one page to the right.
ALT + SHIFT + PAGE UP
Extend the selection by one page to the left.
CTRL + E
Export the contents of the PivotTable or Excel.
Navigation
DOWN ARROW
Move down one line.
UP ARROW
Move up one line.
PAGE DOWN
Move down one page.
PAGE UP
Move up one page.
Navigating in Print Preview
F5
Select the page number box.
PAGE DOWN, ↓
Display the next page.
PAGE UP, ↑
Display the previous page.
←, →, ↑, ↓
Scroll in small increments.
CTRL + ↑
Scroll to the top of the page.
CTRL + ↓
Scroll to the bottom of the page.
CTRL + →, END
Scroll to the right side of the page.
CTRL + ←, HOME
Scroll to the left side of the page.
CTRL + HOME
Scroll to the upper-left corner of the page.
CTRL + END
Scroll to the lower-right corner of the page.
Navigating in Datasheet View
PAGE DOWN
Display the next screen of data downward.
PAGE UP
Display the next screen of data upward.
CTRL + PAGE DOWN
Display the next screen of data to the right.
You may also like to read.▼
Abbreviated Keys on the Computer Keyboard
CTRL + PAGE UP
Display the next screen of data to the left.
Navigating in the Objects Bar and Object List
CTRL + TAB
Select the next item in the Objects bar.
CTRL + SHIFT + TAB
Select the previous item in the Objects bar.
UP ARROW
Move the selection up one line.
ENTER
Open or run the selected object.
ALT + O
Open the selected object.
ALT + N
Create a new object of the selected type.
CTRL + ENTER, ALT + D
Open the selected object in Design view.
Navigating in the Database Diagram Window
ESC
Move to the table's title bar from a cell.
ENTER
Move back to the last cell edited from the table's title bar.
PAGE UP
Display the previous page of the table or diagram.
PAGE DOWN
Display the next page of the table or diagram.
Navigating in Design View
F4, ALT, ENTER
Display the property sheet.
F5
Switch a form from Design view to Form view.
F6
Switch between the upper part and lower part of a window.
F7
Switch to the Code Builder from Design view.
If you find this article Educative and would like your friends to read this as well.
Hit the Share Button! Follow us on our Social Networks.
Thanks!
Thanks!
