Access 2016 For Dummies
Book image
Explore Book Buy On Amazon
Access 2016 makes managing data easy, enabling you to set up a database quickly, enter records into that database, and then use the data however you like. With Access 2016, you can organize data into tables, design forms for editing and reports for presenting, and create queries for finding information!

Navigating the Access 2016 Ribbon with Key Tips

If you like keyboard shortcuts when you’re working with software, Access 2016 has a Key Tips feature that can help make entering data move more quickly. The following section describes how to use it:

  1. Press the Alt key.

    When you want to switch tabs and issue commands with the keyboard in Access 2016 (rather than with the mouse), press the Alt key. As shown in the following figure, pressing Alt causes numbers and letters to appear in small squares on the Quick Access Toolbar and the Ribbon’s tabs.

    image0.jpg

  2. Press a Key Tip to set the focus to that item (like C in this case for the Create tab).

    Key Tips appear for the item, as shown in the following figure.

    image1.jpg

  3. Press a Key Tip (like TN to create a new table).

    When you press one of the characters on your keyboard, the command assigned to the Key Tip runs.

Handy Access 2016 keyboard shortcuts

The following keyboard shortcuts are especially useful in Access 2016. Some keystrokes work anywhere in Access 2016, whereas others work only in specific views, as noted below.

Keystroke Function
F1 Opens the Help window.
Alt+F Opens the File tab.
Ctrl+N Creates a new blank database.
Ctrl+O Opens an existing database.
Ctrl+P Opens the Print dialog box.
F11 Shows/hides the Navigation pane.
F6 Cycles different areas of the program window.
Alt+H Displays the Home tab on the Ribbon.
Alt+C Displays the Create tab on the Ribbon.
Alt+X Displays the External Data tab on the Ribbon.
Ctrl+S Saves the current object in Design mode.
Ctrl+C Copies selection to the Clipboard.
Ctrl+V Pastes selection from the Clipboard.
F12 Opens the Save As dialog box.
Ctrl+F4 Closes the active document window.
Alt+F4 Closes the active application window.
Ctrl+Z Undoes the last operation.
Ctrl+; Inserts the current date.
Ctrl+: Inserts the current time.
Ctrl+’ Copies same field data from previous record.
F2 Toggles selecting all data in the field or placing cursor in
edit mode.
F9 Recalculates fields on a form or refreshes a lookup combo or
list box list.
Ctrl+Enter Inserts a line break in Datasheet and Form view.
Ctrl+Enter Opens selected object from Navigation pane in Design view.
Ctrl+ + Inserts a new record.
Ctrl+- Deletes current record.
Right Arrow Moves selected control to the right in Design or Layout
view.
Left Arrow Moves selected control to the left in Design or Layout
view.
Down Arrow Moves selected control down in Design or Layout view.
Up Arrow Moves selected control up in Design or Layout view.
Shift+Right Arrow Increases selected control width in Design or Layout view.
Shift+Left Arrow Decreases selected control width in Design or Layout view.
Shift+Down Arrow Increases selected control height in Design or Layout
view.
Shift+Up Arrow Decreases selected control height in Design or Layout
view.
F4 Toggles property sheet window in Design view.
Shift+F2 Zooms in on current field in Datasheet and Form view.

About This Article

This article is from the book:

About the book authors:

Laurie Ulrich Fuller is a professional technology author and trainer. She's created training materials that cover Microsoft Office and Adobe Creative Suite. Ken Cook is a professional database developer, instructor, and author. The two experts have teamed to write the previous three editions of Access For Dummies.

This article can be found in the category: