Many users find that using an external keyboard with keyboard shortcuts for Access desktop databases on Windows helps them work more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using a mouse.
Notes:
This table itemizes the most frequently used shortcuts in Access desktop databases.
Top of Page Learn how to use your keyboard to open and save databases and print database information.
Top of Page
Top of Page Use your keyboard to navigate and edit content in a text box, combo box, or list box. An edit box is a blank text box in which you type or paste an entry, such as your username or the path of a folder.
Top of Page A list box displays a range of unchangeable values or choices, which are automatically listed. A combo box also displays values or choices, but it does not display them until you select a dropdown arrow. With a combo box, you can sometimes enter a value that’s not on the list, as you can with a text box.
Top of Page Use keyboard shortcuts to edit and move within the Objects list and to navigate and open objects.
Top of Page
Top of Page
Top of Page Use the Datasheet View when you work with tables and queries. These keyboard shortcuts work in Navigation mode in the Datasheet View.
Top of Page
Top of Page
Top of Page
Note: To navigate between fields and records in a subdatasheet, use the same keyboard shortcuts you use in the Datasheet View. Top of Page You work in the Design View when you design tables, queries, forms, reports, and macros.
Top of Page
Top of Page Learn how to use keyboard shortcuts with diagram, grid, SQL, or Field List panes.
Note: If multiple items are selected, pressing Spacebar affects all selected items. Select multiple items by holding down Shift while selecting them. Toggle the selected state of a single item by holding down Ctrl while selecting it. Top of Page
Top of Page You can use the standard Windows editing keys when working in the SQL pane. For example, you can use Ctrl+Arrow keys to move between words, and the Cut, Copy, and Paste commands on the Home tab work as they normally do. You can only insert text; there is no overtype mode.
Note: In the SQL view, Ctrl+A to select all text is only supported in Microsoft 365, Access 2016 Click-to-Run, and Access 2019. As an alternative, press F2.
Top of Page Learn how to use your keyboard to select a field, record, or text within a field. You can also use keyboard shortcuts to extend your selection or find and replace text or data.
Note: To cancel a selection, use the opposite arrow key.
Top of Page
Top of Page
Top of Page
Top of Page Use the keyboard shortcuts in the following sections to navigate to an insertion point within a field, copy, move, or delete text, and undo changes. You can also use your keyboard to enter data in the Datasheet View or Form View and refresh fields.
Note: If the insertion point is not visible, press F2 to display it.
Top of Page
Top of Page
Top of Page
Top of Page
Top of Page The Help window provides all Access help content.
Top of Page
Top of Page Screen reader support for Access Use a screen reader to explore and navigate Access Use a screen reader to start Access Microsoft wants to provide the best possible experience for all our customers. If you have a disability or questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance. The Disability Answer Desk support team is trained in using many popular assistive technologies and can offer assistance in English, Spanish, French, and American Sign Language. Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region. If you are a government, commercial, or enterprise user, please contact the enterprise Disability Answer Desk. |