This article is about MS Access Shortcut Keys. MS Access is one of the most important and widely used applications found on the computer. A database is a collection of logically related and similar data. The database stores a similar kind of data for a specific purpose that is organized in such a manner that any information can be retrieved from it when needed, Microsoft Access is an application that always creates the database. Microsoft Access is a Relational Database Management System (RDBMS).
It was first released in 1991 as Access 1.0 and has been the most commonly used database for small businesses and personal use since then. It is commonly used for storing and managing data for small business applications such as sales and inventory, or for personal use such as a simple address book.
MS Access Shortcut Keys
MS Access Shortcut keys are a great way to speed up your workflow without investing a lot of time and energy. The most commonly used shortcut keys in MS Access are Ctrl + S (save), Ctrl + O (open), and Alt + F4 (close window/application. However, there are many more shortcut keys that can make your life easier. For example, Ctrl + Z (undo) and Ctrl + C (copy), save you time and make it possible to perform multiple actions at once.
List of MS Access Shortcut Keys | MS Access Shortcut Keys PDF
| Shortcut Keys | Functions |
|---|---|
| Ctrl + N | Create a new Database |
| Ctrl + O | Open an existing Database |
| Alt + N | Create a new Database object |
| Alt + O | Open Database object |
| Ctrl + P | Print the current or selected database object |
| Ctrl + C | Copy the selected object |
| Ctrl + X | Cut the selected object |
| Ctrl + V | Paste the cut / Copied object |
| Delete | Delete an object |
Working with Tables
| Shortcut Keys | Functions |
|---|---|
| Ctrl + Plus sign (+) | Add new record |
| Ctr + Semicolon (;) | Insert the current data |
| Ctrl + Shift +Colon(:) | Insert the current time |
| Ctrl + Alt + Spacebar | Insert the default value for a field |
| Ctrl + Apostrophe(‘) | Insert the value from the same field as the previous record |
| Ctrl + A | Select all records |
| Ctrl + Minus sign (-) | Delete the current record |
| Esc | Undo changes made to the current field/record |
| Tab | Next field |
| Shift + Tab | Previous field |
| Page Down | Next screen |
| Page Up | Previous screen |
| Ctrl + Up arrow | First record |
| Ctrl + Down arrow | Last record |
| Down arrow | Next record |
| Up arrow | Previous record |
Design View
| Shortcut Keys | Functions |
|---|---|
| Alt + D | Open a Database object in the design view |
| Alt + Enter | Display a property sheet in the design view |
| Alt + V + P | Open the property sheet for the selected object in the design view |
Common Tasks
| Shortcut Keys | Functions |
|---|---|
| Ctrl + B | Bold letters |
| Ctrl + I | Italicise letters |
| Ctrl + U | Underline letters |
| Ctrl + F | Find text |
| Ctrl + H | Replace text |
| F5 | Refresh |
| F2 | Rename |
| Ctrl + A | Select All |
| Ctrl + Y | Redo Last Action |
| Ctrl + Z | Undo Last Action |
| Ctrl + W | Close the active window |
| Ctrl + Shift + A | Sort selected data in ascending order |
| Ctrl + Shift + Z | Sort selected dates in descending order |
| F7 | Check to spell |
Download MS Access Shortcut Keys PDF
Click on the download button to download the MS Access Shortcut Keys List in a PDF format. If you want to know more advanced shortcut keys for the computer, then write a comment below.
