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:

• 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