Access 2019 For Dummies Cheat Sheet - dummies
Cheat Sheet

Access 2019 For Dummies Cheat Sheet

From Access 2019 For Dummies

By Laurie A. Ulrich, Ken Cook

Access 2019 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 2019, you can organize data into tables, design forms for editing and reports for presenting, and create queries for finding information!

Navigating the Access 2019 Ribbon with Key Tips

If you like keyboard shortcuts when you’re working with software, Access 2019 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 2019 (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.


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.


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 2019 Keyboard Shortcuts

The following keyboard shortcuts are especially useful in Access 2019. Some keystrokes work anywhere in Access 2019, 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 the selection to the Clipboard
Ctrl+V Pastes the 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 the 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
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