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
