7 Handy Microsoft Access Editing Shortcuts

Keyboard Shortcuts, Microsoft Access Tips & Tricks

Data entry and editing is often a time-consuming part of working with Microsoft Access data tables. To be more productive, try these Access editing shortcuts to save time working with Access data in the datasheet view:

Microsoft Access editing shortcuts

  • Add a new record: [Ctrl] + + (plus sign)
  • Insert the value from the same field in the previous record: [Ctrl] + ‘ (single quote/apostrophe)
  • Delete the current record: [Ctrl] + – (minus sign)
  • Insert the current date: [Ctrl] + ; (semicolon)
  • Insert the current time: [Ctrl] + : (colon)
  • Zoom into entry: [Shift] + F2 (also very helpful for creating and editing query criteria)
  • Switch between navigation mode (selected field) and editing mode: F2

Do you want more Access shortcuts?

Download your own copies of Microsoft Access handouts for keyboard shortcuts and query operators at: TheSoftwarePro.com/Access

© Dawn Bjork, MCT, MOSM, CSP®, The Software Pro®
Microsoft Certified Trainer, Productivity Speaker, Certified Speaking Professional

Previous Post
Microsoft Outlook Dark Mode: Changing the Theme in Outlook
Next Post
Microsoft Excel: 5 Handy Data Entry Tips

Related Posts

Join Our Tips Newsletter

Receive 477+ shortcuts & more!


  • Your cart is empty.