Check Out These Useful Keyboard Shortcuts for Working in Access Tables

Posted by: Avantix Learning Team

Posted: September 8, 2016.

Applies to: Microsoft® Access® 2007, 2010, 2013 and 2016 (Windows)

The following keyboard shortcuts work in Datasheet View in Microsoft Access tables.

Related: 10 Techniques for Designing Forms in Microsoft Access

1. Create a new record

To create a new record, press Control + plus sign (+).

2. Delete the current record

To delete the current record, press Control + minus sign (-)

3. Undo changes in the current field or record

To undo changes in the current field or record, press Escape once to undo the changes in the field or press Escape twice to undo changes in the field and record.

4. Access the menu for a combo box

To access the menu in a field with a combo box, press F4, use the up and down arrow keys to navigate through the menu and then press Enter to make a selection.

5. Force save the current record

To force save the current record, press Shift + Enter.

6. Move to the next field

To move to the next field, press Tab or right arrow.

7. Move to the previous field

To move to the previous field, press Shift + Tab or left arrow.

8. Move to a specific record

To move to the record number box, press F5 and then type the record number and press Enter.

9. Access the Find dialog box

To access the Find dialog box, press Control + F.

10. Move to the current field in the next record

To move to the current field in the next record, press down arrow.

11. Move to the current field in the previous record

To move to the current field in the previous record, press up arrow.

12. Switch between Navigation Mode and Edit Mode

To switch between Navigation Mode and Edit Mode (with the insertion point displayed), press F2.

13. Move to the first field in the current record

To move to the first field in the current record, in Navigation Mode, press Home.

14. Move to the last field in the current record

To move to the last field in the current record, in Navigation Mode, press End.

15. Move to the current field in the first record

To move to the current field in the first record, in Navigation Mode, press Control + up arrow.

16. Move to the current field in the last record

To move to the current field in the last record, in Navigation Mode, press Control + down arrow.

17. Move to the first field in the first record

Move to the first field in the first record, in Navigation Mode, press Control + Home.

18. Move to the last field in the last record

Move to the last field in the last record, in Navigation Mode, press Control + End.

19. Move up one screen

To move up one screen, press Page Up.

20. Move down one screen

To move down one screen, press Page Down.

21. Move right one screen

To move right one screen, press Control + Page Down.

22. Move left one screen

To move left one screen, press Control + Page Up.

23. Enter the value from the same field in the previous record

To enter the value from the same field in the previous record, press Control + apostrophe (‘).

24. Expand a record’s subdatasheet

To move from the datasheet and expand the record’s subdatasheet, press Control + Shift + down arrow.

25. Collapse the subdatasheet

To collapse the subdatasheet, press Control + Shift + up arrow.

Subscribe to get more articles like this one

Did you find this article helpful? If you would like to receive new articles, join our email list.

Recommended Microsoft Access training

If you’re just getting started with Access, check out our Microsoft Access: Introduction course or take your Access skills to the next level in our Microsoft Access: Intermediate / Advanced course.

VIEW ALL COURSES

Our instructor-led classroom courses are delivered at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada. If you’d like to arrange custom training, contact us to arrange a date.

To request this page in an alternate format, contact us.

Copyright 2014-2016 Avantix Learning Inc.

You may also like

Pin It on Pinterest

Share This