Ms Access Shortcut Key

Here are some common Microsoft Access shortcut keys along with their explanations:

1. Ctrl + N: New Database

   - Opens a new blank database file in Microsoft Access.

2. Ctrl + O: Open Database

   - Opens an existing database file in Microsoft Access.

3. Ctrl + S: Save Database

   - Saves the changes made to the current database file.

4. F12: Save As

   - Opens the "Save As" dialog box to save the current database with a new name or at a different location.

5. Ctrl + Z: Undo

   - Reverses the last action performed in Microsoft Access.

6. Ctrl + Y: Redo

   - Redoes the last undone action in Microsoft Access.

7. Ctrl + C: Copy

   - Copies the selected data or object to the clipboard.

8. Ctrl + X: Cut

   - Cuts the selected data or object and places it on the clipboard for pasting.

9. Ctrl + V: Paste

   - Pastes the content from the clipboard into the current location.

10. Ctrl + F: Find

    - Opens the "Find" dialog box to search for specific data within the current database.

11. Ctrl + H: Replace

    - Opens the "Replace" dialog box to find and replace specific data within the current database.

12. Ctrl + A: Select All

    - Selects all the data or objects in the current view.

13. Ctrl + P: Print

    - Opens the Print dialog box to print the current database object.

14. Ctrl + F4: Close

    - Closes the current database object.

15. Ctrl + F6: Next Pane

    - Switches to the next pane in the database window.

16. Ctrl + Tab: Next Tab

    - Switches to the next tab within the active object, like moving between tables or queries.

17. Ctrl + Shift + F2: Zoom to 100%

    - Resets the zoom level of the current view to 100%.

18. Ctrl + : (Colon): Insert Current Date

    - Inserts the current date into a field with Date/Time data type.

19. Ctrl + ; (Semicolon): Insert Current Time

    - Inserts the current time into a field with Date/Time data type.

20. Alt + Enter: Open Property Sheet

    - Opens the property sheet of the selected object.

21. F4: Open Property Sheet for Selected Control

    - Opens the property sheet for the selected control (in forms and reports).

22. F11: Database Window

    - Opens or closes the database window, which allows you to switch between different objects in the database.

These shortcuts can be very handy and save you a lot of time when working with Microsoft Access databases. Keep in mind that some shortcuts might vary depending on the version of Microsoft Access you are using and your operating system.