Skip to main content

Translate

Microsoft Access Shortcut Keys

Microsoft Access Shortcut Keys


BarneyMF Blog MS 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!

Trending Topics

Quote of the Day

Japanese surgeon fulfilled his promise to U23 Dream Team

Our Daily Devotional

Dog named Buhari: Owner reveals why he named his dog Buhari

Our Daily Devotional

Neymar Quite as Brazil Captain, find out why

Our Daily Devotional

Our Daily Devotional [02/06/2018]

Our Daily Devotional